Install Percona 5.6 – Ubuntu 16.04

Percona is a free, fully compatible and high performance drop-in replacement for MySQL server. Percona supports high performance hardware and provides improved reliability and performance.

To install first we need to add the repo:

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

Next, install the repo:

dpkg -i percona-release_0.1-3.$(lsb_release -sc)_all.deb

We’ll need to update the local cache now:

sudo apt-get update

Now we install the server:

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

You’ll now need to manually create the following functions:

mysql -u USER -pPASSWORD -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -u USER -pPASSWORD -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -u USER -pPASSWORD -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"

Start the service by issuing the following command:

service mysql restart

The last thing to do is to add the service to run at boot:

sudo update-rc.d mysql defaults

To login to the server you simply use the password you entered during installation like this:

mysql -u root -p

It’ll prompt you to enter the password, if successfully authenticated you should now be standing at the mysql prompt.

That’s it, you’re done.