Aikesheng Open Source Community

Jan 4, 2021 · Databases

Investigation of Deadlock Issues in MySQL Replication with Delayed Slave and Parallel Apply

This article analyzes a MySQL master‑slave setup where a delayed replica experiences growing replication lag due to deadlocks caused by REPLACE INTO statements, examines the lock behavior, reproduces the issue in a test environment, and proposes configuration and coding mitigations.