title: Strategy on synchronizing database from multiple locations to a central database and vice versa
body: <p>I have several databases 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. </p>
  
  <p>I would like to synchronise 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.</p>
  
  <p>Any ideas on how to go about this?</p>