BestHub
Sign in
Tagged articles

JSON column

2 articles · Page 1 of 1
Top Architect
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.

ALTER TABLEJSON columnOnline DDL
0 likes · 9 min read
How to Add a Column to a Billion‑Row Order Table Without Breaking Production
Programmer XiaoFu
Programmer XiaoFu
Sep 4, 2025 · Databases

How to Add a Column to a Ten‑Million‑Row MySQL Table Without Locking It

When a core MySQL order table reaches tens of millions of rows, adding a new column can lock the table and disrupt services, so the article walks through master‑slave switching, online DDL tools, log‑based workarounds, extension tables, JSON fields, and a final redundant‑field trick to achieve the change safely.

DDL lockJSON columnLarge Tables
0 likes · 7 min read
How to Add a Column to a Ten‑Million‑Row MySQL Table Without Locking It