Embedded Files
Assumptions
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
Pre-Upgrade Check
mysqlsh --socket /var/lib/mysql/mysql.sock
util.checkForServerUpgrade();
Stop MySQL
Stop MySQL
systemctl stop mysql
Backup
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
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
Install New Version
yum install percona-server-server
Restart MySQL
Restart MySQL
systemctl start mysql
Bibliography
Bibliography
https://docs.percona.com/percona-server/8.0/upgrading_using_percona_repos.html#upgrading-using-percona-reposhttps://docs.percona.com/percona-distribution-for-mysql/8.0/minor-upgrade.htmlhttps://docs.percona.com/percona-server/8.0/release-notes/release-notes_index.htmlhttps://www.percona.com/services/policies/percona-software-support-lifecycle
Page updated
Google Sites
Report abuse