Percona Toolkit MySQL主从检查工具安装

说明：在现在项目开发中MySQL的主从架构的使用是很常见的，主从同步的问题也会经常遇到，还好有专门的工具来检查不同步的SQL问题。

官网：Percona Toolkit 

1.RPM包安装：

[root ~]$ wget https://downloads.percona.com/downloads/percona-toolkit/3.2.1/binary/redhat/8/x86_64/percona-toolkit-3.2.1-1.el8.x86_64.rpm
[root ~]$ yum install perl-IO-Socket-SSL perl-DBD-MySQL perl-Time-HiRes -y
[root ~]$ rpm -ivh percona-toolkit-3.2.1-1.el8.x86_64.rpm

2.源码包安装：

[root ~]$ wget https://downloads.percona.com/downloads/percona-toolkit/3.2.1/binary/tarball/percona-toolkit-3.2.1_x86_64.tar.gz
[root ~]$ tar zxf percona-toolkit-3.2.1_x86_64.tar.gz -C /usr/local/percona-toolkit_3.2.1/
[root ~]$ cd /usr/local/percona-toolkit_3.2.1 && mv * /usr/local/percona-toolkit_3.2.1/ && rm -rf percona-toolkit-3.2.1/
[root percona-toolkit-3.2.1]$ perl Makefile.PL
[root percona-toolkit-3.2.1]$ make && make install

3.默认安装目录：

/usr/local/bin/

源码安装遇到的坑：

make && make install 执行编译和安装的时候可能会遇到下面的问题：

Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at Makefile.PL                                line 1.
BEGIN failed--compilation aborted at Makefile.PL line 1

填坑：

yum install perl-ExtUtils-MakeMaker
yum -y install perl-CPAN

参考：

https://www.cnblogs.com/xuanzhi201111/p/4128894.html
https://www.cnblogs.com/xuanzhi201111/p/4180638.html
https://www.jb51.net/article/155391.htm