nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Migrating off embedded H2 database to MySQL 5.7.24

Byron_fj8l0g

As Per https://confluence.atlassian.com/doc/database-configuration-159764.html :

Your Confluence installation includes an embedded H2 database, to enable you to try Confluence without setting up an external database. The embedded H2 database is only supported while you are evaluating Confluence. You must migrate to a supported external database before using Confluence as a production system.

...

Just purchased a license to turn my eval into a purchased copy. I then learned that I had to migrate off the embedded H2 DB to something else. I chose MySQL.

Unfortunately the instructions do not explain how to configure it to work with MySQL 5.7 (listed as a supported DB).

See the following link:

https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

Under "To Configure MySQL Server", look for item 1. Run the MySQL installation wizard.

Clicking "Reconfigure" doesn't provide an "Advanced configuration" option in MySQL 5.7.24.
You have two options: Standard Alone/Cluster MySQL Replication and Sandbox InnoDB Cluster Setup (for testing only).

Please provide me the steps to get my system up and running. We rely on this everyday and it's lame that you don't have instructions on how to setup this up after I shelled out money to go from eval to production. Thanks

Accepted answers

All comments

Shannon S

Hi there,

I assume you are installing this on Windows? If you have a screenshot of all of the screens you run into could you share that with me? If there's a problem with the documentation I want to submit it to be corrected.

For your setup, I would recommend skipping 2.1 and going to 2.2 where you modify the configuration file. You'll want to completely install MySQL first using the installer, then make sure Confluence is stopped and proceed with 2.2.

Let me know if you have any trouble.

Regards,

Shannon

Byron_fj8l0g

Hello,

Sent a reply via email but it bounced. Here's my response:

You wrote:

My response:

I will skip 2.1 and 2.2, but how does MySQL need to be setup? Your docs specifically state that the InnoDB option is required for Confluence, yet the option specifically states “TEST” in the setup screen. This is not a test environment.

Here are the MySQL 5.7.24 first couple of setup screens…

Let me know what I should choose

If I choose StandAlone MySQL / Classic MySQL Replication I have the following options:

If I choose this option, I need to choose a config type. This would be Server I believe. Click Next.

I enter the root password on the next screen. Click Check and then next.

In the Windows Server window I'm given the option to configure mysql to run as a service. I leave the default and lick next.

On the Plugins and extensions screen, do I leave the default and click Next?

The screen that follows is simply to execute the setup.

If I choose the Sandbox InnoDB Cluster Setup (for testing only) route from the main setup screen, I get these options:

What Cluster size do I use? Plus it specifically states “TEST”, which we’re not running. This is production.

Thanks

Byron_fj8l0g

Hello,

Sent a reply via email but it bounced. Here's my response:

You wrote:

My response:

Here are the MySQL 5.7.24 first couple of setup screens…

Let me know what I should choose

If I choose StandAlone MySQL / Classic MySQL Replication I have the following options:

If I choose this option, I need to choose a config type. This would be Server I believe. Click Next.

I enter the root password on the next screen. Click Check and then next.

In the Windows Service window I'm given the option to configure mysql to run as a service. I leave the default and lick next.

On the Plugins and extensions screen, do I leave the default and click Next?

The screen that follows is simply to execute the setup.

If I choose the Sandbox InnoDB Cluster Setup (for testing only) route from the main setup screen, I get these options:

What Cluster size do I use? Plus it specifically states “TEST”, which we’re not running. This is production.

Thanks

Byron_fj8l0g

Hello,

Sent a reply via email but it bounced. Here's my response:

You wrote:

My response:

Here are the MySQL 5.7.24 first couple of setup screens…

Let me know what I should choose

If I choose StandAlone MySQL / Classic MySQL Replication I have the following options:

If I choose this option, I need to choose a config type. This would be Server I believe. Click Next.

I enter the root password on the next screen. Click Check and then next.

In the Windows Service window I'm given the option to configure mysql to run as a service. I leave the default and lick next.

On the Plugins and extensions screen, do I leave the default and click Next?

The screen that follows is simply to execute the setup.

If I choose the Sandbox InnoDB Cluster Setup (for testing only) route from the main setup screen, I get these options:

What Cluster size do I use? Plus it specifically states “TEST”, which we’re not running. This is production.

Thanks

Byron_fj8l0g

Hello,

Sent a reply via email but it bounced. Here's my response:

You wrote:

My response:

Here are the MySQL 5.7.24 first couple of setup screens…

Let me know what I should choose

If I choose StandAlone MySQL / Classic MySQL Replication I have the following options:

If I choose this option, I need to choose a config type. This would be Server I believe. Click Next.

I enter the root password on the next screen. Click Check and then next.

In the Windows Service window I'm given the option to configure mysql to run as a service. I leave the default and lick next.

On the Plugins and extensions screen, do I leave the default and click Next?

The screen that follows is simply to execute the setup.

If I choose the Sandbox InnoDB Cluster Setup (for testing only) route from the main setup screen, I get these options:

What Cluster size do I use? Plus it specifically states “TEST”, which we’re not running. This is production.

Thanks

Byron_fj8l0g

Hello,

Sent a reply via email but it bounced. Here's my response:

You wrote:

My response:

Here are the MySQL 5.7.24 first couple of setup screens…

Let me know what I should choose

If I choose StandAlone MySQL / Classic MySQL Replication I have the following options:

If I choose this option, I need to choose a config type. This would be Server I believe. Click Next.

I enter the root password on the next screen. Click Check and then next.

In the Windows Service window I'm given the option to configure mysql to run as a service. I leave the default and click next.

On the Plugins and extensions screen, do I leave the default and click Next?

The screen that follows is simply to execute the setup.

If I choose the Sandbox InnoDB Cluster Setup (for testing only) route from the main setup screen, I get these options:

What Cluster size do I use? Plus it specifically states “TEST”, which we’re not running. This is production.

Thanks for your help. Please provide me some updated docs/steps asap.

Diego_88dj6o

Hello there!
You should be good to go by setting the MySQL application as Server Computer and as Windows service as well. It should prevent the Confluence server form coming up without a database. It is a good idea to start the database before starting Confluence.
A few thing that you need to take in consideration when running an external database:

- the database is reachable by the application
- there is enough disk space for the database to use
- there is enough memory for the database to use
- the ports used by the database are free

You can check further information about the MySQL installer here:

- MySQL Installer Workflow

Also, there is no need to activate the plugins shown with the installer. After finishing the setup, you can end the MySQL process and apply the necessary changes to your my.ini file, as shown here:

- Database setup for MySQL

After adding or changing the necessary variables, you should be able to create the database that is going to be used. The steps that need to be taken are also described in the Database Setup document. Do not forget to get the correct MySQL driver for Confluence:

- Database JDBC Drivers

After placing the driver into <installation-directory>/confluence/WEB-INF/lib, you should be able to start the Confluence setup with the external database.

One last thing that you may need to look into is the Migrating to another database document. There you will have more information on how to migrate from H2 to external database:

- Migrating to another database

Let us know if this sheds some light into the situation!

Shannon S

Hello,

You actually don't want to skip 2.2, just 2.1. Step 2.2 comes after the database server has already been set up.

I've asked my colleague Diego to reply on this thread as well, as he has a few ideas on how you can get started if you're not so familiar with MySQL setup.

Please review his instructions, and let us know if you have any trouble!

Regards,

Shannon

Byron_fj8l0g

Hi Diego,

Thanks for your help.

I'm at the Database setup for MySQL step.

When you say "After adding or changing the necessary variables", are you referring to step 2.2 on this page?

https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

Thanks

Byron_fj8l0g

Thanks Shannon. I've asked for Clarification from Diego on one setup that I believe relates to 2.2 on https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html.

You can see my question above in my response to him.

Thanks

Byron_fj8l0g

Hi Diego - Patiently awaiting your response. Please respond to my answer above, posted on Wednesday. Thanks.

Diego_88dj6o

Hi Byron!

Yes, I referenced the step where we need to change or insert variable values into the my.ini/my.cnf file.

Having the correct values there is essential for the database to work with Confluence!

Let us know if there are still questions.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server