Level 5
How are you planning to do it? To keep it simple, You can just keep track of what has not been synced yet (by some sort of flag field) and once online push them to the server.
Oct 13, 2017
2
Level 1
How to implement database synchronization between local and remote server
I have a web application that runs on a local server. The web app does not have an internet connection all the time. I want that when there is an internet connection it should insert the local changes to the remote database server.
Level 6
You can set up a MySQL master-slave replication, or a master-master replication if both ends create/update/delete data.
Here are docs on how to achieve this: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql
1 like
Please or to participate in this conversation.