(2024.2) Percona Upgrade to MySQL 8
- David Engblom
Upgrading from MySQL 5.7 to MySQL 8 is extensively covered by MySQL and Percona documentation. Before you upgrade your systems, please review the following documentation based on your installation. Once you have reviewed the documentation and upgrade MySQL, you will need to update the configuration file my.cnf for PCR-360 to run properly. The new settings can be found at the bottom of this page and on the Percona Installation page.
Percona MySQL
Why Upgrade?
https://www.percona.com/blog/2021/04/02/upgrading-to-mysql-8/
Percona Server In-Place Upgrading
https://www.percona.com/doc/percona-server/8.0/upgrading_guide.html
MySQL Server
Note: Even if you have Percona installed, this is worth reviewing.
https://dev.mysql.com/doc/refman/8.0/en/upgrading.html
Troubleshooting
In one upgrade the mysql-community-tools did not uninstall with the rest of the old version. This led to an install failure for Percona 8. Using apt to remove the mysql-community-tools package before installing percona resolved the issue.