Database Configuration

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:

About the embedded H2 database 

We ended support for the H2 database in Confluence 8.0. If you wish to continue your development cycle with the H2 database in Confluence 8.0 or later, you will need to upgrade to AMPS 8.6.0. 

The embedded H2 database is only for testing and app development purposes on non-clustered (single node) Confluence Data Center installations.

To find out if you are still using the embedded database, go to  > General Configuration > Troubleshooting and support tools.

Database setup

To find out how to set up your database, see:

Database drivers

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. 

Database troubleshooting

For database-related problems see Database Troubleshooting

If you need more help, check out Troubleshooting Problems and Requesting Technical Support.

Last modified on Nov 29, 2022

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.