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 | +------------+-------+---------+--------+------------+---------+