MySQL Change Stream Applier (CSA): How MySQL 26.7 Fixes Replication Lag
Replication lag often stems from worker thread lock-in under heavy writes. MySQL 26.7 introduces the Change Stream Applier (CSA) with APPLIER_VERSION = 2, decoupling transaction execution phases and moving to an asynchronous worker-pool model. Here is a practical look at how CSA works, benchmark data comparing it against MTA, and steps to configure it.