Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does having a master-slave mysql setup over long distances (50-60 ms) slow down the responsiveness of INSERTs or SELECTs on the master locally?

share|improve this question
up vote 3 down vote accepted


The reads and writes act on the local database. The writes (or any flavor of modification) are written to the binary log, which is read by the slave. So, any activity directly on the master should not be affected by the amount of time it takes for the data to get to the slave.

I currently run a MySQL replication "ring" between central Florida and the Chicago suburbs; each MySQL instance is a master to one instance, and a slave to another, so that all instances are live and contain the data from all the others. The only problem I've seen is that replication lag can cause one of my instances to be "out of date" temporarily because my application is actually faster than the lag.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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