MySQL手记7 — MySQL Utilities工具包
一、MySQL Utilities简介
MySQL Utilities是MySQL官方的数据库工具包,下载地址为:https://downloads.mysql.com/archives/utilities/。 该工具包主要是给DBA提供了在运维上可能需要的数据库工具。
(官方文档:https://downloads.mysql.com/docs/mysql-utilities-1.6-en.pdf)
下载后,解压得到如下目录:
1
2
3
4
5
6
7
8
9
10
11
12
13
build
CHANGES.txt
docs
info.py
info.pyc
LICENSE.txt
mysql
PKG-INFO
README.txt
scripts
setup.py
unit_tests
执行python setup.py install:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
......
running install_scripts
copying build/scripts-2.7/mysqlfrm -> /usr/bin
copying build/scripts-2.7/mysqlgrants -> /usr/bin
copying build/scripts-2.7/mysqlbinlogmove -> /usr/bin
copying build/scripts-2.7/mysqldbexport -> /usr/bin
copying build/scripts-2.7/mysqluc -> /usr/bin
copying build/scripts-2.7/mysqlrplshow -> /usr/bin
copying build/scripts-2.7/mysqlrplsync -> /usr/bin
copying build/scripts-2.7/mysqldbcopy -> /usr/bin
copying build/scripts-2.7/mysqlindexcheck -> /usr/bin
copying build/scripts-2.7/mysqlauditgrep -> /usr/bin
copying build/scripts-2.7/mysqlbinlogpurge -> /usr/bin
copying build/scripts-2.7/mysqldbimport -> /usr/bin
copying build/scripts-2.7/mysqldiskusage -> /usr/bin
copying build/scripts-2.7/mysqlfailover -> /usr/bin
copying build/scripts-2.7/mysqlrplcheck -> /usr/bin
copying build/scripts-2.7/mysqlreplicate -> /usr/bin
copying build/scripts-2.7/mysqlmetagrep -> /usr/bin
copying build/scripts-2.7/mysqlauditadmin -> /usr/bin
copying build/scripts-2.7/mysqlslavetrx -> /usr/bin
copying build/scripts-2.7/mysqlrplms -> /usr/bin
copying build/scripts-2.7/mysqldbcompare -> /usr/bin
copying build/scripts-2.7/mysqluserclone -> /usr/bin
copying build/scripts-2.7/mysqlserverinfo -> /usr/bin
copying build/scripts-2.7/mysqlserverclone -> /usr/bin
copying build/scripts-2.7/mysqldiff -> /usr/bin
copying build/scripts-2.7/mysqlbinlogrotate -> /usr/bin
copying build/scripts-2.7/mysqlprocgrep -> /usr/bin
copying build/scripts-2.7/mysqlrpladmin -> /usr/bin
changing mode of /usr/bin/mysqlfrm to 755
changing mode of /usr/bin/mysqlgrants to 755
changing mode of /usr/bin/mysqlbinlogmove to 755
changing mode of /usr/bin/mysqldbexport to 755
changing mode of /usr/bin/mysqluc to 755
changing mode of /usr/bin/mysqlrplshow to 755
changing mode of /usr/bin/mysqlrplsync to 755
changing mode of /usr/bin/mysqldbcopy to 755
changing mode of /usr/bin/mysqlindexcheck to 755
changing mode of /usr/bin/mysqlauditgrep to 755
changing mode of /usr/bin/mysqlbinlogpurge to 755
changing mode of /usr/bin/mysqldbimport to 755
changing mode of /usr/bin/mysqldiskusage to 755
changing mode of /usr/bin/mysqlfailover to 755
changing mode of /usr/bin/mysqlrplcheck to 755
changing mode of /usr/bin/mysqlreplicate to 755
changing mode of /usr/bin/mysqlmetagrep to 755
changing mode of /usr/bin/mysqlauditadmin to 755
changing mode of /usr/bin/mysqlslavetrx to 755
changing mode of /usr/bin/mysqlrplms to 755
changing mode of /usr/bin/mysqldbcompare to 755
changing mode of /usr/bin/mysqluserclone to 755
changing mode of /usr/bin/mysqlserverinfo to 755
changing mode of /usr/bin/mysqlserverclone to 755
changing mode of /usr/bin/mysqldiff to 755
changing mode of /usr/bin/mysqlbinlogrotate to 755
changing mode of /usr/bin/mysqlprocgrep to 755
changing mode of /usr/bin/mysqlrpladmin to 755
......
从安装过程打印的信息来看,该工具包是使用Python进行开发的,并在安装过程把python脚本复制在/use/bin目录下,新增了多个mysql*开头的可执行文件,这些文件,就是Utilities中的工具。后续将逐步介绍常用的集中工具:
和pt工具相比,两个工具包相辅相成,虽说在实际工作中,pt工具用得更多,但是,在部分场景,MySQL Utilities也可以发挥其的作用,灵活运用好这两个工具包,可以让工作更加得心应手。
欢迎关注公众号:朔的话: