This document provides information on configuring an external database.
Production instances of Confluence should use an external database. The default hSQL database has a risk of unrecoverable data loss due to not being transaction-safe.
Corruption is occassionally encountered after sudden power loss and can usually be corrected using this data recovery procedure. hSQL 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. Below is more information on selecting an external database.
Setup instructions are shown below; click on a database to review the setup guide and any known issues.
Other databases should use Database Setup For Any External Database.
To improve database responsiveness:
For solving database-related problems:
- Troubleshooting External Database Connections
- Troubleshooting the Embedded Database (hSQL DB)
- Interpreting DB2 error codes
- Known Issues For Supported Databases
Obtain technical support from Troubleshooting Problems & Requesting Technical Support