Hi,
This is my scenario:
* A master database in the internet with data from multiple office branches.
* Each branch office has sporadic access to the internet. Hence sections of
the database need to be stored offline in the branch.
* Every evening, the head office should be a able to view/modify/delete data
from the branches (only operate on the master database) (changes from branch
uploaded in evening).
* Next day morning the branch office should be able to see updated database.
(download the modified contents overnight or early morning)
Both the master database and the branch run on Linux.
To my knowledge, I understand that MySQL replication is a one-way street.
One master many slave system and slaves only sync themselves to the master
and the master does not sync itself to the slaves. Am i wrong?
Any simple solution for this?
Regards,
Arun