no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.


—percona [2015/06/02 03:30] (current) – created - external edit 127.0.0.1
Line 1: Line 1:
 +====== 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.

Trace:

Navigation
QR Code
QR Code percona (generated for current page)