Top Architect

Dec 3, 2025 · Backend Development

How to Add a Column to a Billion‑Row Order Table Without Breaking Production

When a new business field is required on a core order table with tens of millions of rows, the article walks through the risks of direct ALTER TABLE, evaluates master‑slave switching, online DDL tools, extension tables, JSON‑based schema‑less designs, and a clever reuse of an existing redundant column, providing practical steps and performance insights.