Ready-to-use packages are available from the Percona Server software repositories and the download page.
- 6.0 (squeeze)
- 7.0 (wheezy)
- 8.0 (jessie)
- 12.04LTS (precise)
- 14.04LTS (trusty)
- 14.10 (utopic)
- 15.04 (vivid)
- x86_64 (also known as amd64)
The percona-server-server package contains the database server itself, the mysqld binary and associated files.
The percona-server-common package contains files common to the server and client.
The percona-server-client package contains the command line client.
The percona-server-dbg package contains debug symbols for the server.
The percona-server-test package contains the database test suite.
The percona-server-source package contains the server source.
The libperconaserverclient-dev package contains header files needed to compile software to use the client library.
The libperconaserverclient18 package contains the client shared library. The 18 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.
Debian and Ubuntu packages from Percona are signed with the Percona’s GPG key. Before using the repository, you should add the key to apt. To do that, run the following commands as root or with sudo:$ sudo apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
Create the apt source list for Percona’s repository:
You can create the source list and add the percona repository by running:
echo "deb http://repo.percona.com/apt "$(lsb_release -sc)" main" | sudo tee /etc/apt/sources.list.d/percona.list
Additionally you can enable the source package repository by running:
echo "deb-src http://repo.percona.com/apt "$(lsb_release -sc)" main" | sudo tee -a /etc/apt/sources.list.d/percona.list
Remember to update the local cache:
After that you can install the server package:
apt-get install percona-server-server-5.5
Percona offers pre-release builds from the testing repository. To enable it add the just add the testing word at the end of the percona repository definition in your repository file (default /etc/apt/sources.list.d/percona.list). It should looks like this (in this example VERSION is the name of your distribution):
deb http://repo.percona.com/apt VERSION main testing deb-src http://repo.percona.com/apt VERSION main testing
In some cases you might need to “pin” the selected packages to avoid the upgrades from the distribution repositories. You’ll need to make a new file /etc/apt/preferences.d/00percona.pref and add the following lines in it:
Package: * Pin: release o=Percona Development Team Pin-Priority: 1001
For more information about the pinning you can check the official debian wiki.
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.5.44-37.3 release packages for Debian 8.0:
$ wget https://www.percona.com/downloads/Percona-Server-5.5/Percona-Server-5.5.44-37.3/binary/debian/jessie/x86_64/Percona-Server-5.5.44-37.3-r729fbe2-jessie-x86_64-bundle.tar
You should then unpack the bundle to get the packages:
$ tar xvf Percona-Server-5.5.44-37.3-r729fbe2-jessie-x86_64-bundle.tar
After you unpack the bundle you should see the following packages:
$ ls *.deb libperconaserverclient18_5.5.44-rel37.3-1.jessie_amd64.deb libperconaserverclient18-dev_5.5.44-rel37.3-1.jessie_amd64.deb percona-server-5.5-dbg_5.5.44-rel37.3-1.jessie_amd64.deb percona-server-client_5.5.44-rel37.3-1.jessie_amd64.deb percona-server-client-5.5_5.5.44-rel37.3-1.jessie_amd64.deb percona-server-common-5.5_5.5.44-rel37.3-1.jessie_amd64.deb percona-server-server_5.5.44-rel37.3-1.jessie_amd64.deb percona-server-server-5.5_5.5.44-rel37.3-1.jessie_amd64.deb percona-server-source-5.5_5.5.44-rel37.3-1.jessie_amd64.deb percona-server-test-5.5_5.5.44-rel37.3-1.jessie_amd64.deb
Now you can install Percona Server 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 installation (libperconaserverclient18_5.5.44-rel37.3-1.jessie_amd64.deb, percona-server-client-5.5_5.5.44-rel37.3-1.jessie_amd64.deb, percona-server-common-5.5_5.5.44-rel37.3-1.jessie_amd64.deb, and percona-server-server-5.5_5.5.44-rel37.3-1.jessie_amd64.deb).
When installing packages manually like this, you’ll need to make sure to resolve all the dependencies and install missing packages yourself.
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/mysql/my.cnf. Debian and Ubuntu installation automatically creates a special debian-sys-maint user which is used by the control scripts to control the Percona Server mysqld and mysqld_safe services. Login details for that user can be found in /etc/mysql/debian.cnf.
Starting the service
Percona Server 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
Confirming that service is running
You can check the service status by running:
$ service mysql status
Stopping the service
You can stop the service by running:
$ sudo service mysql stop
Restarting the service
You can restart the service by running:
$ sudo service mysql restart
Debian 8.0 (jessie) and Ubuntu 15.04 (vivid) 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.
To uninstall Percona Server 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.
Stop the Percona Server service
$ sudo service mysql stop
Remove the packages
$ sudo apt-get remove percona-server*
$ sudo apt-get purge percona-server*