MySQL Forums
Forum List  »  Replication

Re: what is the best option for local and cloud replicas of MySQL
Posted by: Frederic Descamps
Date: August 06, 2018 05:39AM

Hi Andrew,

This is possible, of course not all cloud providers allow you that setup. (Oracle Cloud does for example). But don't forget that you should write only on one database at the time. Conflict resolution is not part of Master/Slace (asynchronous) MySQL Replication. If you write data on both databaservers at the same time (locally and on the cloud), if data conflict, replication will break.

Cheers,

lefred.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: what is the best option for local and cloud replicas of MySQL
352
August 06, 2018 05:39AM


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.