upgrading to confluence 5.10. Do I upgrade Mysql beforehand?

[Linda Petty]

I'm upgrading confluence to 5.10 using the installer

I know Mysql needs to be upgraded to 5.5 to be compatible with this.

Does the Confluence installer include the MySQL upgrade?

Or should I upgrade MySQL mysql before running the Confluence upgrade?

I don't seem to find an answer in the upgrade documentation. 

[Daniel Eads {unmonitored account} · Accepted solution]

Hi Linda,

Based on the supported platforms page for Confluence 5.10, it looks like MySQL 5.6.39 (latest available 5.6.x release) is the one you're going to want to go to. Although 5.5 is compatible, looks like there were some issues that weren't actually fixed - the resolution on a couple of those Resolved tickets is "upgrade to 6.0".

I would recommend the following sequence of events:

1. Stop Confluence
2. Take a MySQL backup
3. Upgrade MySQL to 5.6.39
4. Upgrade Confluence to 5.10 using the installer (it will make a backup of your installation directory automatically - also consider letting the installer back up your home directory if you don't have daily backups in place)
5. Make any adjustments you need to make to your install, such as modifying server.xml with any proxy settings you have or setenv.sh/.bat to set the amount of RAM Confluence should use. The upgrade documentation should call this out, but it's an important step so it's worth repeating every time you get the chance :)
6. Start Confluence

When you start Confluence after an upgrade, it will make changes to the database so that things are compatible on Confluence's side. To directly answer your question, Confluence does not contain a MySQL upgrade - you will need to upgrade MySQL separately. Confluence will just take steps to make sure its own data is compatible with your freshly-upgraded MySQL.

Cheers,
Daniel

[Linda Petty]

Many thanks Daniel

I had in fact already decided to use MySQL 5.6.39

all useful advice

cheers

Linda