BestHub
Sign in
Tagged articles
13 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
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 TablesOnline DDL
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.

DDLJSONOnline DDL
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 TablesOnline DDL
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 TablesOnline 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.

Large TablesOnline DDLSchema Migration
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.

JSONSQL ModeSchema Migration
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
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 TableSchema Migrationadd 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.

AutomationSchema Migrationdatabase release
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.

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