Master‑Slave Replication in MySQL: Binlog Mechanics, Parallel Replication & Lag Reduction

This article explains why a single MySQL instance is insufficient for production, introduces binlog concepts and formats, details the master‑slave replication threads and workflow, explores parallel replication mechanisms, analyzes causes of replication lag, and provides practical strategies to minimize that delay.

BinlogDatabase LagMaster‑Slave

0 likes · 14 min read

Master‑Slave Replication in MySQL: Binlog Mechanics, Parallel Replication & Lag Reduction

Xiaolei Talks DB

Apr 7, 2022 · Databases

Why Did One Aerospike Node’s XDR Lag So High? Diagnosis and Fix

A single Aerospike node experienced extreme XDR replication lag due to a misconfigured forward setting, and the article walks through terminology, monitoring data, root‑cause analysis, and step‑by‑step commands to resolve the issue and improve cluster performance.

AerospikeDatabase LagNoSQL

0 likes · 11 min read

Why Did One Aerospike Node’s XDR Lag So High? Diagnosis and Fix

Selected Java Interview Questions

Jul 15, 2021 · Databases

Fundamentals and Advanced Strategies of MySQL Master‑Slave Replication

This article explains the basic principles of MySQL master‑slave architecture, the role of read‑only replicas, loop‑replication problems, master‑slave delay measurement, various failover strategies, parallel replication mechanisms across MySQL versions and MariaDB, GTID usage, and read‑write splitting techniques, providing practical commands and diagrams for each concept.

Database LagGTIDMaster‑Slave

0 likes · 31 min read

Fundamentals and Advanced Strategies of MySQL Master‑Slave Replication