Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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:

  1. http://jcole.us/blog/archives/2006/05/25/on-disk-performance-and-mysql-replication/
  2. http://www.mysqlperformanceblog.com/2006/05/27/jeremy-cole-on-mysql-replication/
share|improve this answer
    
Thanks for answering. I decided not to go with replication :( –  Willy Mar 6 '11 at 10:51

Your Answer

 
discard

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.