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