mysql-unit之 mysqlfailover 在mysql 复制环境中的使用

jikcheng

使用mysqlfailover 查看当前的
 [root@mysqldb ~]# mysqlfailover --master=root:123@127.0.0.1:3307 --discover-slaves-login=root:123 --rpl-user=root;

Q-quit R-refresh H-health G-GTID Lists U-UUIDs L-log entries
[root@mysqldb ~]# mysqlfailover --master=root:123@127.0.0.1:3307 --discover-slaves-login=root:123 --rpl-user=root --log=log.txt
WARNING: Using a password on the command line interface can be insecure.
# Discovering slaves for master at 127.0.0.1:3307
# Discovering slave at 127.0.0.1:3308
# Found slave: 127.0.0.1:3308
# Discovering slave at 127.0.0.1:3309
# Found slave: 127.0.0.1:3309
# Checking privileges.
# WARNING: Errant transaction(s) found on slave(s).
#  - For slave '127.0.0.1@3308': 33b5d89c-70bd-11e4-80ee-000c2947db3a:1
#  - For slave '127.0.0.1@3309': 428092cc-70bd-11e4-80ee-000c2947db3a:1
MySQL Replication Failover Utility
Failover Mode = auto     Next Interval = Fri Nov 21 10:51:42 2014

Master Information
------------------
Binary Log File      Position  Binlog_Do_DB  Binlog_Ignore_DB 
mysql1db-bin.000004  191                                      

GTID Executed Set
2d5f5c23-70bd-11e4-80ee-000c2947db3a:1-6

WARNING: Errant transaction(s) found on slave(s). Check log for more details.
Replication Health Status
+------------+-------+---------+--------+------------+---------+
| host       | port  | role    | state  | gtid_mode  | health  |
+------------+-------+---------+--------+------------+---------+
| 127.0.0.1  | 3307  | MASTER  | UP     | ON         | OK      |
| 127.0.0.1  | 3308  | SLAVE   | UP     | ON         | OK      |
| 127.0.0.1  | 3309  | SLAVE   | UP     | ON         | OK      |
+------------+-------+---------+--------+------------+---------+