I have an web application running on a single MySQL database. The users are in remote communities where internet access is not available for hours at a time. I would like to set up MySQL servers in each of the communities which sync with a centralized master when the internet is available. The application is reading and writing. Each community is mostly accessing its own data, so there would be little conflict. I have looked a bit at Amazon database migration service and sharding. Any ideas?