This is a quick one. My attention was recently brought (thanks Simon) on a relatively recent comment (25 Nov 2025) in Bug #103672 - Binlog compression transaction payload event exceeds max allowed packet :
The underlying server bug was fixed in 8.0.34 in BUG#33588473. The server now falls back to writing the transaction without compression, if the compressed size would
Binary Log Compression is Safe since MySQL 8.0.34 appeared first on MariaDB.org
This is a quick one. My attention was recently brought (thanks Simon) on a relatively recent comment (25 Nov 2025) in Bug #103672 - Binlog compression transaction payload event exceeds max allowed packet :
The underlying server bug was fixed in 8.0.34 in BUG#33588473. The server now falls back to writing the transaction without compression, if the compressed size would exceed 1 GiB.
So Binary Log Transaction Compression is safe since MySQL 8.0.34. But this also means that it is unsafe before, as also clearly mentioned in Bug #103672 :
It is true that an 8.0.33 server (or older) will produce a corrupted binary log and that replicas may have to recover from backup. It would be better to document this clearly and to advise to not use compression on 8.0.33 and older.
However, even if updating the documentation is mentioned in the above quote, my quick check did not find any reference to the risk of using binlog compression before 8.0.34 (including in the documentation of the global variable binlog_transaction_compression). I thought this deserved wider knowledge, hence this post.
| # | Наименование новости | Тональность | Информативность | Дата публикации |
|---|---|---|---|---|
| 1 | Interesting Binary Logging Optimization in MariaDB | 0 | 4.87 | 26-05-2025 |
| 2 | Notes on Compression in the MySQL Protocol | 0 | 3.87 | 06-11-2023 |
| 3 | MySQL Binlogs:: How to recover | 0 | 5.9 | 13-07-2019 |
| 4 | MySQL 8.0.17 GTID Crash Safety Improvement | 0 | 9.21 | 04-08-2026 |
| 5 | Symlinks are Unsafe since MySQL 8.0.39 (and maybe even before) | 0 | 8.23 | 14-04-2026 |
| 6 | Group Commit and Transaction Dependency Tracking | 0 | 12.03 | 21-10-2024 |
| 7 | Do not uselessly grant CREATE and ALTER TABLE | 0 | 9.11 | 20-06-2026 |
| 8 | Still on MySQL 5.7 or 8.0? Those high-severity CVE fixes are covered | 0 | 12.23 | 02-07-2026 |
| 9 | More than Flushing (also Caching) for innodb_flush_method, and Missing Release Candidate | 0 | 5.4 | 25-02-2026 |
| 10 | InnoDB Redo Log Sizing: Stop Guessing, Start Measuring | 0 | 5.82 | 02-05-2026 |