MySQL Forums
Forum List  »  General

Synchronizing multiple databases with a Master
Posted by: Brad
Date: September 12, 2006 12:31PM

I have a problem where there are multiple instances of a mysql database stored on separate local computers that are not always able to connect to the internet. The users edit the database locally using php scripts and then need to upload the new information when an internet connection becomes available. The master database and all the child databases have the same table structure, its just that children may be updating locally at the same time so replication of the master for updating seems like it would overwrite some data.

Is there anyway that I can merge/update/synchronize the data is these databases easily and correctly?

Any help at all would be much appreciated.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Synchronizing multiple databases with a Master
September 12, 2006 12:31PM


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.