[centos] 安装Percona

参考官网 http://www.percona.com/doc/percona-server/5.6/installation.html

[root@localhost TT]# ps -ef|grep mysql
root      7265     1  0 Oct23 pts/4    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/localhost.localdomain.pid
mysql     7691  7265  0 Oct23 pts/4    00:03:22 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/var/localhost.localdomain.err --pid-file=/usr/local/mysql/var/localhost.localdomain.pid --socket=/tmp/mysql.sock --port=3306
root     21780 15906  0 13:35 pts/19   00:00:00 grep mysql

[root@localhost TT]#  yum install Percona-Server-client-56 Percona-Server-server-56
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * epel: mirrors.ustc.edu.cn
Setting up Install Process
No package Percona-Server-client-56 available.
No package Percona-Server-server-56 available.
Error: Nothing to do

                         塔机配件大全

[root@localhost TT]# $ yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
bash: $: command not found
[root@localhost TT]# yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * epel: mirrors.ustc.edu.cn
Setting up Install Process
percona-release-0.1-3.noarch.rpm                 | 6.4 kB     00:00     
Examining /var/tmp/yum-root-QJ1Zox/percona-release-0.1-3.noarch.rpm: percona-release-0.1-3.noarch
Marking /var/tmp/yum-root-QJ1Zox/percona-release-0.1-3.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package percona-release.noarch 0:0.1-3 will be installed
--> Finished Dependency Resolution


Dependencies Resolved


========================================================================
 Package          Arch    Version  Repository                      Size
========================================================================
Installing:
 percona-release  noarch  0.1-3    /percona-release-0.1-3.noarch  5.8 k


Transaction Summary
========================================================================
Install       1 Package(s)


Total size: 5.8 k
Installed size: 5.8 k
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : percona-release-0.1-3.noarch                         1/1 
  Verifying  : percona-release-0.1-3.noarch                         1/1 


Installed:
  percona-release.noarch 0:0.1-3                                        


Complete!
[root@localhost TT]# 

[root@localhost TT]# yum list | grep percona
percona-release.noarch               0.1-3                     @/percona-release-0.1-3.noarch
Percona-SQL-50-debuginfo.x86_64      5.0.92-b23.89.rhel6       percona-release-x86_64
Percona-SQL-client-50.x86_64         5.0.92-b23.89.rhel6       percona-release-x86_64
Percona-SQL-devel-50.x86_64          5.0.92-b23.89.rhel6       percona-release-x86_64
Percona-SQL-server-50.x86_64         5.0.92-b23.89.rhel6       percona-release-x86_64
Percona-SQL-shared-50.x86_64         5.0.92-b23.89.rhel6       percona-release-x86_64
Percona-SQL-shared-compat.x86_64     5.0.92-b23.89.rhel6       percona-release-x86_64
Percona-SQL-test-50.x86_64           5.0.92-b23.89.rhel6       percona-release-x86_64
Percona-Server-51-debuginfo.x86_64   5.1.73-rel14.12.624.rhel6 percona-release-x86_64
Percona-Server-55-debuginfo.x86_64   5.5.40-rel36.1.el6        percona-release-x86_64
Percona-Server-56-debuginfo.x86_64   5.6.21-rel70.0.el6        percona-release-x86_64
Percona-Server-client-51.x86_64      5.1.73-rel14.12.624.rhel6 percona-release-x86_64
Percona-Server-client-55.x86_64      5.5.40-rel36.1.el6        percona-release-x86_64
Percona-Server-client-56.x86_64      5.6.21-rel70.0.el6        percona-release-x86_64
Percona-Server-devel-51.x86_64       5.1.73-rel14.12.624.rhel6 percona-release-x86_64
Percona-Server-devel-55.x86_64       5.5.40-rel36.1.el6        percona-release-x86_64
Percona-Server-devel-56.x86_64       5.6.21-rel70.0.el6        percona-release-x86_64
Percona-Server-server-51.x86_64      5.1.73-rel14.12.624.rhel6 percona-release-x86_64
Percona-Server-server-55.x86_64      5.5.40-rel36.1.el6        percona-release-x86_64
Percona-Server-server-56.x86_64      5.6.21-rel70.0.el6        percona-release-x86_64
Percona-Server-shared-51.x86_64      5.1.73-rel14.12.624.rhel6 percona-release-x86_64
Percona-Server-shared-55.x86_64      5.5.40-rel36.1.el6        percona-release-x86_64
Percona-Server-shared-56.x86_64      5.6.21-rel70.0.el6        percona-release-x86_64
Percona-Server-shared-compat.x86_64  5.1.68-rel14.6.551.rhel6  percona-release-x86_64
                                     5.1.73-rel14.12.624.rhel6 percona-release-x86_64
Percona-Server-test-51.x86_64        5.1.73-rel14.12.624.rhel6 percona-release-x86_64
Percona-Server-test-55.x86_64        5.5.40-rel36.1.el6        percona-release-x86_64
Percona-Server-test-56.x86_64        5.6.21-rel70.0.el6        percona-release-x86_64
Percona-Server-tokudb-56.x86_64      5.6.21-rel70.0.el6        percona-release-x86_64
Percona-XtraDB-Cluster-55.x86_64     1:5.5.39-25.11.824.el6    percona-release-x86_64
                                     1:5.5.39-25.11.824.el6    percona-release-x86_64
Percona-XtraDB-Cluster-56.x86_64     1:5.6.20-25.7.888.el6     percona-release-x86_64
                                     1:5.6.20-25.7.888.el6     percona-release-x86_64
Percona-XtraDB-Cluster-client.x86_64 1:5.5.34-23.7.6.565.rhel6 percona-release-x86_64
                                     1:5.5.39-25.11.824.el6    percona-release-x86_64
                                     1:5.6.20-25.7.888.el6     percona-release-x86_64
                                     1:5.5.34-23.7.6.565.rhel6 percona-release-x86_64
Percona-XtraDB-Cluster-devel.x86_64  1:5.5.34-23.7.6.565.rhel6 percona-release-x86_64
                                     1:5.5.39-25.11.824.el6    percona-release-x86_64
                                     1:5.6.20-25.7.888.el6     percona-release-x86_64
                                     1:5.5.39-25.11.824.el6    percona-release-x86_64
                                     1:5.6.20-25.7.888.el6     percona-release-x86_64
Percona-XtraDB-Cluster-galera.x86_64 2.8-1.162.rhel6           percona-release-x86_64
                                     2.11-1.2675.rhel6         percona-release-x86_64
                                     2.11-1.2675.rhel6         percona-release-x86_64
                                     3.7-1.3254.rhel6          percona-release-x86_64
                                     3.7-1.3254.rhel6          percona-release-x86_64
                                     3.1-1.169.rhel6           percona-release-x86_64
                                     3.1-1.169.rhel6           percona-release-x86_64
                                     2.8-1.162.rhel6           percona-release-x86_64
                                     2.11-1.2675.rhel6         percona-release-x86_64
                                     3.7-1.3254.rhel6          percona-release-x86_64
Percona-XtraDB-Cluster-server.x86_64 1:5.5.34-23.7.6.565.rhel6 percona-release-x86_64
                                     1:5.5.39-25.11.824.el6    percona-release-x86_64
                                     1:5.6.20-25.7.888.el6     percona-release-x86_64
Percona-XtraDB-Cluster-shared.x86_64 1:5.5.34-23.7.6.565.rhel6 percona-release-x86_64
                                     1:5.5.39-25.11.824.el6    percona-release-x86_64
                                     1:5.6.20-25.7.888.el6     percona-release-x86_64
Percona-XtraDB-Cluster-test.x86_64   1:5.5.34-23.7.6.565.rhel6 percona-release-x86_64
                                     1:5.5.39-25.11.824.el6    percona-release-x86_64
                                     1:5.6.20-25.7.888.el6     percona-release-x86_64
percona-cacti-templates.noarch       1.1.4-1                   percona-release-noarch
percona-nagios-plugins.noarch        1.1.4-1                   percona-release-noarch
percona-playback.x86_64              0.7-2.el6                 percona-release-x86_64
percona-playback-debuginfo.x86_64    0.7-2.el6                 percona-release-x86_64
percona-playback-devel.x86_64        0.7-2.el6                 percona-release-x86_64
percona-toolkit.noarch               2.2.11-1                  percona-release-noarch
percona-xtrabackup.x86_64            2.2.5-5027.el6            percona-release-x86_64
percona-xtrabackup-20.x86_64         2.0.8-587.rhel6           percona-release-x86_64
percona-xtrabackup-20-debuginfo.x86_64
                                     2.0.8-587.rhel6           percona-release-x86_64
percona-xtrabackup-20-test.x86_64    2.0.8-587.rhel6           percona-release-x86_64
percona-xtrabackup-21.x86_64         2.1.9-746.rhel6           percona-release-x86_64
percona-xtrabackup-21-debuginfo.x86_64
                                     2.1.9-746.rhel6           percona-release-x86_64
percona-xtrabackup-debuginfo.x86_64  2.2.5-5027.el6            percona-release-x86_64
percona-xtrabackup-test.x86_64       2.2.5-5027.el6            percona-release-x86_64
percona-xtrabackup-test-21.x86_64    2.1.9-746.rhel6           percona-release-x86_64
percona-zabbix-templates.noarch      1.1.4-1                   percona-release-noarch
qpress.x86_64                        11-1.el6                  percona-release-x86_64
qpress-debuginfo.x86_64              11-1.el6                  percona-release-x86_64
sysbench.x86_64                      0.5-5.el6                 percona-release-x86_64
sysbench-debuginfo.x86_64            0.5-5.el6                 percona-release-x86_64
[root@localhost TT]# 

[root@localhost TT]#  yum install Percona-Server-client-56 Percona-Server-server-56
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * epel: mirrors.ustc.edu.cn
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-Server-client-56.x86_64 0:5.6.21-rel70.0.el6 will be installed
--> Processing Dependency: Percona-Server-shared-56 for package: Percona-Server-client-56-5.6.21-rel70.0.el6.x86_64
---> Package Percona-Server-server-56.x86_64 0:5.6.21-rel70.0.el6 will be installed
--> Running transaction check
---> Package Percona-Server-shared-56.x86_64 0:5.6.21-rel70.0.el6 will be installed
--> Finished Dependency Resolution


Dependencies Resolved


========================================================================
 Package         Arch   Version            Repository              Size
========================================================================
Installing:
 Percona-Server-client-56
                 x86_64 5.6.21-rel70.0.el6 percona-release-x86_64 6.4 M
 Percona-Server-server-56
                 x86_64 5.6.21-rel70.0.el6 percona-release-x86_64  19 M
Installing for dependencies:
 Percona-Server-shared-56
                 x86_64 5.6.21-rel70.0.el6 percona-release-x86_64 720 k


Transaction Summary
========================================================================
Install       3 Package(s)


Total download size: 26 M
Installed size: 123 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): Percona-Server-client-56-5.6.21-rel70.0.e | 6.4 MB     01:48     
(2/3): Percona-Server-server-56-5.6.21-rel70.0.e |  19 MB     03:56     
(3/3): Percona-Server-shared-56-5.6.21-rel70.0.e | 720 kB     00:06     
------------------------------------------------------------------------
Total                                    76 kB/s |  26 MB     05:58     
warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Percona
Importing GPG key 0xCD2EFD2A:
 Userid : Percona MySQL Development Team <[e-mail]>
 Package: percona-release-0.1-3.noarch (@/percona-release-0.1-3.noarch)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-Percona
Is this ok [y/N]: Y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : Percona-Server-shared-56-5.6.21-rel70.0.el6.x86_64   1/3 
  Installing : Percona-Server-client-56-5.6.21-rel70.0.el6.x86_64   2/3 
  Installing : Percona-Server-server-56-5.6.21-rel70.0.el6.x86_64   3/3 
ls: 无法访问/var/lib/mysql/*.err: 没有那个文件或目录
ls: 无法访问/var/lib/mysql/*.err: 没有那个文件或目录
Giving mysqld 5 seconds to exit nicely
Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://www.percona.com/doc/percona-server/5.6/management/udf_percona_toolkit.html for more details
  Verifying  : Percona-Server-client-56-5.6.21-rel70.0.el6.x86_64   1/3 
  Verifying  : Percona-Server-server-56-5.6.21-rel70.0.el6.x86_64   2/3 
  Verifying  : Percona-Server-shared-56-5.6.21-rel70.0.el6.x86_64   3/3 


Installed:
  Percona-Server-client-56.x86_64 0:5.6.21-rel70.0.el6                  
  Percona-Server-server-56.x86_64 0:5.6.21-rel70.0.el6                  


Dependency Installed:
  Percona-Server-shared-56.x86_64 0:5.6.21-rel70.0.el6                  


Complete!
[root@localhost TT]#