Percona_Toolkit 簡介及安裝 -- MySQL管理員必備的工具包

Percona_Toolkit

Percona Toolkit 的簡介：（來自官方的簡介）

Percona Toolkit for MySQL is a collection for advanced command-line tools userd by Percona MySQL staff to perform a variety of MySQL server and system tasks that are too difficult or complex to perform manually, including:

-Verify master and replica data consistency

-Efficiently archive rows

-Find duplicate indexes

-Summarize MySQL servers

-Analyze queries from logs and tcpdump

-Collect vital system information when problems occur

Percona Toolkit 的系統要求：(或者稱為環境變數的要求)

Most tools require:

* Perl v5.8 or newer

* Bash v3 or newer

* Core Perl modules like Times:HiRes

Tools that connect to MySQL require:

* Perl modules DBI and DBD::mysql and perl-IO-Socket-SSL

* MySQL 5.0 or newer

Percona Toolkit is only tested on UNIX system,primary Debian and Red Hat derivatives;other operating systems are not supperted.

注釋：rpm安裝Percona Toolkit 具體需安裝perl的那些模組根據自己的系統內容或者參考安裝過程碰到的錯誤去決定需安裝那些。

Percona Toolkit 的安裝：

1:下載percona toolkit的包：（可以是源碼包，或者RPM）

訪問：http://www.percona.com/software/percona-toolkit/ 下載最新穩定的版本。也可以如下命令列的方式下載最新版本。

wget percona.com/get/percona-toolkit.tar.gz

wget percona.com/get/percona-toolkit.rpm

2：安裝於Perl相關的模組

yum install perl-DBI

yum install perl-DBD-MySQL

yum install perl-Time-HiRes

yum install perl-IO-Socket-SSL

3: 安裝Percona Toolkit

rpm -Uvh percona-toolkit-2.2.1-2.noarch.rpm

OK，就這麼簡單，安裝完畢。

特別說明：

本機為：Linux mysql.example.com 2.6.18-308.el5 #1 SMP Tue Feb 21 20:06:06 EST 2012 x86_64 x86_64 x86_64 GNU/Linux

安裝錯誤：

在yum install perl-DBD-MySQL時，出現如下錯誤資訊

---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated

--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: perl-DBD-MySQL

--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: perl-DBD-MySQL

--> Running transaction check

---> Package mysql.x86_64 0:5.0.95-5.el5_9 set to be updated

--> Processing Conflict: mysql conflicts MySQL

--> Finished Dependency Resolution

mysql-5.0.95-5.el5_9.x86_64 from updates has depsolving problems

--> mysql conflicts with MySQL-server

Error: mysql conflicts with MySQL-server

由於我安裝的是5.5.xx的MySQL版本，而系統內建的是5.0xx版本的，而libmysqlclient.so.15是由5.0版本提供的，所以就出錯了。如果你的系統是CentOS6.X系列的，MySQL內建的為5.1以上，可能不會出現這個問題了。解決方案如下：

rpm -Uvh MySQL-shared-compat-5.5.31-1.rhel5.x86_64.rpm

MySQL-shared-compat為用戶端的libraries ，向下相容。

在yum install perl-DBD-MySQL就沒有問題了。

相關閱讀：Percona Toolkit 2.2 發布，相容 MySQL 5.6