This page last changed on Jun 22, 2007 by smaddox.

This document provides information on configuring an external database.

Database Selection

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.

Database Setup

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

MySQL

PostgreSQL

Oracle

SQL Server

DB2

Sybase Database

Other databases should use Database Setup For Any External Database.

Optimise Database Performance

To improve database responsiveness:

Database Troubleshooting

For solving database-related problems:

Obtain technical support from Troubleshooting & Technical Support

Document generated by Confluence on Oct 10, 2007 18:49