This server will be upgraded at 3pm Sydney time on December 3rd (December 2nd, 8pm PST) and will be down for up to 30 minutes.
This documentation relates to the latest version of Confluence.
If you are using an earlier version, please go to the documentation home page and select the relevant version.

Database Configuration

Added by Vidya Madabushi, last edited by Sarah Maddox on Mar 12, 2008  (view change)
All Versions
Click for all versions
Confluence 2.10 Documentation

Index

This document provides information on configuring an external database.

The Embedded Database for Evaluation Purposes

The Confluence installation includes an embedded HSQLDB database, supplied for the purpose of evaluating Confluence.

If you are using the embedded database, the database files are stored in the \database folder under your Confluence Home directory. See also Important Directories and Files.

Embedded Database is Not Suitable for Production Instances of Confluence

Production instances of Confluence should use an external database. When using the default HSQLDB database, you run the risk of unrecoverable data loss due to not being transaction safe.

  • Corruption is occasionally encountered after sudden power loss and can usually be corrected using this data recovery procedure.
  • HSQLDB is still suitable for evaluation purposes, but the risk can only be eliminated by switching databases. External databases may also provide superior speed and scalability.

Selecting an External Database

Below is more information on selecting and migrating to an external database:

Database Setup

Setup instructions are shown below. Click a database to review the setup guide and any known issues.

MySQL

PostgreSQL

Oracle

SQL Server

DB2

Sybase Database

Other databases should use these instructions.

Optimising Database Performance

To improve database responsiveness:

Database Troubleshooting

For solving database-related problems:

Obtain technical support from Troubleshooting Problems & Requesting Technical Support.

Labels

database database Delete
configuration configuration Delete
setup setup Delete
db db Delete
filter-common-tasks filter-common-tasks Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.

Comments (2)

 

  1. Apr 14, 2008

    Anonymous says:

    Hi,    Which default table to store the Page informations)like pageid...

    Hi,

       Which default table to store the Page informations)like pageid, pagename, permission details etc)?

     Thanks!

    1. Apr 14, 2008

      James Fleming [Atlassian] says:

      The schema documentation would be the place to start, in combination with using ...

      The schema documentation would be the place to start, in combination with using DBvisualiser to explore the database contents.

Add Comment