Tagged articles

Backfill

2 articles · Page 1 of 1
Cloud Architecture
Cloud Architecture
Apr 7, 2026 · Databases

Practical Guide to Safely Adding a Column to a Ten‑Million‑Row Order Table: Principles, Architecture, and Production Rollout

This article presents a production‑grade solution for adding a new promotion_type column to a tens‑of‑millions‑row order table, covering MySQL DDL risks, multiple migration strategies, a step‑by‑step implementation using a new table, CDC‑based incremental sync, back‑fill, verification, gray rollout, and rollback procedures.

BackfillCDCGray Deployment
0 likes · 38 min read
Practical Guide to Safely Adding a Column to a Ten‑Million‑Row Order Table: Principles, Architecture, and Production Rollout