Linux under YUM install Percona Server 5.6

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