What are some of the good options to sync two or more MySQL databases of the same schema, situated at different locations; reliably?

We have four database in four different locations.

we tried using the generic master master replication but the link breaks again and again leading to inconsistencies.

  • 1
    Not a MySQL expert, but you'll want to include more info here for others: MySQL Version, where are the different locations, do you need master-master functionality or is read-only secondary fine, what type of load does your system have, hosted in the cloud or internally, etc. - these are all important factors – LowlyDBA Sep 12 '16 at 14:52

There are many things that can go wrong in Master-Master. Use Master-Master, but do not write to both masters. Pick one for all writes; leave the other one for failover.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.