MySQL Forums
Forum List  »  Replication

Re: what version is slave_compressed_protocol supported?
Posted by: Duncan Berriman
Date: May 19, 2005 06:20PM

For anyone thinking of turning slave_compressed_protocol on I'd be very careful and test it first.

I set this (slave_compressed_protocol=1) on a working slave and then it started causing about 600 tcp connections per minute and logging hundreds of errors like these.

050519 23:20:34 Slave: connected to master 'xxx@yyy:3306',replication resumed in log 'xxx.yyy' at position nnn
050519 23:20:34 Slave: received 0 length packet from server, apparent master shutdown:
050519 23:20:34 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'xxx.yyy' position nnn

Stoping the slave, mysql and setting removing slave_compressed_protocol from my.cnf did not solve the problem.

In the end I remastered the slave (from another slave which had just done a backup) and all appears well again.

I only noticed the problem due to my MRTG stats going through the roof for TCP connections. Fortunately I quite quickly worked out what it was based on the date and time I added this feature.

Options: ReplyQuote

Written By
Re: what version is slave_compressed_protocol supported?
May 19, 2005 06:20PM

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.