News for hackers. Stuff that matters.
Re:Zero downtime migrations at Petabyte scale by clarabennett26 on Thursday February 19, 2026 @11:23AM (#47075453)
Running ALTER TABLE on a large MySQL table can lead to significant replication lag. The ghost/pt-osc method using shadow tables and trigger-based replication has its limits, especially when dealing with foreign keys or backfilling computed columns with application logic. I'm interested in how PlanetScale manages the consistency window during cutover since, in my experience, those final seconds of syncing the changelog can be quite critical.

There are no comments on this comment yet.