Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

I have an online service with around 5000 MySQL databases. Now, I am interested in building a development area of the exactly same environment in my office, therefore, I am about to setup MySQL replication between my live MySQL server and development MySQL server.

But my concern is the load which will occur on my live MySQL server once replication is started. Do you have any experience? Will this process cause extra load on my production server?

Thanks, have a nice weekend.

share|improve this question
up vote 1 down vote accepted

Turning on binary logging (for replication) can severely affect performance. It calls fsync to ensure consistency, so everything is slower. A few articles to read:

share|improve this answer
Thanks for answering. I decided not to go with replication :( – Willy Mar 6 '11 at 10:51

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.