This document provides information on connecting Confluence to an external database.
Choosing 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 may need to use a third party database migration tool.
Below is more information on selecting and migrating to an external database:
To find out how to set up your database, see:
- Database Setup for Oracle
- Database Setup For MySQL
- Database Setup for PostgreSQL
- Database Setup for SQL Server
- Configuring Confluence Data Center to work with Amazon Aurora
H2 database for development only
We no longer support use of H2 database for production environments. If you wish to continue using the H2 embedded database for testing and app development on non-clustered (single node) installations only, make sure you're using AMPS 8.6.0.
To find out if you are still using the embedded database, go to > Troubleshooting and support tools > General Configuration.
You must use a supported database driver. See Database JDBC Drivers for the drivers we support.
If you attempt to use an unsupported or custom JDBC driver (or a
driverClassName from an unsupported or custom driver in your JINDI datasource connection) collaborative editing will fail.
Database connection method
You can connect Confluence to your database using a JDBC URL.
By default the setup wizard only provides the option to use a JDBC connection, as this is the recommended connection method.
For database-related problems see Database Troubleshooting.
If you need more help, check out Troubleshooting Problems and Requesting Technical Support.