1

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.

Improve this question

1 Answer 1

Reset to default
1

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/
Improve this answer
1
  • Thanks for answering. I decided not to go with replication :(
    – Willy
    Mar 6, 2011 at 10:51

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .