Percona MySQL Upgrade
Assumptions
These instructions are tested with an upgrade from 5.7.38 to 8.0.28.
You are assumed to be logged in as the UNIX 'root' user.
You are assumed not to be using the tokudb or rocksdb engines.
You are assumed to be upgrading to version 8.0.16-7 or later.Â
Pre-Upgrade Check
mysqlsh --socket /var/lib/mysql/mysql.sock
util.checkForServerUpgrade();
Stop MySQL
systemctl stop mysql
Backup
Make sure you can restore if everything goes wrong. One option with the database down is to copy the database files to a backup location... e.g.
time rsync -ahr --progress /var/lib/mysql /backup
Also backup the config file...
cp /etc/percona-server.conf.d/*.cnf /backup
Remove Current Version
Check installed packages...
rpm -qa | grep Percona-Server
This example assumes Percona 5.7Remove the packages without dependencies...
rpm -qa | grep Percona-Server | xargs rpm -e --nodeps
Install New Version
yum install percona-server-server
Restart MySQL
systemctl start mysql