title: Data Synchronization between Mobile App and Cloud
body: <p>Well, I'm building a app in both iOS and Android and both app needs to be syncronized with the cloud DB MySQL. Both the apps works offline so I need all the insert and update functionality. Delete is probably not going to be used but still I'd like to know.</p>
  
  <p>Well, what I'm looking here is the solution or ideas or algo that's needs to done to achieve this.</p>
  
  <p>I have kept CreatedOn and LastSync as timestamp column on each table.</p>
  
  <p>Now the problem is should I always keep checking all the rows and all the columns everytime?</p>
  
  <p>What I think is I should keep ModifiedOn column on all the tables and check that with LastSync for every device id. What do you guys suggest?</p>