MySQL Forums
Forum List  »  Utilities

Pick the wrong master and fails to failover
Posted by: Philippe Florent
Date: June 22, 2016 07:44AM

Hello,

following this : https://dev.mysql.com/doc/mysql-utilities/1.5/en/fabric-quick-start-replication.html

I created one slave, one master, and replication is working between them

I install fabric on a separate box , create a group and add both machines to that group

now 2 things strike me

first fabric set the primary on the slave instead of the master

mysqlfabric group lookup_servers my_group
Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1

server_uuid address status mode weight
------------------------------------ ------------- --------- ---------- ------
24e83dc5-3848-11e6-b605-0050569958d0 slave:3306 PRIMARY READ_WRITE 1.0
acb3a95e-3847-11e6-b25a-005056996666 master:3306 SECONDARY READ_ONLY 1.0


second, as I power off the slave(considered as master by fabric) to check the failover, the group health command hangs, and once I power back on the slave, I get this

mysqlfabric group health my_group

Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1

uuid is_alive status is_not_running is_not_configured io_not_running sql_not_running io_error sql_error
------------------------------------ -------- --------- -------------- ----------------- -------------- --------------- -------------------------------------------------------------------------------------- ---------
24e83dc5-3848-11e6-b605-0050569958d0 0 FAULTY 0 0 0 0 False False
acb3a95e-3847-11e6-b25a-005056996666 1 SECONDARY 0 0 1 0 error connecting to master 'fabric_server@slave:3306' - retry-time: 60 retries: 12 False


this all dont make any sense...

- how do I force fabric to take te correct master ?

- why the failover fails so miserably ?

thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Pick the wrong master and fails to failover
1229
June 22, 2016 07:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.