MySQL Forums
Forum List  »  Replication

Re: Automating failover in a master-master replication topology
Posted by: Vangelis Pagonis
Date: February 24, 2021 03:42AM

Hi Iefred,

Thanks a lot for your answer.

This all topology started from a simple migration from 5.1 to 5.7-where applications are tested, and it continued with implementing a highly available environment.

Due to our business concept, I assumed implementing a master-master replication env, where one master is active and second passive, will cover our needs.

So ended to above architecture and I was looking more on how mysqlrouter will understand that is safe to failover. Is there a way to run e.g. a condition script checking health of both masters on mysqlrouter level before failovering? Or better how to perform a safe automated failover from active to passive master?



Options: ReplyQuote

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

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.