Installing Percona Server for MySQL on Red Hat Enterprise Linux and CentOS

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, including the Amazon Linux AMI.

The easiest way to install the Percona Yum repository is to install an RPM that configures yum and installs the Percona GPG key.

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

What’s in each RPM package?

Each of the Percona Server for MySQL RPM packages have a particular purpose.

Package Contains
percona-server-server The server itself (the mysqld binary)
percona-server-debuginfo Debug symbols for the server
percona-server-client The command line client
percona-server-devel the header files needed to compile software using the client library.
percona-server-shared The client shared library.
percona-server-shared-compat Shared libraries for software compiled against old versions of the client library. The following libraries are included in this package: libmysqlclient.so.12, libmysqlclient.so.14, libmysqlclient.so.15, libmysqlclient.so.16, and libmysqlclient.so.18.
percona-server-test package includes the test suite for Percona Server for MySQL.

Installing Percona Server for MySQL from Percona yum repository

You can install Percona yum repository by running the following commands as a root user or with sudo.

  1. Install the Percona repository

    $ sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
    

    You should see an output that the files are being downloaded, like the following:

    Retrieving http://www.percona.com/downloads/percona-release/redhat/0.1-6/percona-release-latest.noarch.rpm
    Preparing...                ########################################### [100%]
    1:percona-release        ########################################### [100%]
    
  2. Enable the repository:

    $ sudo percona-release setup ps80
    
  3. Install the packages

    
    

    $ sudo yum install percona-server-server

Note

Percona Server for MySQL 8.0 comes with the TokuDB storage engine and MyRocks storage engines. These storage engines are installed as plugins. You can find more information on how to install and enable the TokuDB storage in the TokuDB Installation guide. More information about how to install MyRocks can be found in the section Percona MyRocks Installation Guide.

Percona yum Testing repository

Percona offers pre-release builds from our testing repository. To subscribe to the testing repository, you’ll need to 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 3 sections in this file: release, testing and experimental - in this case it is the second section that requires updating). NOTE: You’ll need to install the Percona repository first (ref above) if this hasn’t been done already.

Installing Percona Server for MySQL using downloaded rpm packages

  1. Download the packages of the desired series for your architecture from the download page. The easiest way is to download bundle which contains all the packages. Following example will download Percona Server for MySQL 8.0.13-3 release packages for CentOS 7:

    $ wget https://www.percona.com/downloads/Percona-Server-8.0/Percona-Server-8.0.13-3/binary/redhat/7/x86_64/Percona-Server-8.0.13-3-r63dafaf-el7-x86_64-bundle.tar
    
  2. You should then unpack the bundle to get the packages: tar xvf Percona-Server-8.0.13-3-r63dafaf-el7-x86_64-bundle.tar

    After you unpack the bundle you should see the following packages when running ls *.rpm:

    Output

    percona-server-80-debuginfo-8.0.13-3.el7.x86_64.rpm
    percona-server-client-80-8.0.13-3.el7.x86_64.rpm
    percona-server-devel-80-8.0.13-3.el7.x86_64.rpm
    percona-server-server-80-8.0.13-3.el7.x86_64.rpm
    percona-server-shared-80-8.0.13-3.el7.x86_64.rpm
    percona-server-shared-compat-80-8.0.13-3.el7.x86_64.rpm
    percona-server-test-80-8.0.13-3.el7.x86_64.rpm
    percona-server-tokudb-80-8.0.13-3.el7.x86_64.rpm
    

Note

For an RHEL 8 package installation, Percona Server requires the mysql module to be disabled.

$ sudo yum module disable mysql
  1. Now you can install Percona Server for MySQL 8.0 by running:

    $ sudo rpm -ivh percona-server-server-80-8.0.13-3.el7.x86_64.rpm \
    percona-server-client-80-8.0.13-3.el7.x86_64.rpm \
    percona-server-shared-80-8.0.13-3.el7.x86_64.rpm
    

This will install only packages required to run the Percona Server for MySQL 8.0. Optionally you can install TokuDB storage engine by adding the percona-server-tokudb-80-8.0.13-3.el7.x86_64.rpm to the command above. You can find more information on how to install and enable the TokuDB storage in the TokuDB Installation guide.

To install all the packages (for debugging, testing, etc.) you should run:

$ sudo rpm -ivh *.rpm

Note

When installing packages manually like this, you’ll need to make sure to resolve all the dependencies and install missing packages yourself.

Running Percona Server for MySQL

Percona Server for MySQL stores the data files in /var/lib/mysql/ by default. You can find the configuration file that is used to manage Percona Server for MySQL in /etc/my.cnf.

  1. Starting the service

    Percona Server for MySQL is not started automatically on RHEL and CentOS after it gets installed. You should start it by running:

    $ sudo service mysql start
    
  2. Confirming that service is running

    You can check the service status by running:

    $ sudo service mysql status
    
  3. Stopping the service

    You can stop the service by running:

    $ sudo service mysql stop
    
  4. Restarting the service

    You can restart the service by running:

    $ sudo service mysql restart
    

Note

RHEL 7 and CentOS 7 come with systemd as the default system and service manager so you can invoke all the above commands with sytemctl instead of service. Currently, both are supported.

Uninstalling Percona Server for MySQL

To completely uninstall Percona Server for MySQL you’ll need to 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

Contact Us

For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.