加载中
正在获取最新内容，请稍候...
gh-ost: GitHub's Online Schema-migration Tool for MySQL
gh-ost is a triggerless, online schema migration tool for MySQL. It provides a safe and non-blocking way to alter table schemas without causing downtime for production applications.
Go
Added on 2025年6月6日12,745
Stars1,308
ForksGo
LanguageProject Introduction
Summary
gh-ost is a robust, open-source tool developed by GitHub to address the challenges of performing schema migrations on large-scale, production MySQL databases with minimal impact and zero downtime.
Problem Solved
Traditional MySQL ALTER TABLE statements often require exclusive locks on tables for the duration of the operation, leading to significant application downtime, especially on large tables. gh-ost solves this by performing migrations online.
Core Features
Triggerless Operation
Performs schema migrations without using triggers, which avoids potential issues with trigger-based migration tools and reduces overhead.
Online Control and Throttling
Allows controlling the migration process in real-time, including throttling, pausing, and canceling, to minimize impact on the production database.
Tech Stack
Go
MySQL
使用场景
gh-ost is essential for scenarios requiring schema modifications on production MySQL databases without interruption.
场景一：生产环境数据库模式更新
Details
Apply complex schema changes (e.g., adding columns with default values, changing column types, adding indexes) to high-traffic production tables without blocking read or write operations.
User Value
Ensures continuous availability of critical applications during database schema changes.
场景二：处理大型数据库表迁移
Details
Perform migrations on very large tables (hundreds of gigabytes or terabytes) where traditional ALTER TABLE operations would take prohibitively long and impact performance.
User Value
Makes schema changes feasible on massive datasets, enabling evolution of large database structures.
Recommended Projects
You might be interested in these projects
FreeRADIUSfreeradius-server
FreeRADIUS is the most widely-deployed open source RADIUS server. It provides robust, flexible, and high-performance Authentication, Authorization, and Accounting (AAA) services for a broad range of network access technologies, including Wi-Fi, VPNs, and wired networks.
C
22931134
dockercli
The Docker CLI is the command-line interface for interacting with the Docker daemon, enabling users to build, run, and manage Docker containers, images, networks, and volumes directly from the terminal.
Go
52912001
kubernetesdashboard
Kubernetes Dashboard is a general purpose, web-based UI for Kubernetes clusters. It allows users to manage and troubleshoot applications running on Kubernetes, as well as the cluster itself.
Go
149594238