====== Percona ======

  * [[Percona XtraDB]]
  * [[Percona XtraDB Cluster]]
  * [[Percona Homebrew]]
  * [[Percona Toolkit]]
  * [[InnoDB]]
  * [[About Percona]]
  * [[pt-find]]

  * [[http://www.percona.com/doc/percona-server/5.5/installation/apt_repo.html|Percona 5.5 apt repo]]
  * [[http://www.percona.com/doc/percona-server/5.6/installation/apt_repo.html|Percona 5.6 apt repo]]

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 [[http://www.percona.com/doc/percona-server/5.5/installation/apt_repo.html|here]].

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

Choose the repositories to add, based on your release.

Precise (12.04):

<code>
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
</code>

Install the database and tools:

<code>
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
</code>

For the cluster:

<code>
aptitude install percona-xtradb-cluster-server-5.5 percona-toolkit percona-xtradb-cluster-test-5.5
</code>

=== 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 ===

  * [[http://tools.percona.com/|Percona Online Tools]]

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.