MySQL Forums
Forum List  »  Newbie

Replication/Synchronization both ways
Posted by: Luk De Voght
Date: June 30, 2007 11:58AM

Hello,

I have this situation.

A central mysql database is located somewhere on a hosting partner's space. I've developed a desktop application to communicate with that mysql database. The users should be able to work anywhere, so the desktop application always connects to that online mysql database.

But as the database grows, I'm suffering some performance problems. Therefore I would like to introduce some kind of replication so that all users can work locally and the central DB is always synchronized when a user changes something.

I've read about replication and it says that there'll always be a master and a slave DB, but I want actually both ways to be "master"... I mean : when a user starts up the program it should connect to the online DB to sync the local DB so that it's exactly the same and the user can start working normally. But when he closes down the tool, the same has to happen but in the other direction, so that the central DB is aware of the changes the user has done. To avoid problems this sync has to happen like every 5 minutes (the policy will be : first update the central DB with the changes made locally and then the other way around). How can I achieve this both-way replication?

Options: ReplyQuote


Subject
Written By
Posted
Replication/Synchronization both ways
June 30, 2007 11:58AM


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.