[Maria-discuss] slave_compressed_protocol = 1 has no effect
Hi there, I've been trying to make use of the compressed replication protocol between two existing MariaDB 10.1.21 boxes. Replication itself has been working fine for a while. I do: SET GLOBAL slave_compressed_protocol = 1; On both master and slave. Then stop/start slave. However, when I monitor the network usage, I see no reduction in network traffic. However, I tried compression via an ssh tunnel and saw a big reduction (ssh doing the compression, not MariaDB). So the traffic is definitely compressible. I tried setting the param via my.cnf and also restarting both master and slave to see if that would make a difference - no luck. Have confirmed the global variable shows 'ON' after the change, and was 'OFF' before. Is there potentially an issue with this working with the MariaDB supplied binary tarball (e.g. some compression lib dependency?) I see nothing in error.log to show an issue. Any other useful ways to debug this? Thanks! Phil
Hi Phil, On 8 March 2017 at 11:12, Phil Sweeney <launchpad@sweeneymail.com> wrote:
[...] SET GLOBAL slave_compressed_protocol = 1;
On both master and slave. Then stop/start slave.
However, when I monitor the network usage, I see no reduction in network traffic. However, I tried compression via an ssh tunnel and saw a big reduction (ssh doing the compression, not MariaDB). So the traffic is definitely compressible. [...]
I am not an expert in MariaDB Server and ssh compression but maybe the algorithm used by ssh is different than the one used by MariaDB Server, which would explain what you observe. So your replication workload would not "play" well with replication compression. I would suggest setting up a test environment and try things that you would expect compress well (a big LOAD DATA with a lot of repeated data, or an multi-INSERT with a lot of repeated data). If you still see compression not working well, it might be a bug and you should open a JIRA on that (with all the details of your test). Best regards, Jean-François Gagné
participants (2)
-
Jean-Francois B. Gagne -
Phil Sweeney