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
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…
… 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:
Package: * Pin: release o=Percona Development Team Pin-Priority: 1001
Then update the package database:
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
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
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> <– quit
root@Ubuntu-1210-quantal-64-minimal ~ #
As you see, we’re using Percona Server now.
- Percona Server: http://www.percona.com/software/percona-server
- MySQL: http://www.mysql.com/
- Ubuntu: http://www.ubuntu.com/