This is an old revision of the document!
Percona
Percona is a drop-in replacement for MySQL
Installation
When installing the software, make sure there is NOT a my.cnf dotfile in your home directory. That will affect the install scripts.
Ubuntu Repository
Available here.
gpg --keyserver hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A gpg -a --export CD2EFD2A | sudo apt-key add -
Choose the repositories to add, based on your release.
Oneiric (11.10):
echo deb http://repo.percona.com/apt oneiric main >> /etc/apt/sources.list echo deb-src http://repo.percona.com/apt oneiric main >> /etc/apt/sources.list
Precise (12.04):
echo deb http://repo.percona.com/apt precise main >> /etc/apt/sources.list echo deb-src http://repo.percona.com/apt precise main >> /etc/apt/sources.list
Install the database and tools:
aptitude update aptitude -y remove mysql-common mysql-server-5.5 mysql-client-core-5.5 mysql-server-core-5.5 aptitude install percona-server-server percona-toolkit percona-xtrabackup percona-server-client
For the cluster:
aptitude install percona-xtradb-cluster-server-5.5 percona-toolkit percona-xtradb-cluster-test-5.5
Upgrade Notes
When upgrading the packages from the Ubuntu repository, do a couple of things to make sure the process goes smoothly:
- Remove the .my.cnf for the root user
- Remove the my.cnf file in /etc/mysql
Configuration Generator
When using the configuration generator, there are a few things you will need to change to make the configuration file compatible with Ubuntu server:
Change socket file to /var/run/mysqld/mysqld.sock, the same as in /etc/mysql/debian.cnf
The pid_file and the log_error values use the hostname as the prefix filename. So, for example, on foo.domain.com, set the value for pid_file to /var/lib/mysql/foo.pid and for log_error, use /var/lib/mysql/foo.err
After that it should start fine. If this is a first install, and it's giving you issues, try removing the ib_log* files in /var/lib/mysql/ and see if that repairs it.
