How do you manage two-way synchronization between a 'main' database server and many 'secondary' servers, in particular conflict resolution, assuming a connection is not always available(offline syncing)?
For example, I have an Android application which is use data from local database(sqlite). And user can deal with data even it is online or offline. In meantime when if it is online, then local database(sqlite) should sync with real database(mysql) in the server and resolve conflicts as a background service.
Is there any solution already implemented for this kind of scenario ?
I heard about Couchdb which is a NoSQL solution can be a solution for this. If it is so Can I use it with SQL ?