MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Automating failover in a master-master replication topology
831
Vangelis Pagonis
February 23, 2021 07:47AM
Re: Automating failover in a master-master replication topology
354
Frederic Descamps
February 23, 2021 11:11AM
Re: Automating failover in a master-master replication topology
390
Vangelis Pagonis
February 24, 2021 03:42AM
Re: Automating failover in a master-master replication topology
384
Frederic Descamps
February 24, 2021 04:26AM
Re: Automating failover in a master-master replication topology
465
Vangelis Pagonis
February 24, 2021 06:43AM
Re: Automating failover in a master-master replication topology
413
Frederic Descamps
February 24, 2021 08:48AM


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.