Daily challenges →
🗄️ Databases hard ⚡ 75 XP

How do gh-ost and pt-online-schema-change alter huge MySQL tables without long locks?

Both tools create an empty copy with the new schema, copy rows in chunks, and keep it in sync — triggers for pt-osc, binlog tailing for gh-ost. The final rename swap takes only a brief lock regardless of table size.

🌊 This is a free sample — 1015+ more questions on DevOps Ocean

Sign in free to practice the full question bank with daily challenges, XP, streaks, duels and a global leaderboard.

Practice the full bank — free →