2

I have two machines in a master - slave replication. I want to know if they are in two seperate places e.g. London, England and Tokyo, Japan are there going to be any latency issues.

What exactly is the maximum latency (if possible measured using distance) that mysql replication can tolerate before an error happens or before the two databases are different enough that the second one can give wrong data or any other error?

1
2

You should consider what distance does to any DB connection.

I have some posts from myself and others on this subject

Another member of this StackExchange, Aaron Brown, wrote a nice blog about measuring latency even with semisynchronous replication. Although his blog is 8 years old and technology has improved since, you should write the same test Aaron did to test the latency yourself. After all, London to Tokyo is intercontinental where US West to US East is within the same country. Latency should be expected, but only your testing will reveal how tolerable it will be.

Please review them and see if you can setup semisynchronous replication.

CAVEAT : if you are using Amazon RDS or Google GCP, you are at their mercy when it comes to latency.

0

The limit is high enough to give no problem on the earth. (Jupiter might be a problem, or earth to moon.) I have used 200ms latency in master-replica setups. Tokyo to London is faster than that.

(Please switch from the term "Slave" to "Replica".)

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.