Percona-Toolkit的介绍:
percona-toolkit 源自 Maatkit 和 Aspersa 工具,但Maatkit已经不维护了,全部归并到percona-toolkit
完成任务工作如下:
获得Percona-Toolkit的方法:
wget percona.com/get/percona-toolkit.tar.gz
或者去官方网站直接下载。
安装Percona-Toolkit的先决条件:
使用yum安装:
或者进入cpan对其进行安装
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