I'm developing a software in Microsoft Blend and I need it to be synchronized with my online server MySQL database. I have local MySQL database which I use for the app. The app also have an online version in PHP with a MySQL database. So the user can enter either by the online version or offline app. So I need both the databases to be synchronized so when a data is entered online it will be reflected in the software app. I need separate databases because when the app is not connected to internet, it should work perfectly and when reconnected it should start synchronization both ways i.e. from local to online and from online to local database.
So basically I need 2 MySQL databases to be synchronized both ways where one is local and other online.
Also how to find out when a synchronization breaks?
Best Answer
Schedule a job to backup one database and apply the backup script to another, that way you never need to worry about the synchronization as it is done automatically on a schedule