MySQL Forums
Forum List  »  Replication

DB Replication Failover
Posted by: Dan K
Date: November 26, 2018 12:57PM

Hi All,

1. I have an application that writes 10 million of records per day. (We currently have one database - master that the application writes to it using its DNS record).
2. We want to implement replication (asynchronised).
3. I'd like to know what is the best method to do a failover with that method?What should be the order of things?
3.1 Do we switch to the new master and then change the DNS record to point to it? OR the opposite way?
3.2 Moreover - how can we switch back to the 'old' master once its restored?

Thank you.

Options: ReplyQuote

Written By
DB Replication Failover
November 26, 2018 12:57PM

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.