Upgrade Percona Distribution for MySQL

Important

This release does not include the Percona Toolkit component. We will add it once a Percona Toolkit version compatible with MySQL 8.4 becomes available.

ProxySQL contains counters that have not been updated to use the new terminology. Unexpected results may occur. In an 8.4.x environment, the binlog reader errors out during initialization due to the use of old terminology, such as the SHOW MASTER STATUS command.

Minor releases include bug fixes and feature enhancements. We recommend to have Percona Distribution for MySQL updated to the latest version.

Though minor releases don’t change the behavior, even a minor upgrade is a risky process. We recommend to back up your data before upgrading.

Preconditions

To upgrade Percona Distribution for MySQL, install the percona-release repository management tool or update it to the latest version.

Procedure

Important

Run the following commands as the root user or via sudo.

Upgrade Percona Server-based variantUpgrade Percona XtraDBCluster-based variant

1. Enable Percona repository

   The Major Release repository automatically includes new version packages of Percona Distribution for MySQL. If you installed Percona Distribution for MySQL from a Minor Release repository, enable the new version repository:

   $ sudo percona-release setup pdps-XXX 
   

   where XXX is the required version.

   Read more about major and Minor release repositories in Repository overview.

2. Stop mysql service

   $ sudo systemctl mysql stop
   

3. Install new version packages using the package manager of your operating system.

4. Restart mysql service:

   $ sudo systemctl mysql start
   

Complete these steps sequentially on all nodes:

1. Enable Percona repository

   The Major Release repository automatically includes new version packages of Percona Distribution for MySQL. If you installed Percona Distribution for MySQL from a Minor Release repository, enable the new version repository:

   $ sudo percona-release setup pdpxc-XXX 
   

   where XXX is the required version.

   Read more about major and Minor release repositories in Repository overview.

2. Stop mysql service

   $ sudo systemctl mysql stop
   

3. Install new version packages using the package manager of your operating system.

4. Back up the grastate.dat file

5. Restart mysql service

   $ sudo systemctl mysql start
   

See also

Upgrading Percona XtraDB Cluster

To upgrade the components, refer to Installing Percona Distribution for MySQL for installation instructions relevant to your operating system.

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.

Community Forum Get a Percona Expert