GitHub's Online Schema-migration Tool for MySQL (by github)

Gh-ost Alternatives

Similar projects and alternatives to gh-ost

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better gh-ost alternative or higher similarity.

gh-ost discussion

Log in or Post with

gh-ost reviews and mentions

Posts with mentions or reviews of gh-ost. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-12-08.
  • "At GitHub we do not use foreign keys, ever, anywhere"
    1 project | | 22 Jan 2024
  • How Modern SQL Databases Are Changing Web Development - #3 Better Developer Experience
    4 projects | | 8 Dec 2023
    I’ve been through multiple incidents where everything worked fine in the testing environment but ended up locking the production database for minutes when deployed. A category of open-source tools called OSC (Online Schema Change) exists to mitigate such pain, like gh-ost used by GitHub and OSC used by Meta. They work by creating a set of "ghost tables" to apply the migrations, copy over old data from the original tables, and catch up with new writes simultaneously. When all old data is migrated, you can trigger a cutover to make the "ghost tables" production. Check the post below for a great introduction and comparison:
  • We migrated to SQL. Our biggest learning? Don't use Prisma
    11 projects | | 9 Oct 2023
    Sounds like it's basically explained in the gh-ost readme

    I think it amounts to "use views to decouple access to the table with a fixed interface" and "use triggers for migrating data between tables"

  • Ask HN: Is PostgreSQL better than MySQL?
    2 projects | | 17 Apr 2023
    Gh-ost is the new hotness. Simple to use and lots of great features:
  • My Green/blue AWS db deployment strategy for avoiding data loss due to table locks
    1 project | /r/devops | 21 Mar 2023
    If the performance of the db is a concern during migrations (locking, high cpu consumption for large writes) there are tools that can help and do similiar to what your describing but with the benefit that they are battle tested tools. This one spring to mind there are other options as well and its worth reading the trade off docs
  • Changing column from longtext to mediumtext taking over 2 hours
    3 projects | /r/mysql | 4 Nov 2022
    Not sure which version of MySQL you're using, but one approach would be to use a tool like pt-online-schema-change (from Percona) or g-host -- which will create a duplicate table and then swap it in place of the original table. It's a safer approach when operating in production environments. Here's a good comparison of the tools many people use
  • Ask HN: Do you use foreign Keys in Relational Databases
    1 project | | 6 Sep 2022
    No, especially on large tables with billions of records. They make online schema changes impossible. More details:
  • Migrating a production database without any downtime
    1 project | | 13 Aug 2022
    Tip #4: Consider slow-running migrations. Some tables can be so large that the traditional migration way is simply not a viable option for them. In such cases, you can consider embedding the data migration code right into your application, or use a special utility like GitHub's online schema migration for MySQL. A slow-running migration can work in production for days or even weeks. It gradually converts the data by small chunks, so you can carefully balance the load on the database while making sure that it doesn't cause slowness or downtime.
  • How do you handle RDS schema migrations?
    1 project | /r/aws | 27 May 2022
    GitHub gh-ost
  • Changing Tires at 100mph: A Guide to Zero Downtime Migrations
    9 projects | | 4 May 2022
    Actually I never tried but I was scared by the small print of GH not using RDS themselves [1] and Ghost relying on lower-level features that might be not easily available in RDS. Also I had the impression you have to setup a normal non-RDS replica attached to your RDS master?


  • A note from our sponsor - InfluxDB | 12 Jun 2024
    Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →


Basic gh-ost repo stats
1 day ago

Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.