Database Synchronization

[cyber-duck]

hi
I am thinking of using http://www.ollacart-pos.com as local POS inside a store and have the main website hosted remotely. I've looked for other threads but didn't find anything on data synchronization.

The website run on the remote server with the main db but the POS will need a local server as backup in case the internet connection goes down, so in-store sales can keep being registered.

Having the main webserver in the store would be too much of hassle.

Has anything been done on data synchronization? What would be the main issues of sync (in terms of products_id, orders_id...)?

Thanks for your help
SR

[kobra]

Here is a link to only one solution: SQLyog

[cyber-duck]

thanks for the link

I had a look but if local and remote db are disconnected due to internet failure, some products_id or order_id will be duplicated and the sync won't be able to keep all the details in order, there is too many tables involved...