MySQL Forums
Forum List  »  Replication

MySQLRouter 8 : How to detect correct master DB
Posted by: david deman
Date: December 13, 2018 09:14AM

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) ?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQLRouter 8 : How to detect correct master DB
701
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.