Comments - Compressing Events to Reduce Size of the Binary Log

3 years, 7 months ago Valor Poland

Word to the wise: At very high volumes, binlog replay performance can be negatively affected when compression is turned on.

The scenario is most obvious with row-based logging, table space encryption, and annotations turned on.

In comparing MIXED replication with annotations + compression, you will get the best performance with compression OFF and annotations OFF.

Unless disk space and network links are limited, would suggest leaving compression off. For reference, our peak volumes are around 300k Insert/Update/Deletes per minute.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.