How to Seamlessly Migrate a Live System to Sharding with Dual‑Write and Diff

This article explains how Qunar’s ticket ancillary service upgraded from a single-database architecture to a sharded one without downtime, detailing dual-write, transaction handling, mapping-key routing, diff verification, the challenges encountered, and a component-based solution that makes future migrations reusable.

distributed-transactiondual-writemapping key

0 likes · 35 min read

How to Seamlessly Migrate a Live System to Sharding with Dual‑Write and Diff

ITPUB

Jun 23, 2023 · Databases

Seamless Sharding Migration: Dual‑Write, Mapping Keys, and Diff Validation

This article explains how to smoothly migrate a legacy single‑database system to a sharded architecture by using dual‑write, mapping‑key routing, custom transaction handling, and offline/real‑time diff checks, while detailing the underlying MyBatis integration and component‑based design.

MyBatisdatabase partitioningdiff-validation

0 likes · 36 min read

Seamless Sharding Migration: Dual‑Write, Mapping Keys, and Diff Validation