Percona Server

Install Percona Server Ubuntu 18.04 – Percona is the developer of a number of open source software projects for MySQL, MariaDB, PostgreSQL, MongoDB and RocksDB users. They state that all of their software is ‘fully open source and entirely free’. The company’s revenue is derived from open source database related support, consultancy and managed services.

Step 1: Add Percona Repository

Download repository packages from Percona.

Fetch the repository packages from Percona web:

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

Install the downloaded package with dpkg.

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

Update the local cache:

$ sudo apt-get update

Now you can install the server package:

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

Installing Percona Server using Offline 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.7.10-3 release packages for Debian 8.0:

$ wget https://www.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.7.10-3/binary/debian/jessie/x86_64/Percona-Server-5.7.10-3-r63dafaf-jessie-x86_64-bundle.tar

Please unpack the bundle using below command

$ tar xvf Percona-Server-5.7.10-3-r63dafaf-jessie-x86_64-bundle.tar
$ ls *.deb
libperconaserverclient20-dev_5.7.10-3-1.jessie_amd64.deb
libperconaserverclient20_5.7.10-3-1.jessie_amd64.deb
percona-server-5.7-dbg_5.7.10-3-1.jessie_amd64.deb
percona-server-client-5.7_5.7.10-3-1.jessie_amd64.deb
percona-server-common-5.7_5.7.10-3-1.jessie_amd64.deb
percona-server-server-5.7_5.7.10-3-1.jessie_amd64.deb
percona-server-source-5.7_5.7.10-3-1.jessie_amd64.deb
percona-server-test-5.7_5.7.10-3-1.jessie_amd64.deb
percona-server-tokudb-5.7_5.7.10-3-1.jessie_amd64.deb

Run below command to install Percona Server

$ sudo dpkg -i *.deb

Note

Percona Server 5.7 comes with the TokuDB storage engine. You can find more information on how to install and enable the TokuDB storage in the TokuDB Installation guide.

How to access Percona server

Please use below command to access Percona MySQL server

$ mysql -u root -p

Enter your root account password

How to manage Percona Services

Starting the service

$ sudo service mysql start

Confirming that service is running

$ service mysql status

Stopping the service

$ sudo service mysql stop

Restarting the service

$ sudo service mysql restart

How to Uninstall 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*

Leave a comment

Your email address will not be published.