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

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

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.