MySQL Forums
Forum List  »  Replication

keeping databases in sync
Posted by: Ju Lee
Date: January 03, 2013 02:25PM

Hi there. I'm new to replication in general... so i apologize if my question seems a little silly.
I would like to know if there is a way to keep databases in sync... but in both directions. Meaning... both are masters and both are slaves to eachother.
I read up a little about designating a master database and having as many slaves configured to this master.
However, what I'd like to do is also track any changes the slaves make and replicate back to the master.
Unfortunately, my client is indicating that they cannot set up one database and have all the remote sites write to one database. They want each site with a separate database... but this database must be kept in sync between sites.
Is this possible?

Options: ReplyQuote

Written By
keeping databases in sync
January 03, 2013 02:25PM
January 06, 2013 06:10PM

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.