Row-Based Replication — 2 Technical Articles

Feb 26, 2026 · Databases

Essential MySQL Replication Best Practices to Keep Your Replicas Stable

This guide presents practical, DBA‑tested MySQL replication best practices—including GTID, row‑based replication, mandatory primary keys, schema consistency, binlog tuning, read‑only protection, dedicated replication users, latency monitoring, parallel workers, and SSL encryption—to ensure reliable, predictable replica behavior.

Database AdministrationGTIDMySQL

0 likes · 9 min read

Essential MySQL Replication Best Practices to Keep Your Replicas Stable

Aikesheng Open Source Community

Aug 9, 2022 · Databases

Understanding and Testing sql_slave_skip_counter in MySQL Replication

This article explains the risks of misusing the sql_slave_skip_counter parameter in MySQL replication, demonstrates a step‑by‑step test environment with both transactional and non‑transactional tables, analyzes the resulting binlog events, and provides practical methods to reset the counter safely.

GTIDMySQLRow-Based Replication

0 likes · 13 min read

Understanding and Testing sql_slave_skip_counter in MySQL Replication