BestHub
Sign in
Tagged articles
11 articles
Page 1 of 1
Tech Freedom Circle
Tech Freedom Circle
Nov 28, 2025 · Databases

How to Achieve MySQL Sub‑Second Scaling for 100M‑10B Rows (Interview Scenario)

The article analyzes a JD interview question on scaling a MySQL order table from 100 million to billions of rows, detailing four practical expansion strategies—stop‑service migration, double‑write migration, ShardingSphere middleware, and dual‑VIP routing—each with step‑by‑step procedures, code samples, risk assessments, and validation methods to enable near‑instant capacity growth without service interruption.

ShardingSpheredatabase scalingdouble write
0 likes · 42 min read
How to Achieve MySQL Sub‑Second Scaling for 100M‑10B Rows (Interview Scenario)
Senior Tony
Senior Tony
Dec 30, 2024 · Databases

Unlocking MySQL InnoDB: Deep Dive into ACID, Redo/Undo Logs, and Double Write

This article explains MySQL InnoDB's ACID properties in depth, detailing how atomicity relies on Redo and Undo logs, how consistency ensures business logic integrity, how isolation uses locks and MVCC with snapshot and current reads, and how durability is achieved through Redo logs, the innodb_flush_log_at_trx_commit setting, and the Double Write mechanism.

ACIDInnoDBIsolation
0 likes · 11 min read
Unlocking MySQL InnoDB: Deep Dive into ACID, Redo/Undo Logs, and Double Write
Sohu Tech Products
Sohu Tech Products
Aug 28, 2024 · Databases

MySQL Data Migration with Double‑Write Using MyBatis Plugin

The article details how the vivo Game Center’s appointment service migrated billions of rows to a dedicated MySQL database with zero‑downtime by implementing a double‑write strategy via a custom MyBatis interceptor that mirrors updates and queries to the new database, handling full and incremental sync, primary‑key consistency, transaction limits, and final cut‑over steps.

Data MigrationMyBatisdatabase
0 likes · 19 min read
MySQL Data Migration with Double‑Write Using MyBatis Plugin
High Availability Architecture
High Availability Architecture
Aug 27, 2024 · Backend Development

Design and Implementation of a Double‑Write Migration Strategy for the Appointment Service Using a MyBatis Plugin

This article details the background, requirements, and evaluation of migration options for the appointment service, explains why a double‑write approach with a custom MyBatis plugin was chosen, and walks through the full‑sync, incremental sync, code refactoring, plugin implementation, switch‑over procedures, and post‑migration validation to achieve reliable data isolation and system stability.

JavaMyBatisdata synchronization
0 likes · 17 min read
Design and Implementation of a Double‑Write Migration Strategy for the Appointment Service Using a MyBatis Plugin
vivo Internet Technology
vivo Internet Technology
Aug 21, 2024 · Databases

MySQL Data Migration with Double‑Write Strategy Using a MyBatis Plugin

The article details a zero‑downtime migration of a high‑traffic reservation service from a shared MySQL instance to an isolated database by employing a double‑write strategy implemented through a custom MyBatis plugin, covering full and incremental sync, consistency verification, traffic shifting, and key lessons on primary‑key handling and asynchronous write side‑effects.

Data MigrationMyBatisSynchronization
0 likes · 19 min read
MySQL Data Migration with Double‑Write Strategy Using a MyBatis Plugin
Top Architect
Top Architect
Jan 24, 2022 · Backend Development

Ensuring Data Consistency Between Cache and Database in Double‑Write Scenarios

The article analyzes the challenges of maintaining data consistency when using both cache (local memory or Redis) and a database, classifies data by real‑time requirements, evaluates four double‑write strategies, and proposes practical solutions such as delayed double deletion, message‑queue compensation, and binlog‑driven cache updates.

BackendCachedata synchronization
0 likes · 8 min read
Ensuring Data Consistency Between Cache and Database in Double‑Write Scenarios
Java Backend Technology
Java Backend Technology
Jan 24, 2022 · Backend Development

How to Solve Double‑Write Consistency Issues with Message Queues

This article examines the pitfalls of writing to multiple data stores simultaneously—such as consistency and atomicity problems—and proposes a generic solution using change data capture and message queues to keep databases, Redis, Elasticsearch, and Hadoop synchronized.

Consistencydata synchronizationdouble write
0 likes · 7 min read
How to Solve Double‑Write Consistency Issues with Message Queues
New Oriental Technology
New Oriental Technology
Jun 28, 2021 · Databases

InnoDB Architecture and Key Features: A Comprehensive Overview

This article provides a comprehensive overview of InnoDB architecture, covering its memory structures, background threads, and key features like checkpoint mechanisms, double write, and neighbor page flushing, essential for understanding MySQL's default storage engine.

Background ThreadsCheckpoint MechanismDatabase Architecture
0 likes · 12 min read
InnoDB Architecture and Key Features: A Comprehensive Overview
Java Backend Technology
Java Backend Technology
Nov 5, 2020 · Backend Development

How to Eliminate Double‑Write Consistency Problems with Message Queues and CDC

This article explores common data‑synchronization challenges such as double‑write consistency and atomicity issues across databases, Redis, Elasticsearch and Hadoop, and presents a generic solution using ordered message queues and change‑data‑capture middleware to ensure reliable, consistent updates.

Backend DevelopmentChange Data CaptureConsistency
0 likes · 8 min read
How to Eliminate Double‑Write Consistency Problems with Message Queues and CDC
dbaplus Community
dbaplus Community
Apr 12, 2017 · Databases

Why InnoDB Double Write Matters: MySQL vs Oracle Recovery Mechanisms

This article explains InnoDB’s double‑write buffer in MySQL, compares its design and recovery handling with Oracle’s redo and control‑file mechanisms, discusses partial‑write issues, checkpoint strategies, performance impacts on SSDs, and provides practical commands and configuration tips for DBAs.

CheckpointInnoDBOracle
0 likes · 21 min read
Why InnoDB Double Write Matters: MySQL vs Oracle Recovery Mechanisms