MySQL Forums
Forum List  »  Replication

Re: Automating failover in a master-master replication topology
Posted by: Frederic Descamps
Date: February 24, 2021 04:26AM

Hello,

I do understand, but I cannot encourage you to use something that can lead in loosing data or having inconsistencies are there are no mechanism protecting you about split-brains, writing on wrong servers, etc...

The router is not designed for that. You should at least have a look at ReplicaSet with 2 servers.

I also encourage you to perform a checksum between your servers and you will be surprised as I'm sure you will find inconsistencies.

Regards,

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Automating failover in a master-master replication topology
25
February 24, 2021 04:26AM


Sorry, only registered users may post in this forum.

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.