MySQLRouter 8 : How to detect correct master DB
I have 3 MySQL server with replication, one is master (Server1) and the two others slaves (Server2 and Server3).
Due to network topology, the system can get into the following state:
- Server1 is no more connected to Server2
- Server1 is no more connected to Server3
In consequence, Server2 and Server3 elect a new Master : Server2
In the same time Server1 (isolated in the cluster) still Master (and see Server2 and Server3 UNREACHABLE)
The Application Server still have access to all DB Servers.
Is MySqlRouter 8 able to choose the correct master to perform request (ie choosing Server2) ?
Subject
Views
Written By
Posted
MySQLRouter 8 : How to detect correct master DB
988
December 13, 2018 09:14AM
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.