Mysqlfailover command - No slave is listed in health status

5 votes

1 answer

524 views

                          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:abc@10.24.184.12: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 mysqlrplcheck and mysqlrplshow commands, the slave is listed.

Is this normal?

                        

Asked by Aneesha (51 rep)

May 11, 2015, 11:48 AM
Last activity: Apr 14, 2025, 11:06 AM

Mysqlfailover command - No slave is listed in health status

Related Questions