BestHub
Sign in
Tagged articles

Semi‑Sync

12 articles · Page 1 of 1
Cloud Architecture
Cloud Architecture
Apr 17, 2026 · Databases

From Crashing Databases to Zero Data Loss: MySQL Replication Evolution

The article examines common MySQL replication failures, explains why traditional position‑based replication is insufficient, and walks through a step‑by‑step evolution from file/position to GTID, asynchronous to semi‑synchronous, single‑threaded to parallel apply, culminating in a production‑grade architecture that achieves near‑zero data loss.

BackupGTIDHigh Availability
0 likes · 35 min read
From Crashing Databases to Zero Data Loss: MySQL Replication Evolution
Tech Freedom Circle
Tech Freedom Circle
Nov 15, 2025 · Databases

How to Prevent Order Loss in a 100k TPS Flash Sale When the Master DB Crashes – 5 Practical Solutions

The article dissects a high‑traffic flash‑sale interview question—how to guarantee zero order loss at 100,000 TPS when the master MySQL instance fails—by explaining the underlying performance‑consistency conflict, the three skills interviewers assess, and presenting five concrete, code‑driven solutions ranging from MySQL parameter tuning to semi‑sync replication, local message tables, group replication, and Redis‑Kafka traffic shaping.

Data ConsistencyFlash SaleGroup Replication
0 likes · 28 min read
How to Prevent Order Loss in a 100k TPS Flash Sale When the Master DB Crashes – 5 Practical Solutions
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Oct 8, 2025 · Databases

Master MySQL Replication: Async, Semi‑Sync, and Full‑Sync Architectures Explained

This article outlines MySQL’s three primary replication architectures—async, semi‑sync, and full‑sync—detailing their mechanisms, typical topologies, performance trade‑offs, and suitable scenarios such as read‑heavy web services, high‑availability setups, and strict consistency requirements like financial transactions.

AsynchronousDatabase ArchitectureMySQL
0 likes · 4 min read
Master MySQL Replication: Async, Semi‑Sync, and Full‑Sync Architectures Explained
Senior Tony
Senior Tony
Aug 4, 2025 · Databases

Understanding MySQL Master‑Slave Replication: Core Principles, Modes, and Latency Mitigation

This article provides a comprehensive overview of MySQL master‑slave replication, explaining its core mechanisms, the push‑pull hybrid model, replication modes (asynchronous, full‑sync, semi‑sync), binlog formats, and practical strategies to reduce replication lag caused by large transactions, server load, and network constraints.

AsynchronousMySQLSemi‑Sync
0 likes · 9 min read
Understanding MySQL Master‑Slave Replication: Core Principles, Modes, and Latency Mitigation
IT Xianyu
IT Xianyu
Apr 19, 2025 · Databases

Step-by-Step Guide to Setting Up MySQL 5.7 Master‑Slave Replication

This tutorial walks through preparing the Linux environment, installing MySQL 5.7, configuring master and slave servers, creating replication users, verifying synchronization, troubleshooting common issues, and applying advanced options such as GTID and semi‑synchronous replication, all with complete command examples.

ConfigurationGTIDLinux
0 likes · 10 min read
Step-by-Step Guide to Setting Up MySQL 5.7 Master‑Slave Replication
Architect
Architect
Aug 19, 2023 · Databases

Deep Dive into MySQL Replication: Mechanisms, Performance, and Real‑World Optimizations

This article thoroughly examines MySQL replication, detailing binlog formats, event types, replication workflows, semi‑synchronous and parallel replication techniques, performance benchmarks, and practical implementation steps such as fake‑slave registration and connection‑pool enhancements, while illustrating each concept with concrete examples and code snippets.

High AvailabilityMySQLParallel Replication
0 likes · 30 min read
Deep Dive into MySQL Replication: Mechanisms, Performance, and Real‑World Optimizations
ITPUB
ITPUB
Nov 6, 2022 · Databases

Why Can’t You Read Your Recent Write? Understanding Master‑Slave Lag and Fixes in MySQL

The article explains why a recent write may be invisible when reading from a MySQL replica, analyzes the replication threads and latency causes, and presents practical solutions such as forcing master reads, lag detection, semi‑sync mode, and GTID‑based waiting, with examples from Sharding‑JDBC, MyCat and MaxScale.

Database MiddlewareGTIDMySQL
0 likes · 10 min read
Why Can’t You Read Your Recent Write? Understanding Master‑Slave Lag and Fixes in MySQL
Java High-Performance Architecture
Java High-Performance Architecture
May 19, 2022 · Databases

Mastering MySQL Replication: From Basics to Advanced Configurations

This article explains MySQL replication fundamentals, binary log mechanics, master‑slave roles, configuration steps, and the various replication types—including asynchronous, semi‑synchronous, multi‑source, and delayed replication—while providing practical commands and code examples for reliable high‑availability setups.

Binary LogDelayed ReplicationMySQL
0 likes · 14 min read
Mastering MySQL Replication: From Basics to Advanced Configurations
ITPUB
ITPUB
Aug 19, 2021 · Databases

How to Turn a Single MySQL Server into a High‑Availability Cluster

This article explains why a single MySQL instance becomes insufficient as data volume and concurrency grow, and walks through master‑slave replication, asynchronous and semi‑synchronous modes, group replication, and various high‑availability solutions such as MHA, MySQL InnoDB Cluster, and Orchestrator, while also covering read/write splitting techniques and practical implementation tips.

Group ReplicationMySQLSemi‑Sync
0 likes · 20 min read
How to Turn a Single MySQL Server into a High‑Availability Cluster