安装percona-toolkit步骤

1. 下载percona-toolkit 包

官网下载即可。链接： https://www.percona.com/downloads/percona-toolkit/LATEST/

2. 安装依赖

  • yum install perl-DBI
  • yum install perl-DBD-MySQL
  • yum install perl-Time-HiRes
  • yum install perl-IO-Socket-SSL
    如果安装过程中出现如下错误：
Error: Package: perl-DBD-MySQL-4.023-6.el7.x86_64 (base)
           Requires: libmysqlclient.so.18()(64bit)
Error: Package: perl-DBD-MySQL-4.023-6.el7.x86_64 (base)
           Requires: libmysqlclient.so.18(libmysqlclient_18)(64bit)
Error: Package: 2:postfix-2.10.1-6.el7.x86_64 (@anaconda)
           Requires: libmysqlclient.so.18()(64bit)
Error: Package: 2:postfix-2.10.1-6.el7.x86_64 (@anaconda)
           Requires: libmysqlclient.so.18(libmysqlclient_18)(64bit)
 You could try using --skip-broken to work around the problem
** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:
2:postfix-2.10.1-6.el7.x86_64 has missing requires of libmysqlclient.so.18()(64bit)
2:postfix-2.10.1-6.el7.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_18)(64bit)

则是有依赖包没有安装，去mysql 官网下载一个即可。
接着安装percona-toolkit。接着报错

[root@server4 mysql]# rpm -ivh percona-toolkit-3.0.12-1.el7.x86_64.rpm
warning: percona-toolkit-3.0.12-1.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
	perl(Digest::MD5) is needed by percona-toolkit-3.0.12-1.el7.x86_64

则需要执行如下命令：

yum -y install perl-Digest-MD5

最后安装percona-toolkit

[root@server4 mysql]# rpm -ivh percona-toolkit-3.0.12-1.el7.x86_64.rpm
warning: percona-toolkit-3.0.12-1.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:percona-toolkit-3.0.12-1.el7     ################################# [100%]