We are trying to upgrade MySql 5.5 to 5.6. We are on RHEL 6.7.
We have the following installed
yum list | grep percona
Percona-Server-client-55.x86_64 5.5.33-rel31.1.566.rhel6 @percona
Percona-Server-devel-55.x86_64 5.5.32-rel31.0.549.rhel6 @percona
Percona-Server-shared-55.x86_64 5.5.32-rel31.0.549.rhel6 @percona
Percona-Server-shared-compat.x86_64 5.5.32-rel31.0.549.rhel6 @percona
percona-release.x86_64 0.0-1 @/percona-release-0.0-1.x86_64
Cannot upload enabled repos report, is this client registered?
We have a master and slave to be upgraded. Can you please suggest if we can proceed with an in-place upgrade and any documentation on the upgrade steps. Also, does upgrading percona server, automatically updates MySql version as well ?
Any information is much appreciated
Hello @amereddy ,
Since Percona Server for MySQL is MySQL, yes, upgrading Percona Server does upgrade MySQL. Those are the same thing.
Yes, you can perform an in-place upgrade from 5.5 to 5.6. I recommend upgrading your replica first. Stop MySQL on the replica, add the parameter
skip-slave-start=1 to the replica’s /etc/my.cnf, upgrade the packages, then start MySQL. After the replica has started, you must run
mysql_upgrade on the replica. If this completes without errors, then you can
START SLAVE to resume replication.
After replication catches up, and you haven’t seen any issues, you can do the same for the source. Same process, but you don’t have to add the parameter to my.cnf since this is not a replica.
After you have upgraded both to 5.6, let them run for an hour while you test your application. I HIGHLY recommend you then repeat the entire process above and upgrade 5.6 to 5.7. Both 5.5 and 5.6 are dead/end-of-life. You need to be on 5.7.
There is a chance that you won’t be able to upgrade to 5.7 because RHEL 6.7 is also quite dead and old.
If this were my setup, I would start from scratch. Create 2 new servers, install RHEL 8 on both, install Percona Server 8.0, and perform a dump/reload of the data from 5.5.
Thanks Matt. Appreciate the information you have provided. This helps a lot.