How To Install Percona Server 5.5 On Ubuntu 12.10

Percona Server is a drop-in replacement for MySQL. It offers more performance and scalability than the default MySQL server coming with your Linux distribution, while it uses the same init scripts and command line tools which makes it easy to use. This tutorial explains how to install Percona Server 5.5 on Ubuntu 12.10.
I do not issue any guarantee that this will work for you!

1 Preliminary Note

If MySQL is already installed on your system, this is no problem - Percona Server will ssimply replace it, but keep data and also your MySQL configuration from /etc/mysql/my.cnf.
You can find a Percona Server benchmark here (in German):
Benchmark: MySQL 5.5 vs. Percona Server 5.5
Because we will run all the steps from this tutorial with root privileges, we can either prepend all commands in this tutorial with the string sudo, or we become root right now by typing

sudo su

2 Configuring apt

Percona provides an apt repository for Debian and Ubuntu, which makes Percona Server very easy to install. First, import Percona's key:

gpg --keyserver hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

gpg -a --export CD2EFD2A | apt-key add -

Next open /etc/apt/sources.list...

vi /etc/apt/sources.list

... and add the following two lines to it:

[...]
deb http://repo.percona.com/apt quantal main
deb-src http://repo.percona.com/apt quantal main

Next we need to pin Percona's package so that they don't get overwritten by upgrades from the Ubuntu repositories:

vi /etc/apt/preferences.d/00percona.pref

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

Then update the package database:

apt-get update

3 Installing Percona Server

Percona Server can now be installed as follows:

apt-get install percona-server-server-5.5 percona-server-client-5.5

New password for the Percona Server "root" user: <-- yourrootsqlpassword
Repeat password for the Percona Server "root" user: <-- yourrootsqlpassword
That's it already. To check your MySQL version, log into the MySQL shell:

mysql -u root -p

root@Ubuntu-1210-quantal-64-minimal ~ # mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 38
Server version: 5.5.28-29.2 Percona Server (GPL), Release 29.2

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> <-- quit
Bye
root@Ubuntu-1210-quantal-64-minimal ~ #
As you see, we're using Percona Server now.

Fun With MySQL

Wednesday, February 26, 2014