MySQL 5.1 to 5.5 Migration

We're looking to migrate an existing Confluence 5.6 instance from CentOS6 to RHEL7. The current database is residing on MySQL 5.1, but RHEL7 only supports MySQL 5.5 or greater, which needs to be pulled from MySQL's repo. Should we be able to export/import the data across minor releases of MySQL without issue? If not, should we be able to upgrade a CentOS repo provided MySQL 5.1 instance with a standalone MySQL 5.5 RPM, as the EL6 repos only support up to MySQL 5.1? Thank you.

2 answers

1 accepted

5 votes
Accepted answer

Hi Justin,

I was able to import the 5.1 data into a 5.5 once and it went smoothly. I do believe it's a smooth transition but I recommend to do this first into a staging instance and performing some extensive testing searching for issues before deploying on production.

Now going from 5.1 to 5.6 might be a huge step. 

I hope this help.

Cheers,

Rodrigo

Thank you very much for the feedback. We will run this process through the lab, and confirm/deny a clean build.

You are welcome. Feel free to choose this question as resolved if my answer was acceptable. Cheers!

Will do as soon as testing is complete, I don't want to mislead anyone in the interim in case I come across some caveats.

For additional reassurance - I've done this several times, and had the same experience as Rodrigo - it sails through. Minimal step changes in my case - *just* the database upgrade, moving hardware and/or OS done as a different step, but upgrading MySQL 5.1 to 5.5 is very stable. And I'd echo "test it" and "5.6 is a different story" too.

When upgrading MySQL5.1 to MySQL5.5 on RHEL6/Centos6 it is best to use the official Software Collections (SCL) Repository rather than a standalone RPM. 

http://wiki.centos.org/AdditionalResources/Repositories/SCL

https://access.redhat.com/documentation/en-US/Red_Hat_Software_Collections/1/html/1.2_Release_Notes/index.html

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,100 views 17 14
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you