Semi‑Synchronous

Practical DevOps Architecture

Jun 4, 2024 · Databases

Causes and Solutions for MySQL Master‑Slave Replication Lag

This article explains why MySQL master‑slave replication can become delayed—including single‑threaded binlog processing, high load, network latency, and configuration issues—and provides detailed troubleshooting steps and practical solutions such as semi‑synchronous replication, hardware upgrades, and configuration tuning.

Database ArchitectureMySQLPerformance Tuning

0 likes · 8 min read

Causes and Solutions for MySQL Master‑Slave Replication Lag

Mike Chen's Internet Architecture

Mar 1, 2024 · Databases

MySQL Master‑Slave Replication: Modes, Principles, and Implementation

This article explains MySQL master‑slave replication, covering its three modes (asynchronous, semi‑synchronous, and fully synchronous), the underlying binary‑log mechanism, key replication threads, configuration steps, and includes a promotional notice for an upcoming live career‑development session.

MySQLReplicationSemi‑Synchronous

0 likes · 6 min read

MySQL Master‑Slave Replication: Modes, Principles, and Implementation

vivo Internet Technology

Apr 5, 2023 · Databases

Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications

MySQL replication copies data changes from a primary server to one or more replicas using binlog events—supporting statement, row, or mixed formats and GTID positioning—to provide real‑time backup, read‑write separation, high‑availability failover, and integration pipelines via asynchronous, semi‑synchronous, or centralized binlog services.

Data ReliabilityGTIDHigh Availability

0 likes · 30 min read

Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications

Selected Java Interview Questions

Apr 13, 2021 · Databases

MySQL Master‑Slave Replication: Types, Use Cases, Principles, and Solutions

This article explains MySQL master‑slave replication, covering replication modes, use cases, required configurations, underlying mechanisms, common issues, and solutions such as semi‑synchronous and parallel replication, along with practical configuration examples and monitoring commands.

Database AdministrationMaster‑SlaveMySQL

0 likes · 7 min read

MySQL Master‑Slave Replication: Types, Use Cases, Principles, and Solutions