I have 3 MySQL servers which is running with circular replication.
- Server A version - 5.5
- Server B version - 5.6.21
- Server C version - 5.6.21
Master Server FOR Slave Server
C FOR A A FOR B B FOR C
Above structure is working well with circular replication.
Now, if Server C is down then automatically Server B becomes a master of Server A and Server A become master of Server B.
I want this kind of auto switching utility which reduce the manual coding.
I did Google but I did and after that I am really confused what to do and how any utility implement in my structure that monitor the Master server is alive or not.