Showing entries 1 to 1
Displaying posts with tag: writeset (reset)
Group Commit and Transaction Dependency Tracking

MySQL 8.0 and newer change and improve how we measure and monitor replication lag. Even though multi-threaded replication (MTR) has been on by default for the last three years (since v8.0.27 released October 2021), the industry has been steeped in single-threaded replication for nearly 30 years. As a result, replication lag with MTR is a complicated topic because it depends on version, configuration, and more. This three-part series provides a detailed understanding, starting from what was originally an unrelated feature but is now the basis: binary log group commit.

Showing entries 1 to 1