Bug #71844 option to join FAULTY MySQL instance back into group
Submitted: 26 Feb 2014 13:31 Modified: 24 Jul 2014 23:40
Reporter: Ted Wennmark Email Updates:
Status: Closed Impact on me:
Category:MySQL Fabric Severity:S4 (Feature request)
Version:1.4.1 OS:Any
Assigned to: CPU Architecture:Any

[26 Feb 2014 13:31] Ted Wennmark

I'm missing a option to re-join a faulty MySQL instance into a HA-group.

1) My Primary dies due to power outage 
2) New Primary is elected from secondaries
3) After some time I power up my 'old' primary and would like to have it joining my HA-group

I would liked to use command: mysqlfabric server set_status <UUID of old primary> SECONDARY

but this failed with output: ServerError: Cannot put server (UUID) whose status is (FAULTY) in (SECONDARY) status.

Having to do a group remove/add seem unnecessary?

Kind Regards,

How to repeat:

1) kill primary server in group
2) start up old primary
3) try to have it join HA group without remove/add
[3 Mar 2014 9:06] Mats Kindahl
Thank you for a reasonable feature request. Verified as described.

Currently, it is necessary to remove the server from the group and add it again, but it is reasonable to allow set_status to be used to bring the server in as a secondary again without having to remove it first.
[24 Jul 2014 23:40] Philip Olson
Posted by developer:
This was documented a few months (or so) ago, thank you for the bug report.