MySQL Forums
Forum List  »  Replication

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

Hi Vangelis,

No problem ;)

But you should really think about a better backend architecture and of course avoid MyISAM too !

DRDB is also something I would try to avoid.

Help your client to have a better usage of MySQL by migrating first to InnoDB and then use Asynchronous Replication with Manual Failover (MySQL InnoDB ClusterSet, with 2 nodes) or all automated using MySQL InnoDB Cluster.
In both cases, MySQL Router will understand the topology and perform the right routing.

Regards and good luck ;)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Automating failover in a master-master replication topology
28
February 24, 2021 08:48AM


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.