Because internet is not always available i cannot just use one central database. So there are is a DB in every location. I need to have them all in sync, but there can be a delay of 30 minutes or maybe even 1 hour between syncing. I use mysql 5.5.62 but i could probably upgrade if needed. I could also have a server that every location can reach in a different place. Would that help if one DB goes down?
What would be my best strategy?
Thank you very much