This document provides information on connecting Confluence to an external database.
The embedded HSQLDB database for evaluation purposes
If you are using the embedded database, the database files are stored in the
\database directory under your Confluence Home and other important directories.
Note: The embedded HSQLDB database is not suitable for production Confluence sites.
Production sites should use an external database. See our guide to database configuration. When using the default HSQLDB database, you run the risk of irrecoverable data loss because HSQLDB is not transaction safe.
- Corruption is occasionally encountered after sudden power loss. It can usually be corrected using the data recovery procedure documented in our knowledge base.
- HSQLDB is suitable for evaluation purposes, but the risk can only be eliminated by switching databases. This is essential when you move from an evaulation to a production site. External databases may also provide superior speed and scalability.
To find out if you are still using the embedded database, go to > General Configuration > Atlassian Support Tools > Health Check.
Selecting an external database
Note: Take time to choose your database wisely. The XML backup built into Confluence is not suited for migration or backup of large data sets. If you need to migrate later, you will need to use a third party database migration tool.
Below is more information on selecting and migrating to an external database:
Here are the setup instructions for the supported databases:
- Database Setup for Oracle
- Database Setup For MySQL
- Database Setup for PostgreSQL
- Database Setup for SQL Server
Optimising database performance
To improve database responsiveness:
For solving database-related problems:
- Troubleshooting External Database Connections
- Troubleshooting the Embedded HSQLDB Database
- How to Interpret DB2 Error Codes
- Database Troubleshooting
Obtain technical support from Troubleshooting Problems and Requesting Technical Support.
Issue CONF-12599 requests a more robust strategy for migrating large Confluence sites.
Was this helpful?
Thanks for your feedback!