mysql-utilities工具体验(四)
| OK |
| 192.168.1.133 | 3306 | SLAVE | UP | ON | Binary log and Relay log filters differ. |
+----------------+-------+---------+--------+------------+-------------------------------------------+
Q-quit R-refresh H-health G-GTID Lists U-UUIDs
[root@mysql56-master home]#
5. mysqlrpladmin. 对主从进行管理。
[sql]
停止从机服务：
[root@mysql56-master home]# mysqlrpladmin --master=root:root@192.168.1.131:3306 --slaves=root:root@192.168.1.132:3306,root:root@192.168.1.133:3306 stop
# Checking privileges.
# Performing STOP on all slaves.
# Executing stop on slave 192.168.1.132:3306 Ok
# Executing stop on slave 192.168.1.133:3306 Ok
# ...done.
[root@mysql56-master home]#
开启从机服务：
[root@mysql56-master home]# mysqlrpladmin --master=root:root@192.168.1.131:3306 --slaves=root:root@192.168.1.132:3306,root:root@192.168.1.133:3306 stop
# Checking privileges.
# Performing STOP on all slaves.
# Executing stop on slave 192.168.1.132:3306 Ok
# Executing stop on slave 192.168.1.133:3306 Ok
# ...done.
[root@mysql56-master home]#
选择最好的备机准备以后切换用.
[root@mysql56-master home]# mysqlrpladmin --master=root:root@192.168.1.131:3306 --slaves=root:root@192.168.1.132:3306,root:root@192.168.1.133:3306 elect
# Checking privileges.
# Electing candidate slave from known slaves.
# Best slave found is located on 192.168.1.132:3306.
# ...done.
[root@mysql56-master home]#
进行主从切换。
[root@mysql56-master home]# mysqlrpladmin --master=root:root@192.168.1.131:3306 --slaves=root:root@192.168.1.132:3306,root:root@192.168.1.133:3306 --new-master=root:root@192.168.1.132:3306 --demote-master switchover
# Checking privileges.
# Performing switchover from master at 192.168.1.131:3306 to slave at 192.168.1.132:3306.
# Checking candidate slave prerequisites.
# Checking slaves configuration to master.
# Waiting for slaves to catch up to old master.
# Stopping slaves.
# Performing STOP on all slaves.
# Demoting old master to be a slave to the new master.
# Switching slaves to new master.
# Starting all slaves.
# Performing START on all slaves.
# Checking slaves for errors.
# Switchover complete.
#
# Replication Topology Health:
+----------------+-------+---------+--------+------------+-----------------------------+
| host | port | role | state | gtid_mode | health |
+----------------+-------+---------+--------+------------+-----------------------------+
| 192.168.1.132 | 3306 | MASTER | UP | ON | OK |
| 192.168.1.131 | 3306 | SLAVE | UP | ON | OK |
| 192.168.1.133 | 3306 | SLAVE | UP | ON | OK |
+----------------+-------+---------+--------+------------+-----------------------------+
# ...done.
[root@mysql56-master home]#
显示下新的主从架构：
[root@mysql56-master home]# mysqlrplshow --master=root:root@192.168.1.132:3306 --discover-slaves-login=root:root -v
# master on 192.168.1.132: ... connected.
# Finding slaves for master: 192.168.1.132:3306
# Replication Topology Graph
192.168.1.132:3306 (MASTER)
|
+--- 192.168.1.131:3306 [IO ru