Confluence Docs 3.0 : Database Configuration This page last changed on Oct 26, 2009 by jlargman. 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
| The XML backup built into Confluence is not well suited for database migration for large data sets (see Alternative Backup Strategy for reference). Choose your database wisely; if you need to migrate later, Atlassian support will refer you to a third party database migration tool. Vote for CONF-12599 to add a more robust strategy for large implementation migrations.
Below is more information on selecting and migrating to an external database: Migrating to a Different Database List Of Supported Databases Known Issues For Supported Databases ## Database Setup Setup instructions are shown below. Click a database to review the setup guide and any known issues. MySQL
Database Setup For MySQL
Known Issues for MySQL
PostgreSQL
Database Setup for PostgreSQL on Windows
Known Issues for PostgreSQL
Database Setup For Any External Database
Oracle
Known Issues For Oracle
Database Setup for Oracle
SQL Server
Known Issues For SQL Server
Database Setup for SQL Server
DB2
Known Issues for DB2
Other databases should use these instructions. ## Optimising Database Performance To improve database responsiveness: Improving Database Performance Known Issues For Supported Databases ## Database Troubleshooting 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.

Document generated by Confluence on Nov 05, 2009 23:34