Tag

gh-ost

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 10, 2025 · Databases

ChatDBA AI Assistant Solves gh-ost Usage Issue: Case Study and DeepSeek Comparison

This article presents a detailed case study where the ChatDBA AI assistant diagnoses and resolves a gh-ost migration stall caused by large table size and VARCHAR length expansion, compares its response with DeepSeek, and showcases the tool's expert-mode root‑cause analysis and actionable recommendations.

AIChatDBADatabase Troubleshooting
0 likes · 6 min read
ChatDBA AI Assistant Solves gh-ost Usage Issue: Case Study and DeepSeek Comparison
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.

DDLInnoDBMySQL
0 likes · 11 min read
MySQL 5.7 DDL vs GH-OST: A Comprehensive Comparison of Online Schema Change Tools
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 18, 2023 · Databases

Schema Change for a 400‑Million‑Row MySQL Table Using Cascade Replication

This article details a step‑by‑step strategy for expanding a VARCHAR column from 50 to 500 characters on a 4‑hundred‑million‑row MySQL 8.0 table, evaluating online DDL, gh‑ost, pt‑osc, and ultimately implementing a cascade replication workflow to meet a four‑hour downtime window.

MySQLcascade replicationgh-ost
0 likes · 10 min read
Schema Change for a 400‑Million‑Row MySQL Table Using Cascade Replication
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 6, 2023 · Databases

Adding Unique Indexes in MySQL: Methods, Risks, and Hook‑Based Mitigations

This article explains how to add unique indexes to large MySQL tables using Online DDL, pt‑osc, and gh‑ost, compares their advantages and drawbacks, outlines common data‑loss risks, and provides practical hook scripts and best‑practice recommendations to mitigate those risks.

MySQLdatabase migrationgh-ost
0 likes · 20 min read
Adding Unique Indexes in MySQL: Methods, Risks, and Hook‑Based Mitigations
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.

DDLMySQLOnline Schema Change
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 13, 2022 · Databases

SQLE 1.2205.0-pre2 Release Notes and Feature Overview

The preview release SQLE 1.2205.0-pre2 introduces LDAP over SSL support, stricter error handling for gh‑ost dry‑run failures, several bug fixes, and provides updated documentation and download links for the open‑source SQL audit platform.

Bug FixesLDAPSRelease Notes
0 likes · 5 min read
SQLE 1.2205.0-pre2 Release Notes and Feature Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 29, 2022 · Databases

SQLE 1.2204.0 Release Notes – New Features, Improvements, and Bug Fixes

The SQLE 1.2204.0 release introduces an optimized SQL deployment workflow with approval steps, gh-ost dry‑run enhancements, real‑time message push for audit results, expanded permission controls, and a comprehensive list of new features, improvements, and bug fixes.

PermissionsRelease NotesSQL
0 likes · 6 min read
SQLE 1.2204.0 Release Notes – New Features, Improvements, and Bug Fixes
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 AdministrationMySQL
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.

AutomationDatabase ReleaseMySQL
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 ToolsLinuxMySQL
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 KeysPerformancedatabases
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 18, 2019 · Databases

Understanding gh-ost Online DDL Migration Process and Cut‑over Mechanics

This article explains the internal workflow of the gh‑ost online DDL tool, covering its execution steps, binlog handling, data consistency analysis, cut‑over process, lock management, and failure scenarios, with detailed code examples and practical insights for safe schema changes in MySQL.

MySQLbinlogcut-over
0 likes · 15 min read
Understanding gh-ost Online DDL Migration Process and Cut‑over Mechanics
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.

DDLMySQLOnline Schema Change
0 likes · 18 min read
Using gh-ost for Online Schema Changes in MySQL: Introduction, Usage, Parameters, and Comparison with pt-osc
JD Retail Technology
JD Retail Technology
Jul 5, 2019 · Databases

Understanding MySQL Online DDL, PT-OSC, and GH-OST for Large Table Schema Changes

This article explains how MySQL performs DDL operations on large tables without long‑lasting locks, covering the evolution from copy‑table and in‑place methods to Fast Index Creation, Online DDL introduced in 5.6, and third‑party tools PT‑OSC and GH‑OST, with detailed process steps and comparisons.

MySQLdatabasesgh-ost
0 likes · 11 min read
Understanding MySQL Online DDL, PT-OSC, and GH-OST for Large Table Schema Changes
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.

CopyDDLINPLACE
0 likes · 13 min read
Understanding MySQL DDL Algorithms and How to Minimize Their Impact
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 toolsMySQLOnline Schema Change
0 likes · 17 min read
Using gh-ost for Online MySQL Schema Changes: Features, Modes, and Practical Tips