BestHub
Sign in
Tagged articles

Schema Migration

17 articles · Page 1 of 1
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.

Database DesignMySQLSchema Migration
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.

DDLLarge TablesMySQL
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.

Database OperationsLarge TablesMySQL
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 ScalingMySQL
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.

Database OperationsLarge TablesMySQL
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 fieldLarge TablesMySQL
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.

Large TablesMySQLOnline DDL
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 TroubleshootingMySQLRollback
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.

CLIDatabaseDevOps
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 TableMySQLSchema Migration
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.

AutomationMySQLSchema Migration
0 likes · 14 min read
Evolution of Ctrip's MySQL Database Release System: From 1.0 to 3.0
High Availability Architecture
High Availability Architecture
Nov 14, 2019 · Databases

Why We Should Not Use Database Foreign Keys: Insights from a GitHub Engineer

A GitHub engineer argues that database foreign keys should be avoided because they shift integrity responsibilities to the DB, incur performance overhead, and cause complications during online schema migrations, illustrating the points with parent‑child tables, gh‑ost, and pt‑online‑schema‑change tools.

DatabasesForeign KeysSchema Migration
0 likes · 4 min read
Why We Should Not Use Database Foreign Keys: Insights from a GitHub Engineer