[MDEV-11065] Compressed binary log Created: 2016-10-15 Updated: 2017-01-22 Resolved: 2016-11-03 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Fix Version/s: | 10.2.3 |
| Type: | Task | Priority: | Major |
| Reporter: | Sergey Vojtovich | Assignee: | Kristian Nielsen |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | contribution, foundation | ||
| Description |
|
We add new event types to support compress the binlog as follow: Of course, in mariadb 10.2, it's always the V1 version of compressed binlog row event. We introduce two option for this feature: "log_bin_compress " and "log_bin_compress_min_len", the if binlog_format == row { if log_bin_compress == true and record_len >= log_bin_compress_min_len create a Write_rows_compressed_log_event(when INSERT) else create a Write_log_event(when INSERT); }And in slave, the compressed binlog events would be converted to the uncompressed form in IO thread, such as QUERY_COMPRESSED_EVENT convert to QUERY_EVENT. Now, we use zlib as compressed algrithm. The feture can reduce 42% ~ 70% binlog capacity in our production environment. |
| Comments |
| Comment by Kristian Nielsen [ 2016-11-03 ] |
|
Thanks! |
| Comment by Elena Stepanova [ 2016-11-05 ] |
|
Apparently the link to the pull request is wrong, should be GitHub Pull Request #247 |