(2024.1) Percona Upgrade to MySQL 8

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.

PCR-360 Wiki