I have a Master-Master MySQL Setup (5.6) with an additional Slave attached to Master 1:
Master 1 (alive) <---> Master 2 (alive)
|
Slave 1
Now when Master 1 dies, i want the Slave to automatically switch to the other Master and receive updates from there:
Master 1 (DEAD) <---> Master 2 (alive)
|
Slave 1
Is there any tool that handles this for me?
I believe this HA Failover scenario is not very uncommon, but unfortunately I could not find any tool to automate this.