Tagged articles
extension table
10 articles · Page 1 of 1
Adding a new column to a core MySQL order table with tens of millions of rows can lock the table and disrupt services, so this article explores safe alternatives such as master‑slave switching, online schema change tools, extension tables, JSON fields, and clever reuse of existing redundant columns.
JSON fieldMySQLextension table
0 likes · 8 min read

When a core order table with tens of millions of rows needs a new business field, the article explores why a direct ALTER TABLE can lock the table, evaluates master‑slave switching, online DDL tools, extension tables, JSON fields, and a clever reuse of an existing redundant column, providing practical steps and performance insights.
DDLJSON fieldMySQL
0 likes · 9 min read

When a core order table with tens of millions of rows needs a new business field, executing a plain ALTER TABLE can lock the table and disrupt services, so the article explores master‑slave switching, online schema‑change tools, extension tables, JSON fields, and a clever reuse of an existing redundant column to achieve the change with minimal risk.
DDLJSONMaster‑Slave
0 likes · 9 min read

When a core order table with tens of millions of rows needs a new column, naïve ALTER TABLE can lock the table and disrupt services, so this article explores safe alternatives such as master‑slave switching, online DDL tools, extension tables, JSON‑based schema‑less designs, and clever reuse of existing redundant fields, complete with practical code snippets and lessons learned.
DDLJSONMySQL
0 likes · 9 min read

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 TABLEDatabase MigrationJSON column
0 likes · 9 min read

Adding a new field to a core order table with tens of millions of rows can lock the table and disrupt services, so this article explores various strategies—including master‑slave switching, online DDL tools, extension tables, JSON fields, and repurposing redundant columns—to achieve schema changes safely and efficiently.
Database MigrationJSON fieldMySQL
0 likes · 8 min read

When a core order table with tens of millions of rows needs a new business field, directly running ALTER TABLE can lock the table and disrupt services, so this article explores master‑slave switching, online DDL tools, extension tables, JSON fields, and clever reuse of existing redundant columns to achieve the change safely and efficiently.
JSON fieldLarge TablesMySQL
0 likes · 9 min read

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

To avoid lock, page split, and index degradation when adding fields to billion‑row core tables, this article presents a practical solution that uses dynamic field extension via configurable management, JSON‑based extension fields, and an extension‑table architecture integrated with Elasticsearch for storage and retrieval.
ElasticsearchMySQLdatabases
0 likes · 10 min read

This article examines the difficulties of adding new fields to a core billion‑row MySQL table—including locking, page splitting, and index degradation—and presents a configuration‑driven, three‑layer architecture that uses JSON extension fields, extension tables, and Elasticsearch to achieve safe, scalable dynamic schema evolution.
Database DesignDynamic SchemaJSON field
0 likes · 8 min read
