Emergency

Installing Percona Server on Red Hat Enterprise Linux and CentOS

Ready-to-use packages are available from the Percona Server 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.

Supported Releases:

  • CentOS 5 and RHEL 5
  • CentOS 6 and RHEL 6 (Current Stable) [1]
  • CentOS 7 and RHEL 7
  • Amazon Linux AMI (works the same as CentOS 6)

The CentOS repositories should work well with Red Hat Enterprise Linux too, provided that yum is installed on the server.

Supported Platforms:

  • x86
  • x86_64 (also known as amd64)

What’s in each RPM package?

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

The Percona-Server-server package contains the server itself (the mysqld binary).

The Percona-Server-debuginfo package contains debug symbols for the server.

The Percona-Server-client package contains the command line client.

The Percona-Server-devel package contains the header files needed to compile software using the client library.

The Percona-Server-shared package includes the client shared library.

The Percona-Server-shared-compat package includes shared libraries for software compiled against old versions of the client library. Following libraries are included in this package: libmysqlclient.so.12, libmysqlclient.so.14, libmysqlclient.so.15, and libmysqlclient.so.16.

The Percona-Server-test package includes the test suite for Percona Server.

Installing Percona Server from Percona yum repository

  1. Install the Percona repository

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

    yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
    

    You should see some output such as the following:

    Retrieving http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
    Preparing...                ########################################### [100%]
       1:percona-release        ########################################### [100%]
    

Note

RHEL/Centos 5 doesn’t support installing the packages directly from the remote location so you’ll need to download the package first and install it manually with rpm:

wget http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
rpm -ivH percona-release-0.1-3.noarch.rpm
  1. Testing the repository

    Make sure packages are downloaded from the repository, by executing the following command:

    yum list | grep percona
    

    You should see output similar to the following:

    ...
    Percona-Server-56-debuginfo.x86_64          5.6.25-rel73.1.el6           @percona-release-x86_64
    Percona-Server-client-56.x86_64             5.6.25-rel73.1.el6           @percona-release-x86_64
    Percona-Server-devel-56.x86_64              5.6.25-rel73.1.el6           @percona-release-x86_64
    Percona-Server-server-56.x86_64             5.6.25-rel73.1.el6           @percona-release-x86_64
    Percona-Server-shared-56.x86_64             5.6.25-rel73.1.el6           @percona-release-x86_64
    Percona-Server-test-56.x86_64               5.6.25-rel73.1.el6           @percona-release-x86_64
    Percona-Server-shared-compat.x86_64         5.1.68-rel14.6.551.rhel6     percona-release-x86_64
    ...
    
  2. Install the packages

    You can now install Percona Server by running:

    yum install Percona-Server-server-55
    

Percona yum Testing repository

Percona offers pre-release builds from the testing repository. To subscribe to the testing repository, you’ll need to enable the testing repository in /etc/yum.repos.d/percona-release.repo (both $basearch and noarch). NOTE: You’ll need to install the Percona repository first if this hasn’t been done already.

Installing Percona Server using standalone 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 5.6.25-73.1 release packages for CentOS 6:

    wget https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.25-73.1/binary/redhat/6/x86_64/Percona-Server-5.6.25-73.1-r07b797f-el6-x86_64-bundle.tar
    
  2. You should then unpack the bundle to get the packages:

    tar xvf Percona-Server-5.6.25-73.1-r07b797f-el6-x86_64-bundle.tar
    

    After you unpack the bundle you should see the following packages:

    $ ls *.rpm
    
    Percona-Server-56-debuginfo-5.6.25-rel73.1.el6.x86_64.rpm
    Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm
    Percona-Server-devel-56-5.6.25-rel73.1.el6.x86_64.rpm
    Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64.rpm
    Percona-Server-shared-56-5.6.25-rel73.1.el6.x86_64.rpm
    Percona-Server-test-56-5.6.25-rel73.1.el6.x86_64.rpm
    
  3. Now you can install Percona Server by running:

    rpm -ivh Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64.rpm \
    Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm \
    Percona-Server-shared-56-5.6.25-rel73.1.el6.x86_64.rpm
    

This will install only packages required to run the Percona Server. To install all the packages (for debugging, testing, etc.) you should run:

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

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

  1. Starting the service

    Percona Server isn’t started automatically on RHEL and CentOS after it gets installed. You should start it by running:

    service mysql start
    
  2. Confirming that service is running

    You can check the service status by running:

    service mysql status
    
  3. Stopping the service

    You can stop the service by running:

    service mysql stop
    
  4. Restarting the service

    You can restart the service by running:

    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

To completely uninstall Percona Server you’ll need to remove all the installed packages and data files.

  1. Stop the Percona Server service

    service mysql stop
    
  2. Remove the packages

    yum remove Percona-Server*
    
  3. Remove the data and configuration files

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

Warning

This will remove all the packages and delete all the data files (databases, tables, logs, etc.), you might want to take a backup before doing this in case you need the data.

Footnotes

[1]“Current Stable”: We support only the current stable RHEL6/CentOS6 release, because there is no official (i.e. RedHat provided) method to support or download the latest OpenSSL on RHEL/CentOS versions prior to 6.5. Similarly, and also as a result thereof, there is no official Percona way to support the latest Percona Server builds on RHEL/CentOS versions prior to 6.5. Additionally, many users will need to upgrade to OpenSSL 1.0.1g or later (due to the Heartbleed vulnerability), and this OpenSSL version is not available for download from any official RHEL/Centos repository for versions 6.4 and prior. For any officially unsupported system, src.rpm packages may be used to rebuild Percona Server for any environment. Please contact our support service if you require further information on this.