Adsar Logo


MySQL - binlog compression



If you're running MySQL slaves - especially if they're part of different networks - then you can end up with a large proportion of your available bandwidth being clogged up with binlog replication.

To help, you can turn on binlog compression on the Master. We saw about a 90% reduction in bandwidth utilisation after we had turned this on.

binlog-transaction-compression = 1


Trees for life


Want to get in touch? mail@adsar.co.uk