Tagged articles
online migration
10 articles · Page 1 of 1
Adding a column to a tens‑of‑millions‑row MySQL table may look trivial, but the real difficulty lies in the metadata‑lock timing and online traffic impact, requiring careful DDL type selection, pre‑flight checks, and often an online migration tool such as gh‑ost to avoid business‑level outages.
Instant DDLMetadata LockMySQL
0 likes · 18 min read

This article details the migration of a popular social app's private‑message service from a saturated MySQL cluster to PolarDB, covering business challenges, evaluation of storage‑optimization, vertical and horizontal scaling, the chosen distributed database solution, step‑by‑step offline and online migration procedures, and the resulting performance and cost benefits.
Database MigrationDistributed DatabaseMySQL
0 likes · 12 min read

The article explains how to evolve a simple single‑instance database into a highly available, horizontally sharded system, detailing offline scaling, online dual‑write migration, and a smooth four‑node expansion process with configuration changes, data migration, and cleanup steps.
Configuration ManagementHigh AvailabilitySharding
0 likes · 6 min read

This article provides a comprehensive guide to gh-ost, the GitHub‑released online MySQL schema migration tool, covering its design principles, three migration modes, download and RPM installation, common command‑line options, interactive socket commands, and a step‑by‑step example of altering a column type while monitoring progress and performing a safe cut‑over.
Database ToolsLinuxMySQL
0 likes · 25 min read

This article explains how using the Storage Performance Development Kit (SPDK) optimizes virtualized I/O paths for cloud disks, covering its architecture, virtio vring basics, hot‑upgrade solutions, online migration techniques, and io_uring enhancements that together achieve up to 1.2 million IOPS with dramatically reduced latency.
SPDKcloud storagehot upgrade
0 likes · 14 min read

This article details the challenges of moving from SQL Server to MySQL, compares offline and online migration approaches, presents a complete toolbox—including ETL utilities, consistency checkers, CDC configuration, and rollback mechanisms—and shares practical lessons from a large‑scale production migration.
CDCDatabase MigrationETL
0 likes · 26 min read

This article details the background, design considerations, migration workflows, tooling choices, data consistency verification, rollback mechanisms, and practical experiences of moving a large‑scale production environment from Microsoft SQL Server to MySQL, covering both offline and online migration scenarios.
Data ConsistencyDatabase MigrationETL
0 likes · 13 min read

This article explains the principles and detailed three‑stage process—preparation, migration, and switch—of KVM‑based online virtual machine migration on UCloud’s platform, illustrating each step with diagrams and highlighting challenges, benefits, and current limitations of non‑shared storage migration.
KVMUCloudonline migration
0 likes · 10 min read


21CTOSep 15, 2015 · Databases
This article explains how to migrate live service data between systems without downtime, covering migration types, a four‑stage process, practical examples with MySQL and HBase, and key techniques for ensuring consistency and smooth cut‑over.
Data ConsistencyHBaseMySQL
0 likes · 11 min read

This article explains the four‑step online data migration process—including dual‑write, historical data transfer, read cut‑over, and cleanup—using a real‑world MySQL‑to‑HBase fan‑list case study, and provides practical tips for ensuring zero‑downtime and high data consistency.
HBaseMySQLdata migration
0 likes · 11 min read
