How to install Percona Server (MySql Server replacement) on squeeze

Percona Server is an enhanced drop-in replacement for MySQL. Persona server is free open source solution, offering better performance, scalability, features, and instrumentation. Self-tuning algorithms and support for extremely high-performance hardware make it the clear choice for organizations that demand excellent performance and reliability from their MySQL database server.

You can upgrade from MySql server and still use the same tools and application without any change, including phpMyAdmin. If you currently have a running MySql server please make backups of the configuration and databases before upgrading.

1. Remove MySql Server

apt-get remove mysql-server-core-5.1 mysql-server-5.1 mysql-server

2. Install the keys for Percona apt repository

gpg --keyserver hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
gpg -a --export CD2EFD2A | apt-key add -

3. Insert Percona apt repository to sources.list

echo "deb http://repo.percona.com/apt squeeze main" >> /etc/apt/sources.list
echo "deb-src http://repo.percona.com/apt squeeze main" >> /etc/apt/sources.list

4. Update apt

apt-get update

5. Install Percona server

apt-get install percona-server-5.5
> When prompted select you root password
> Confirm root password

Percona Server is now up and running and has replaced MySql Server.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>