Hacker News new | ask | show | jobs
by spudlyo 1124 days ago
How long does it take you to do a schema change?
1 comments
hu3 1124 days ago
Big MySQL deployments typically use pauseless online schema changes tooling like gh-ost:

https://planetscale.com/docs/learn/online-schema-change-tool...

link
mh- 1124 days ago
This is what we do. So "how long" is a difficult thing to put a number on, since you're intentionally throttling it to avoid impacting the database's performance (or building up slave lag).
link