What’s in each DEB package?¶

The percona-server-server-5.6 package contains the database server itself, the mysqld binary and associated files.

The percona-server-common-5.6 package contains files common to the server and client.

The percona-server-client-5.6 package contains the command line client.

The percona-server-5.6-dbg package contains debug symbols for the server.

The percona-server-test-5.6 package contains the database test suite.

The percona-server-source-5.6 package contains the server source.

The libperconaserverclient18.1-dev package contains header files needed to compile software to use the client library.

The libperconaserverclient18.1 package contains the client shared library. The 18.1 is a reference to the version of the shared library. The version is incremented when there is a ABI change that requires software using the client library to be recompiled or its source code modified.

Installing Percona Server for MySQL from Percona apt repository¶

1. Install GnuPG, the GNU Privacy Guard:

   $ sudo apt-get install gnupg2
   

2. Fetch the repository packages from Percona web:

   $ wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
   

2. Install the downloaded package with dpkg. To do that, run the following commands as root or with sudo:

   $ sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
   

   Once you install this package the Percona repositories should be added. You can check the repository setup in the /etc/apt/sources.list.d/percona-release.list file.

3. Remember to update the local cache:

   $ sudo apt-get update
   

4. After that you can install the server package:

   $ sudo apt-get install percona-server-server-5.6
   

$ sudo percona-release enable original testing

Package: *
Pin: release o=Percona Development Team
Pin-Priority: 1001

Installing Percona Server for MySQL using downloaded deb packages¶

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 5.6.25-73.1 release packages for Debian 8.0:

$ wget https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.25-73.1/binary/debian/jessie/x86_64/Percona-Server-5.6.25-73.1-r07b797f-jessie-x86_64-bundle.tar

You should then unpack the bundle to get the packages:

$ tar xvf Percona-Server-5.6.25-73.1-r07b797f-jessie-x86_64-bundle.tar

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

$ ls *.deb
libperconaserverclient18.1-dev_5.6.25-73.1-1.jessie_amd64.deb
libperconaserverclient18.1_5.6.25-73.1-1.jessie_amd64.deb
percona-server-5.6-dbg_5.6.25-73.1-1.jessie_amd64.deb
percona-server-client-5.6_5.6.25-73.1-1.jessie_amd64.deb
percona-server-client_5.6.25-73.1-1.jessie_amd64.deb
percona-server-common-5.6_5.6.25-73.1-1.jessie_amd64.deb
percona-server-server-5.6_5.6.25-73.1-1.jessie_amd64.deb
percona-server-server_5.6.25-73.1-1.jessie_amd64.deb
percona-server-source-5.6_5.6.25-73.1-1.jessie_amd64.deb
percona-server-test-5.6_5.6.25-73.1-1.jessie_amd64.deb
percona-server-tokudb-5.6_5.6.25-73.1-1.jessie_amd64.deb

Now you can install Percona Server for MySQL by running:

$ sudo dpkg -i *.deb

This will install all the packages from the bundle. Another option is to download/specify only the packages you need for running Percona Server for MySQL installation (libperconaserverclient18.1_5.6.25-73.1-1.jessie_amd64.deb, percona-server-client-5.6_5.6.25-73.1-1.jessie_amd64.deb, percona-server-common-5.6_5.6.25-73.1-1.jessie_amd64.deb, and percona-server-server-5.6_5.6.25-73.1-1.jessie_amd64.deb).

The following table lists the default locations for files:

Running Percona Server for MySQL¶

A Debian or an Ubuntu installation automatically creates a special debian-sys-maint user which is used by the control scripts to control the Percona Server for MySQL mysqld and mysqld_safe services. Login details for that user can be found in /etc/mysql/debian.cnf.

1. Starting the service

   Percona Server for MySQL is started automatically after it gets installed unless it encounters errors during the installation process. You can also manually start it by running:

   $ sudo 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:

   $ sudo service mysql stop
   

4. Restarting the service

   You can restart the service by running:

   $ sudo service mysql restart
   

Run the following commands as root or by using the sudo command

1. Starting the service

   Percona Server for MySQL is started automatically after it gets installed unless it encounters errors during the installation process. You can also manually 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. service mysql restart

Uninstalling Percona Server for MySQL¶

To uninstall Percona Server for MySQL you’ll need to remove all the installed packages. Removing packages with apt-get remove will leave the configuration and data files. Removing the packages with apt-get purge will remove all the packages with configuration files and data files (all the databases). Depending on your needs you can choose which command better suits you.

1. Stop the Percona Server for MySQL service

   $ sudo service mysql stop
   

2. Remove the packages

   1. Remove the packages. This will leave the data files (databases, tables, logs, configuration, etc.) behind. In case you don’t need them you’ll need to remove them manually.

   $ sudo apt-get remove percona-server*
   

   2. Purge the packages. NOTE: This will remove all the packages and delete all the data files (databases, tables, logs, etc.)

   $ sudo apt-get purge percona-server*