2023-06-03 Install Percona Server for MySQL

Use RPM repositories - Percona Server for MySQL

Install from Percona Software repository¶

Ready-to-use packages are available from the Percona Server for MySQL software repositories and the download page. The Percona yum repository supports popular RPM-based operating systems. The easiest way to install the Percona RPM repository is to install an RPM that configures yum and installs the Percona GPG key.

Supported platforms¶

Specific information on the supported platforms, products, and versions are described in Percona Software and Platform Lifecycle.

Red Hat Certified¶

Percona Server for MySQL is certified for Red Hat Enterprise Linux 8. This certification is based on common and secure best practices and successful interoperability with the operating system. Percona Server is listed in the Red Hat Ecosystem Catalog.

Limitations¶

The RPM packages for Red Hat Enterprise Linux 7 and the compatible derivatives do not support TLSv1.3, as it requires OpenSSL 1.1.1, which is currently not available on this platform.

Install¶

Install from Percona Software Repository For more information on the Percona Software repositories and configuring Percona Repositories with percona-release, see the Percona Software Repositories Documentation. Run the following commands as a root user or with sudo.

Install on Red Hat 7Install on Red Hat 8 or later

$ sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
$ sudo percona-release enable-only ps-80 release
$ sudo percona-release enable tools release
$ sudo yum install percona-server-server

Available storage engines¶

Percona Server for MySQL 8.0 comes with the TokuDB storage engine and MyRocks storage engine. These storage engines are installed as plugins.

Starting with Percona Server for MySQL 8.0.28-19 (2022-05-12), the TokuDB storage engine is no longer supported. We have removed the storage engine from the installation packages and disabled the storage engine in our binary builds. For more information, see TokuDB Introduction.

For information on how to install and configure TokuDB, refer to the TokuDB Installation guide.

For information on how to install and configure MyRocks, refer to the Percona MyRocks Installation Guide.

Percona yum Testing repository¶

Percona offers pre-release builds from our testing repository. To subscribe to the testing repository, you enable the testing repository in /etc/yum.repos.d/percona-release.repo. To do so, set both percona-testing-$basearch and percona-testing-noarch to enabled = 1 (Note that there are three sections in this file: release, testing, and experimental - in this case, it is the second section that requires updating).

You must install the Percona repository first if the installation has not been done already.

Uninstall - Percona Server for MySQL

Uninstall Percona Server for MySQL¶

To completely uninstall Percona Server for MySQL, remove all the installed packages and data files.

1. Stop the Percona Server for MySQL service:

   $ sudo service mysql stop
   

2. Remove the packages:

   $ sudo yum remove percona-server*
   

3. Remove the data and configuration files:

   Warning

   This step removes all the packages and deletes all the data files (databases, tables, logs, etc.). Take a backup before doing this in case you need the data.

   $ rm -rf /var/lib/mysql
   $ rm -f /etc/my.cnf