Percona-Toolkit学习之安装和配置

jeff

出处：http://blog.chinaunix.net/uid-26446098-id-3390779.html

Percona-Toolkit的介绍：

percona-toolkit源自Maatkit 和Aspersa工具,但Maatkit已经不维护了，全部归并到percona-toolkit

完成任务工作如下：

• 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的可靠性：

Tools are a vital part of any MySQL deployment, so it's important to use ones that are reliable and well-designed. Over 4,000 tests and several years of deployment, including some of the Internet's best-known sites, have proven the reliability of the tools in Percona Toolkit. And the combined experience and expertise of Percona ensures that each tool is well thought-out and designed.

这个工具已经成为mysql部署不可或缺的一部分，它非常的可靠且设计良好，已经有超过4000个tests，和多年的部署使用，其中包括一些著名的站点，都成功的证明了Percona Toolkit的可靠性。再结合Percona的经验和专业技术，可以确认工具是经过深思熟虑后产生和设计的

获得Percona-Toolkit的方法：
wget percona.com/get/percona-toolkit.tar.gz

或者去官方网站直接下载。

安装Percona-Toolkit的先决条件：

（1）安装perl

• tar zxvf perl-5.16.0.tar.gz
• cd perl-5.16.0
• ./configure.gnu --prefix=/usr -Dpager="/bin/less -isR"
• make
• make install
  

（2）安装DBI&DBD::mysql

使用yum安装：

• yum install perl-DBI
• yum install perl-DBD-MySQL
  

或者进入cpan对其进行安装

• #perl -MCPAN -e shell
• cpan>install DBI
• cpan>install DBD::mysql
• cpan>install CGI
  

(3)安装percona-toolkit

• tar zxvf percona-toolkit-2.1.5.tar.gz
• cd percona-toolkit-2.1.5
• perl Makefile.PL
• make
• make test
• make install