Percona server is a derived version of MySQL, focusing on improvements to MySQL database server under Linux/bsd, with a significant improvement in functionality and performance compared to MySQL.
The use of Percona Server is exactly the same as MySQL, and you can completely use it as MySQL.
Installing Percona Server
Edit Percona.repo
:
# Vi/etc/yum.repos.d/percona.repo
Add the following content:
[percona]name = CentOS $releasever-perconabaseurl=http://repo.percona.com/centos/$releasever/os/$basearch/enabled = 1gpgkey = File:///etc/pki/rpm-gpg/RPM-GPG-KEY-perconagpgcheck = 1
Get RPM-GPG-KEY
:
# wget Http://www.percona.com/downloads/RPM-GPG-KEY-percona-O/etc/pki/rpm-gpg/rpm-gpg-key-percona
To check if the add succeeds:
# Yum List | grep Percona
Installation Percona Server 5.6
:
# yum Install percona-server-shared-56 percona-server-client-56 percona-server-server-56-y
Configure MY.CNF
Generally after we install MySQL or Percona server, in the /usr/share/mysql/
directory will generate my-medium.cnf
/ my-large.cnf
etc configuration files, Percona server 5.6 version after installation did not produce these configuration files, I from Percona server 5. A my-medium.cnf file was copied under version 5
# cp my-medium.cnf /etc/my.cnf
Edit/ETC/MY.CNF and add the following:
[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid
The default UTF8 encoding, same as edit/etc/my.cnf file, is [mysqld]
added below:
character-set-server = utf8
To start the MySQL (Percona Server) Service:
# service mysql startStarting MySQL (Percona Server).. [ OK ]
Linux under YUM install Percona Server 5.6