What is the best way to synchronize database via internet? MySQL -

What is the best way to synchronize database via internet? MySQL -

i want build desktop application pos. user can come in info , save info local database instead of accessing remote database in server. reason want cut down traffic , create application more responsive since create less overhead of accessing remote database.

i want build @ to the lowest degree 5 client of desktop application , each of them has local database. along these clients, setup server database utilize reports or online access displays status , info of clients.

for example, specific user uses client machine, of info stored in local database before can transported server database synchronization. seem scheme doesn't give real time info update server need. since server database used reporting purposes, there no info in server manipulated client.

you may looking jumpmind product called symmetricds. sync info branch offices central office, sharing info offices , syncing subsets of info specific offices.

mysql database data-synchronization