BestHub
Sign in
Tagged articles

schema migration

18 articles · Page 1 of 1
Su San Talks Tech
Su San Talks Tech
Aug 13, 2026 · Databases

How to Safely Add a Column to a Tens‑Million‑Row MySQL Table? 6 Proven Methods

Adding a column to a MySQL table with tens of millions of rows can lock the table for minutes or even hours, disrupting services, so this article evaluates six practical approaches—including native online DDL, offline maintenance, PT‑OSC, logical migration with dual‑write, gh‑ost, and partition sliding‑window—detailing their mechanisms, trade‑offs, and suitable scenarios.

MySQLOnline DDLdatabase operations
0 likes · 13 min read
How to Safely Add a Column to a Tens‑Million‑Row MySQL Table? 6 Proven Methods
Shuge Unlimited
Shuge Unlimited
Apr 30, 2026 · Databases

Milvus VTS Deep Dive: Two Write Modes, Sharding, and Migration Best Practices

The article provides a source‑code level analysis of Milvus Vector Transport Service (VTS), detailing its three‑stage architecture, partition‑aware sharding logic, two distinct sink write mechanisms (BufferBatchWriter and BulkWriter), schema conversion rules, error‑handling strategies, performance tuning parameters, and practical configuration examples for efficient vector data migration across various data sources.

BufferBatchWriterBulkWriterMilvus
0 likes · 20 min read
Milvus VTS Deep Dive: Two Write Modes, Sharding, and Migration Best Practices
Cloud Architecture
Cloud Architecture
Apr 25, 2026 · Databases

How a Phone Number Field Can Crash a 2B‑User Database – Architect’s Design Guide

A mis‑designed phone number column can silently degrade index performance, overload CPU, and cause a cascade of timeouts in a 2‑billion‑user system, but by treating the phone as a domain value object, using a normalized VARCHAR, aligning indexing rules, and applying consistent sharding and migration strategies, you can prevent the database from collapsing under high concurrency.

High ConcurrencyMySQLValue Object
0 likes · 31 min read
How a Phone Number Field Can Crash a 2B‑User Database – Architect’s Design Guide
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
Programmer XiaoFu
Programmer XiaoFu
Jan 21, 2026 · Databases

How to Add a Column to a Tens‑Million‑Row Order Table Without Locking It

When a tens‑million‑row order table needs a new business column, directly running ALTER TABLE can lock the table and disrupt services, so the article explores master‑slave promotion, online DDL tools, schema‑less JSON extensions, and a clever use of an existing redundant column to achieve the change safely.

DDLJSONMySQL
0 likes · 7 min read
How to Add a Column to a Tens‑Million‑Row Order Table Without Locking It
ITPUB
ITPUB
Jan 11, 2026 · Databases

6 Proven Strategies to Add Columns to Billion‑Row MySQL Tables Without Downtime

This article examines why adding a column to a MySQL table with tens of millions of rows can lock the table, then presents six practical solutions—including native online DDL, PT‑OSC, gh‑ost, dual‑write migration, maintenance downtime, and partition sliding‑window—detailing their procedures, trade‑offs, and suitable scenarios.

MySQLOnline DDLdatabase operations
0 likes · 12 min read
6 Proven Strategies to Add Columns to Billion‑Row MySQL Tables Without Downtime
Top Architect
Top Architect
Dec 15, 2025 · Databases

How to Add a Column to a Billion‑Row Order Table Without Downtime

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.

DDLDatabase ScalingJSON
0 likes · 9 min read
How to Add a Column to a Billion‑Row Order Table Without Downtime
dbaplus Community
dbaplus Community
Nov 17, 2025 · Databases

6 Proven Strategies to Safely Add Columns to Massive MySQL Tables

When adding a column to a MySQL table with tens of millions of rows, lock contention can cripple services, so this guide compares six practical solutions—including native online DDL, PT‑OSC, gh‑ost, partition sliding windows, downtime maintenance, and dual‑write migration—detailing their mechanisms, trade‑offs, use‑cases, and step‑by‑step commands to ensure minimal disruption.

MySQLOnline DDLdatabase operations
0 likes · 12 min read
6 Proven Strategies to Safely Add Columns to Massive MySQL Tables
Architect's Tech Stack
Architect's Tech Stack
Sep 22, 2025 · Databases

How to Safely Add a Column to a Billion-Row Order Table Without Downtime

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 fieldMySQLOnline DDL
0 likes · 9 min read
How to Safely Add a Column to a Billion-Row Order Table Without Downtime
Java Tech Enthusiast
Java Tech Enthusiast
Aug 26, 2025 · Databases

6 Proven Strategies to Safely Add Columns to Billion‑Row MySQL Tables

This article explores why adding columns to massive MySQL tables can lock the database, explains the risks, and presents six practical solutions—including native online DDL, downtime maintenance, PT‑OSC, logical migration with dual writes, gh‑ost, and partition sliding windows—along with best‑practice tips for monitoring, backup, and performance.

MySQLOnline DDLgh-ost
0 likes · 11 min read
6 Proven Strategies to Safely Add Columns to Billion‑Row MySQL Tables
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 3, 2025 · Databases

Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix

The article details a MySQL 5.7 bug where rollback SQL generated for a JSON NOT NULL column produces an empty string instead of NULL, explains the underlying binlog behavior, reproduces the issue with sample tables, and provides a practical workaround by converting the JSON column to TEXT before re‑importing the data, while recommending strict SQL_MODE for production.

Database TroubleshootingJSONMySQL
0 likes · 7 min read
Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix
DevOps Cloud Academy
DevOps Cloud Academy
May 29, 2023 · Databases

Best Database Schema Migration Tools: CLI, GUI, and GitOps/Database-as-Code Solutions

Database schema changes are among the riskiest development tasks, and this article reviews top migration tools—from basic CLI clients like mysql and psql, through popular GUIs such as phpMyAdmin and DBeaver, to modern GitOps/Database-as-Code solutions like Liquibase, Flyway, Sqitch, Atlas, Prisma, and Bytebase—highlighting their features, pricing, and collaboration capabilities.

CLIDevOpsGUI
0 likes · 9 min read
Best Database Schema Migration Tools: CLI, GUI, and GitOps/Database-as-Code Solutions
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 14, 2022 · Databases

Building a Multi‑Tenant SaaS with Citus: An Official Distributed PostgreSQL Example

This guide walks through creating a multi‑tenant ad‑analytics SaaS using Citus, covering schema design, sharding by company_id, data ingestion, reference tables, online schema changes, tenant‑specific JSONB fields, hardware scaling, large‑tenant isolation, and migration steps with concrete SQL examples and commands.

CitusDistributed SQLJSONB
0 likes · 27 min read
Building a Multi‑Tenant SaaS with Citus: An Official Distributed PostgreSQL Example
Architecture Digest
Architecture Digest
Feb 26, 2021 · Databases

Adding a Column to a Massive MySQL Table Safely

This article explains practical strategies for adding a new column to a MySQL table with tens of millions of rows, including creating a temporary table, copying data, renaming tables, and alternative replica‑based or third‑party methods to avoid long locks and potential crashes.

Large TableMySQLadd column
0 likes · 4 min read
Adding a Column to a Massive MySQL Table Safely
Ctrip Technology
Ctrip Technology
Sep 3, 2020 · Databases

Evolution of Ctrip's MySQL Database Release System: From 1.0 to 3.0

This article details the design, evolution, and operational practices of Ctrip's MySQL database release system, covering its three major versions, the adoption of gh‑ost, safety mechanisms, real‑world case studies, and performance improvements that enable reliable, low‑impact schema changes at scale.

MySQLautomationdatabase release
0 likes · 14 min read
Evolution of Ctrip's MySQL Database Release System: From 1.0 to 3.0