BestHub
Sign in
Tagged articles
23 articles
Page 1 of 1
Su San Talks Tech
Su San Talks Tech
May 5, 2026 · Databases

Alibaba Interview: Key Considerations for Indexing Tens‑Millions‑Row Tables

The article explains how to safely add indexes to a tens‑of‑millions‑row MySQL table, covering lock duration, disk‑space impact, write‑performance degradation, and six practical principles—selective columns, proper order, covering indexes, avoiding redundancy, short‑lock tools, and ongoing monitoring—plus pros, cons, and suitable use cases.

Large TablesOnline DDLPerformance Monitoring
0 likes · 10 min read
Alibaba Interview: Key Considerations for Indexing Tens‑Millions‑Row Tables
Ray's Galactic Tech
Ray's Galactic Tech
Jan 12, 2026 · Databases

How to Safely Add Columns to Billion‑Row MySQL Tables Without Downtime

This guide explains why using a plain ALTER TABLE on massive MySQL tables can lock the table and halt services, and presents tool‑based online DDL, native INPLACE options, phased migration strategies, cloud‑DB features, best‑practice checks, monitoring, and rollback techniques to add new columns safely.

Online DDLSchema Changedatabase migration
0 likes · 8 min read
How to Safely Add Columns to Billion‑Row MySQL Tables 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
dbaplus Community
dbaplus Community
Feb 6, 2025 · Databases

How a MySQL Online Schema Change Platform Evolved from a Single‑Lane Bridge to a Robust 2.0 System

This article recounts the development of ZzoOnlineDDL, a MySQL schema‑change platform, detailing its 1.0 limitations, the 2.0 architectural upgrades, feature set—including intelligent tool selection, timed execution, sharding support, monitoring, and retry mechanisms—and lessons learned from real‑world incidents such as MDL locks, disk pressure, and unique‑index pitfalls.

Online DDLSchema Changegh-ost
0 likes · 34 min read
How a MySQL Online Schema Change Platform Evolved from a Single‑Lane Bridge to a Robust 2.0 System
vivo Internet Technology
vivo Internet Technology
Aug 7, 2024 · Databases

MySQL 5.7 DDL vs GH-OST: A Comprehensive Comparison of Online Schema Change Tools

While MySQL 5.7 native DDL methods (copy, inplace rebuild, index build, metadata‑only) vary in speed, space use, lock impact, and binlog output, GH‑OST consistently offers the fastest execution, lowest lock blocking, real‑time replication, albeit at roughly double storage cost, making it ideal for risk‑averse online schema changes.

DDLInnoDBOnline DDL
0 likes · 11 min read
MySQL 5.7 DDL vs GH-OST: A Comprehensive Comparison of Online Schema Change Tools
Qunar Tech Salon
Qunar Tech Salon
May 31, 2022 · Databases

Comparison of pt-online-schema-change, gh-ost, and MySQL Online DDL for Online Schema Changes

This article introduces and compares three MySQL online schema‑change solutions—pt‑online‑schema‑change, gh‑ost, and native MySQL ONLINE DDL—detailing their workflows, limitations, risks, monitoring features, and practical considerations for safely altering large tables in production environments.

DDLOnline Schema Changedatabase migration
0 likes · 27 min read
Comparison of pt-online-schema-change, gh-ost, and MySQL Online DDL for Online Schema Changes
Aikesheng Open Source Community
Aikesheng Open Source Community
May 6, 2021 · Databases

Designing an Online DDL Work Order System for MySQL

This article examines the pain points of MySQL DDL operations for large tables, analyzes the limitations of online DDL, compares tools like gh‑ost and pt‑osc, and outlines a comprehensive workflow and implementation details for an automated online DDL work‑order system.

DDLDatabase AdministrationOnlineDDL
0 likes · 9 min read
Designing an Online DDL Work Order System for MySQL
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
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 30, 2020 · Databases

Using gh-ost for Online MySQL Schema Migration – Introduction, Architecture, Installation, and Practical Usage

This article provides a comprehensive guide to gh-ost, the GitHub‑released online MySQL schema migration tool, covering its design principles, three migration modes, download and RPM installation, common command‑line options, interactive socket commands, and a step‑by‑step example of altering a column type while monitoring progress and performing a safe cut‑over.

Database ToolsSchema Changegh-ost
0 likes · 25 min read
Using gh-ost for Online MySQL Schema Migration – Introduction, Architecture, Installation, and Practical Usage
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
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 17, 2019 · Databases

Using gh-ost for Online Schema Changes in MySQL: Introduction, Usage, Parameters, and Comparison with pt-osc

This article introduces the gh-ost tool for performing online schema changes on large MySQL tables, explains its architecture and operation modes, provides detailed command‑line parameters and practical examples, and compares its features and performance with the traditional pt‑osc solution.

DDLOnline Schema Changegh-ost
0 likes · 18 min read
Using gh-ost for Online Schema Changes in MySQL: Introduction, Usage, Parameters, and Comparison with pt-osc
Java Backend Technology
Java Backend Technology
Apr 26, 2019 · Databases

What Happens When MySQL Auto‑Increment IDs Exhaust? Practical Solutions

This article explains why MySQL auto‑increment primary keys can reach their limit, shows how switching from INT to BIGINT prevents overflow, and reviews three online schema‑change methods—including native ALTER, pt‑osc, and gh‑ost—plus considerations for triggers, foreign keys, and master‑slave setups.

BIGINTOnline Schema Changeauto_increment
0 likes · 8 min read
What Happens When MySQL Auto‑Increment IDs Exhaust? Practical Solutions
NetEase Game Operations Platform
NetEase Game Operations Platform
Apr 20, 2019 · Databases

Understanding MySQL DDL Algorithms and How to Minimize Their Impact

This article explains the three MySQL DDL algorithms (COPY, INPLACE, INSTANT), compares third‑party tools like pt‑online‑schema‑change and gh‑ost, and provides practical guidance on selecting algorithms, using ALGORITHM clauses, monitoring progress, and handling performance, space, replication lag, and metadata lock issues.

DDLINPLACEcopy
0 likes · 13 min read
Understanding MySQL DDL Algorithms and How to Minimize Their Impact
dbaplus Community
dbaplus Community
Apr 18, 2019 · Databases

Mastering MySQL DDL: Algorithms, Tools, and Performance Tips

This article explains the challenges of MySQL DDL on large tables, details the built‑in COPY, INPLACE, and INSTANT algorithms, compares third‑party tools like pt‑online‑schema‑change and gh‑ost, and provides practical guidance on minimizing impact, monitoring progress, and handling metadata locks.

DDLINPLACESchema Change
0 likes · 15 min read
Mastering MySQL DDL: Algorithms, Tools, and Performance Tips
Tencent Cloud Developer
Tencent Cloud Developer
Mar 23, 2018 · Databases

Using gh-ost for Online MySQL Schema Changes: Features, Modes, and Practical Tips

gh‑ost is a lightweight, trigger‑free, Go‑based online MySQL schema‑change tool that reads binary logs, applies alterations to temporary tables, and offers pauseable, auditable, and dynamically controllable migrations via socket commands, supporting master‑only, replica‑assisted, or replica‑testing modes and used extensively at GitHub.

DBA toolsOnline Schema Changebinary log
0 likes · 17 min read
Using gh-ost for Online MySQL Schema Changes: Features, Modes, and Practical Tips