日期:2014-05-16 浏览次数:21012 次
Percona Toolkit for MySQL is a collection of advanced command-line tools used by Percona MySQL support staff to perform a variety of MySQL server and system tasks that are too difficult or complex to perform manually, including:
1.对主从复制数据的一致性校验;
2.有效的对相关的行数据进行归档操作;
3.查到相关的重复的索引;
4.归总大批量Mysql服务的维护运维工作;
5.问题发生时收集重要的系统信息;
官网项目地址;
http://www.percona.com/software/percona-toolkit/
相关配置如下:
[root@Slave02 local]# wget percona.com/get/percona-toolkit.tar.gz --2013-04-01 13:20:06-- http://percona.com/get/percona-toolkit.tar.gz Resolving percona.com... 74.121.199.234 Connecting to percona.com|74.121.199.234|:80... connected. HTTP request sent, awaiting response... 302 Found Location: http://www.percona.com/get/percona-toolkit.tar.gz [following] --2013-04-01 13:20:07-- http://www.percona.com/get/percona-toolkit.tar.gz Resolving www.percona.com... 74.121.199.234 Reusing existing connection to percona.com:80. HTTP request sent, awaiting response... 302 Found Location: http://www.percona.com/downloads/percona-toolkit/2.2.1/percona-toolkit-2.2.1.tar.gz [following] --2013-04-01 13:20:08-- http://www.percona.com/downloads/percona-toolkit/2.2.1/percona-toolkit-2.2.1.tar.gz Reusing existing connection to percona.com:80. HTTP request sent, awaiting response... 200 OK Length: 1343968 (1.3M) [application/x-gzip] Saving to: `percona-toolkit-2.2.1.tar.gz' 100%[======================================>] 1,343,968 26.9K/s in 76s 2013-04-01 13:21:24 (17.3 KB/s) - `percona-toolkit-2.2.1.tar.gz' saved [1343968/1343968] [root@Slave02 local]# ls bin mysql cmake-2.8.5 mysqlsla-2.03 doc mysqlsla-2.03.tar.gz etc percona-toolkit-2.2.1.tar.gz games puppetlabs-release-6-1.noarch.rpm include sbin innotop-1.8.1 share innotop-1.8.1.tar.gz software lib src libexec xtrabackup-1.6.2 man xtrabackup-1.6.2.tar.gz [root@Slave02 local]#
然后进行相关的perl配置包文件,如下:
进入cpan对其进行安装
#perl -MCPAN -e shell
cpan>install DBI
cpan>install DBD::mysql
cpan>install CGI
cpan[3]> install CGI Running install for module 'CGI' Running make for M/MA/MARKSTOS/CGI.pm-3.63.tar.gz Fetching with LWP: http://mirrors.sohu.com/CPAN/authors/id/M/MA/MARKSTOS/CGI.pm-3.63.tar.gz Fetching with LWP: http://mirrors.sohu.com/CPAN/authors/id/M/MA/MARKSTOS/CHECKSUMS Checksum for /root/.cpan/sources/authors/id/M/MA/MARKSTOS/CGI.pm-3.63.tar.gz ok CPAN.pm: Building M/MA/MARKSTOS/CGI.pm-3.63.tar.gz Checking if your kit is complete... Looks good Warning: prerequisite FCGI 0.67 not found. Writing Makefile for CGI Writing MYMETA.yml an