Tagged articles

Database Lag

4 articles · Page 1 of 1
Lobster Programming
Lobster Programming
Aug 3, 2026 · Databases

How to Eliminate MySQL Master‑Slave Lag: Parallel Replication, Read‑Routing, and Redis Marking

To address MySQL master‑slave replication lag, the article explains enabling parallel replication (setting slave_parallel_workers), routing reads to the master for latency‑sensitive operations, and using a Redis short‑term marker to direct recent writes to the master, while outlining configuration steps and trade‑offs.

Database LagMySQLParallel Replication
0 likes · 6 min read
How to Eliminate MySQL Master‑Slave Lag: Parallel Replication, Read‑Routing, and Redis Marking
Su San Talks Tech
Su San Talks Tech
Jul 28, 2023 · Databases

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.

Database LagMySQLParallel Replication
0 likes · 14 min read
Master‑Slave Replication in MySQL: Binlog Mechanics, Parallel Replication & Lag Reduction
Xiaolei Talks DB
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
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 LagGTIDMySQL
0 likes · 31 min read
Fundamentals and Advanced Strategies of MySQL Master‑Slave Replication