>Hi Guys,
>
>Basically, I am doing a POS app which will be used by a handful of branches and one head office. All will be connected via internet.
>
>We would like for the following to be implemented:
>
>1. Whenever head office say creates, deletes or modifies a new product, it will be propagated to the Products table of each branch.
>
>2. Conversely, branch sales data feeds are pushed to the head office.
>
>3. In the event that internet connection fails during this "synching", how does one know where "we left off" to continue?
>
>Thank you very much in advance for all your efforts!
>
>Long live the Fox!

Google MySql Replication or Synchronization. Check/perhaps rethink your key generation, think whether seq numbers or TS are better for your situation