BestHub
Sign in
Tagged articles
11 articles
Page 1 of 1
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 ConsistencyGroup ReplicationKafka
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 ArchitectureFull Sync
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.

AsynchronousBinlogReplication
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.

BinlogPerformance OptimizationReplication
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 MiddlewareGTIDMaster‑Slave
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.

Delayed ReplicationReplicationSemi‑Sync
0 likes · 14 min read
Mastering MySQL Replication: From Basics to Advanced Configurations
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 28, 2022 · Databases

Testing Safe vs. Forceful MySQL Shutdown in a Semi‑Synchronous Replication Setup

This article presents a detailed experiment comparing graceful and kill‑9 shutdown methods on a MySQL 5.7 semi‑synchronous master‑slave cluster, analyzes their impact on data consistency, and outlines the official shutdown sequence with practical observations and recommendations for production environments.

ReplicationSemi‑SyncShutdown
0 likes · 12 min read
Testing Safe vs. Forceful MySQL Shutdown in a Semi‑Synchronous Replication Setup
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 ReplicationMaster‑SlaveReplication
0 likes · 20 min read
How to Turn a Single MySQL Server into a High‑Availability Cluster