gh-ost
A triggerless online schema migration tool for MySQL that uses the binary log stream instead of triggers.
What is gh-ost?
gh-ost is GitHub's online schema migration tool for MySQL that allows altering database tables without downtime or significant performance impact. It solves the problem of risky and disruptive schema changes by using a triggerless design that reads from the binary log stream instead of relying on database triggers. This approach provides greater control, safety, and operational perks compared to traditional migration tools.
Database administrators, DevOps engineers, and backend developers managing MySQL databases who need to perform safe, online schema changes in production environments.
Developers choose gh-ost because it eliminates the risks and limitations associated with trigger-based migration tools, offers true pause and throttling capabilities, and provides extensive testing options on replicas. Its design ensures minimal load on the master database and gives operators fine-grained control over the migration process.
Overview
GitHub's Online Schema-migration Tool for MySQL
Use Cases
Best For
- Performing zero-downtime schema migrations on large MySQL tables
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
