mysql-utilities工具体验
我主要体验了下几个关于REPLICATION的工具。
先说下我的环境：
MASTER: 192.168.1.131
SLAVE: 192.168.1.132, 192.168.1.133
三台DB都有对外的ALL权限用户。
各个配置文件如下，
[sql]
[root@mysql56-master home]# cat /etc/my.cnf
[mysqld]
user = ytt
skip-name-resolve
innodb_buffer_pool_size = 128M
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
server_id = 131
socket = /tmp/mysql.sock
explicit_defaults_for_timestamp
log-bin=mysql56-master-bin
binlog-ignore-db=mysql
gtid-mode=on
enforce-gtid-consistency
log-slave-updates
binlog-format=ROW
sync-master-info=1
report-host=192.168.1.131
report-port=3306
master_info_repository=table
relay_log_info_repository=table
其他两台SERVER，除了SERVER-ID，都基本相同，我就不贴了。
1. MYSQLREPLICATE 搭建主从的脚本，这里我搭建了两台从机。
[sql]
mysqlreplicate --master=root:root@192.168.1.131:3306 --slave=root:root@192.168.1.132:3306;...
[root@mysql56-master home]# ./replicate_create
# master on 192.168.1.131: ... connected.
# slave on 192.168.1.132: ... connected.
# Checking for binary logging on master...
# Setting up replication...
# ...done.
# master on 192.168.1.131: ... connected.
# slave on 192.168.1.133: ... connected.
# Checking for binary logging on master...
# Setting up replication...
# ...done.
2. mysqlrplcheck 检查主从的运行情况。
[sql]
[root@mysql56-master home]# mysqlrplcheck --master=root:root@192.168.1.131:3306 --slave=root:root@192.168.1.132:3306 -s
# master on 192.168.1.131: ... connected.
# slave on 192.168.1.132: ... connected.
Test Description Status
---------------------------------------------------------------------------
Checking for binary logging on master [pass]
Are there binlog exceptions [WARN]
+---------+--------+------------+
| server | do_db | ignore_db |
+---------+--------+------------+
| master | | mysql |
| slave | | mysql |
+---------+--------+------------+
Replication user exists [pass]
Checking server_id values [pass]
Checking server_uuid values [pass]
Is slave connected to master [pass]
Check master information file [pass]
Checking InnoDB compatibility [pass]
Checking storage engines compatibility [pass]
Checking lower_case_table_names settings [pass]
Checking slave delay (seconds behind master) [pass]
#
# Slave status:
#
Slave_IO_State : Waiting for master to send event
Master_Host : 192.168.1.131
Master_User : rpl
Master_Port : 3306
Connect_Retry : 60
Master_Log_File : mysql56-master-bin.000002
Read_Master_Log_Pos : 151
Relay_Log_File : mysql56-slave-relay-bin.000003
Relay_Log_Pos : 379
Relay_Master_Log_File : mysql56-master-bin.000002
Slave_IO_Runnin