I'm developing a software in windows blends and i need it to be syncronized 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 syncronized so when a data is entered online it will be reflected in the software app. I need seperate 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 bothways where one is local and other online.
Also how to find out when a synchronization breaks?