Re: what version is slave_compressed_protocol supported?

[Duncan Berriman]

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.