Historically, the MySQL binary log has gone through a few revisions resulting in different versions of how the log is formatted. The following shows the version of the binary log and the MySQL version in which it appears. As you can see, version 4 is the current version of the binary log found in the current releases of MySQL.…
All posts by Libing.Song
More Metadata Is Written Into Binary Log
In row based replication, the row data generated by DML is logged into binary log with some metadata. For example column type, type length etc. In the new release MySQL-8.0.1, more table metadata are written into binary log. All metadata together brings users and us below benefits:
- Allows us to build robuster replication and convert row data between types smoothly.
Preserve Master’s Commit Order on Slave
On MySQL-5.7.2, we released a new type of multi-threaded slave (MTS). It is called logical clock based MTS. Because it can parallel apply transactions in the same schema, it has the potential to improve slave throughput on almost any application, regardless of the schema layout.
…Transaction Retry Is Available On Multi-Threaded Slave
I am happy to announce that slave_transaction_retries is available on multi-threaded slave now. You will no longer see the warning that slave_transaction_retries is not supported by multi-threaded slave since MySQL-5.7.5.
Multi-threaded slave and single-threaded slave share the system variable slave_transaction_retries and they have similar transaction retry logic.…