Installing Percona Server on Debian and Ubuntu

Installing Percona Server from Percona apt repository
Fetch the repository packages from Percona web:

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

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

sudo dpkg -i percona-release_0.1-4.$(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.

Remember to update the local cache:

apt-get update

After that you can install the server package:

apt-get install percona-server-server-5.5

Percona apt Testing repository
Percona offers pre-release builds from the testing repository. To enable it add the just uncomment the testing repository lines in the Percona repository definition in your repository file (default /etc/apt/sources.list.d/percona-release.list). It should looks like this (in this example VERSION is the name of your distribution):

# Testing & pre-release packages
#
deb http://repo.percona.com/apt VERSION testing
deb-src http://repo.percona.com/apt VERSION testing

Apt-Pinning the packages
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.
Installing Percona Server 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 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).

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/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

Note

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.
Uninstalling Percona Server
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

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*

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*

Source: percona.com

Tags: ,