OnlineSchemaChange

A tool for performing online schema changes on MySQL. (by facebookincubator)

OnlineSchemaChange Alternatives

Similar projects and alternatives to OnlineSchemaChange

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

OnlineSchemaChange reviews and mentions

Posts with mentions or reviews of OnlineSchemaChange. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-12-08.
  • How Modern SQL Databases Are Changing Web Development - #3 Better Developer Experience
    4 projects | dev.to | 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:
  • Postgres schema changes are still a PITA
    2 projects | dev.to | 8 Jul 2023
    For larger companies, with more data and high-traffic tables, schema changes may happen less often, but they still need to worry about things like downtime caused by locking. They require long internal guides on performing schema changes correctly (e.g. GitLab, PayPal), custom tools (e.g. Meta, Square), and they often document incidents or near-incidents caused by schema migrations (e.g. GitHub, Doctolib, GoCardless).
  • Migrating Facebook to MySQL 8.0
    2 projects | news.ycombinator.com | 23 Jul 2021
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 7 May 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 →

Stats

Basic OnlineSchemaChange repo stats
3
955
8.1
21 days ago

facebookincubator/OnlineSchemaChange is an open source project licensed under GNU General Public License v3.0 or later which is an OSI approved license.

The primary programming language of OnlineSchemaChange is Python.


Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com