MySQL Forums
Forum List  »  Synchronization

Scenario on synchronizing database from multiple locations to a central database and vice versa
Posted by: SivaKumar A
Date: October 10, 2011 03:48AM

I have several databases server located in different locations and a central database which is in a data center. All have the same schema. All of them are changed(insert/update/delete) in each location with different data including the central database.

I would like to synchronise(manully at midnight using some scripts) all the data in the central database. I would also like all data in the central database synchronise to all locations. What I mean is that database change in location 1 should also be reflected in location 2 database.

Any ideas on how to go about this using the procedure scripts ?

Thanks in Advance

Michael SopRaj

Options: ReplyQuote


Subject
Views
Written By
Posted
Scenario on synchronizing database from multiple locations to a central database and vice versa
4934
October 10, 2011 03:48AM


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.