Writeset‑Based Replication in MySQL: Background, Principles, Source‑Code Analysis, Testing, and Summary

This article explains how MySQL’s logical‑clock replication can be enhanced with writeset‑based dependency tracking, detailing the underlying theory, code implementation, configuration options, performance testing, and practical considerations for improving parallel applier concurrency.

BinlogReplicationTransaction Dependency

0 likes · 12 min read

Writeset‑Based Replication in MySQL: Background, Principles, Source‑Code Analysis, Testing, and Summary

Aikesheng Open Source Community

Sep 2, 2019 · Databases

Understanding MySQL Write‑Set Based Parallel Replication and Last‑Commit Handling

This article explains MySQL's write‑set based parallel replication, detailing how writeset hashes are generated, stored in a historical map, and used to adjust the last‑commit value for improved parallel replay, including configuration parameters, code examples, and the impact of different dependency‑tracking modes.

BinlogDatabase InternalsTransaction Dependency

0 likes · 15 min read

Understanding MySQL Write‑Set Based Parallel Replication and Last‑Commit Handling