Upgrade using the Percona repositories¶
We recommend using the Percona repositories to upgrade your server.
Find the instructions on how to enable the repositories in the following documents:
Run the following commands as root or use the sudo
command.
-
Make a full backup (or dump if possible) of your database. Move the database configuration file,
my.cnf
, to another directory to save it. If the configuration file is not moved, it can be overwritten. -
Stop the server with the appropriate command for your system:
systemctl stop mysql`
-
Modify the database configuration file,
my.cnf
, as needed. -
Install Percona Server for MySQL:
$ sudo apt update $ sudo apt install curl $ curl -0 https://repo.percona.com/apt/percona-release_latest.generic_all.deb $ sudo apt install gnupg2 lsb-release ./percona-release_latest.generic_all.deb $ sudo apt update $ sudo percona-release setup ps-84-lts $ sudo apt install percona-server-server
-
Install the storage engine packages.
If you used the MyRocks storage engine in Percona Server for MySQL 8.4, install the
percona-server-rocksdb
package:$ sudo apt install percona-server-rocksdb
-
Running the upgrade:
The mysqld binary automatically runs the upgrade process if needed. To find more information, see MySQL Upgrade Process Upgrades
-
Restart the service
$ sudo systemctl restart mysqld
After the service has been successfully restarted you can use the new Percona Server for MySQL 8.4.
Run the following commands as root or use the sudo command.
-
Make a full backup (or dump if possible) of your database. Copy the database configuration file, for example,
my.cnf
, to another directory to save it. -
Stop the server with the appropriate command for your system:
$ systemctl stop mysql`
-
Check your installed packages with
rpm -qa | grep Percona-Server
. -
Remove only the packages without dependencies and leave dependent packages. The command does not prompt for confirmation:
$ rpm -qa | grep Percona-Server | xargs rpm -e --nodeps
-
Remove the mysql-related packages, run:
$ rpm -qa | grep '^mysql-' | xargs rpm -e --nodeps
-
Install the
percona-server-server
package:$ sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm $ sudo percona-release setup ps-84-lts $ sudo yum install percona-server-server
-
Install the storage engine packages.
If you used the MyRocks storage engine in the previous version, install the
percona-server-rocksdb
package:$ yum install percona-server-rocksdb
-
Modify your configuration file,
my.cnf
, and reinstall the plugins if necessary. -
Running the upgrade
The mysqld binary automatically runs the upgrade process if needed. To find more information, see MySQL Upgrade Process Upgrades
Restart the server and you can use the Percona Server for MySQL 8.4.
Get expert help¶
If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.