MySQL Database synchronizing with local and remote with c#
Posted
by
Neo
on Server Fault
See other posts from Server Fault
or by Neo
Published on 2012-08-28T09:32:48Z
Indexed on
2012/08/28
9:40 UTC
Read the original article
Hit count: 324
synchronization
|c#
I've posted this here as its more of a mysql questions than c#, I have written some software that runs a local instance of mysql when it first starts, now once mysql is up I would like to synchronize the data between the remote database table and the local database table that the software runs (it shouldn't sync any other databases / tables as there are a lot).
I have replication setup to synchronize the entire database to another server which works unless the server goes down then it never comes back up, so based on that I don't think replication will work as when the software is closed it also closes MySQL.
So what would be the best method of synchronizing the remote and local databases?
© Server Fault or respective owner