Enabling slave_compressed_protocol on MariaDB with Replication on GCP

sushantpuri 2020-05-21 21:31:25 UTC #1

Keywords: MariaDB - Google Cloud Platform - Technical issue - Other
Description:
There is latency between our Master and slave MariaDB setup.

The core problem that we are facing is of sql threads and i/o threads

Can someone please help in letting us know if slave_compressed_protocol is enabled by default in MariaDB with Replication on GCP ?

If not how do we enable that plus how do we make sure that the replication between master and slave happens as quickly as possible, we know it cannot be instantaneous but still we need to figure out a way to make it more seamless.

amoreno 2020-05-22 14:10:46 UTC #2

Hi, @sushantpuri.

The slave_compressed_protocol option is not enabled by default in our MariaDB with Replication stack. According to the official documentation (https://mariadb.com/docs/reference/es/system-variables/slave_compressed_protocol/), you can enable it in your my.cnf file (don't forget to restart the server after enabling it).

In order to optimize the replication, I recommend you to ask in the official MariaDB community (https://mariadb.com/kb/en/community/), since they will be able to provide you with a better answer than us. Note that we only package already existing applications and, as such, we can only answer questions related to our default configurations or other basic subjects.

Regards,
Alejandro

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!