ChipsPlanetScalealmost 2 years ago
The State of Online Schema Migrations in MySQL
10 min read
MySQL offers INPLACE and INSTANT algorithms for non-blocking ALTER TABLE changes. INPLACE has replication issues and requires running the change individually on each server. INSTANT DDL, originally contributed by Tencent, initially only supported ADD COLUMN but now supports more schema changes.
Level
Hype check
Tap to vote and see what everyone thinks.