I have successfully created replication using
GTID_MODE. It works perfectly. Now I need to setup automatic failover feature in it. I have run the following command.
mysqlfailover --master=root:email@example.com:3306 --discover-slaves-login=root:abc
I have got the following results. No slave is listed.
MySQL Replication Failover Utility Failover Mode = auto Next Interval = Tue May Master Information ------------------ Binary Log File Position Binlog_Do_DB Binlog mysql-bin.000016 9568 GTID Executed Set 8fe8b710-cd34-11e4-824d-fa163e52e544:1-1143 Replication Health Status 0 Rows Found. Q-quit R-refresh H-health G-GTID Lists U-UUIDs U
But when I execute the
mysqlrplshow commands, the slave is listed.
Is this normal?