MySQL Forums
Forum List  »  Replication

rotating binlogs, compression?
Posted by: Hristo Chernev
Date: November 04, 2004 06:49AM

I am using replication with Mysql, and I have two questions:

Q1:
On a heavy loaded web server when I rotate binlogs and delete old ones there is a time when it seems mysql is stopping for a moment and apache processes are hanging waiting for connection with the mysql server. In result in a sudden web server load became very high and it takes time to restore its normal work. Sometimes it couldn’t do it and stucks.
Is there any solution/workaround for this?


Q2:
Replication is doing a lot of traffic. Is there an option for compressing communication between master and slave or are there plans for implementing such feature?

Options: ReplyQuote


Subject
Views
Written By
Posted
rotating binlogs, compression?
5829
November 04, 2004 06:49AM
3105
November 08, 2004 10:16AM
3171
December 14, 2004 02:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.