3 ms·
Is it better than pt-online-schema-change from percona-toolkit? That thing creates a new table which is the same shape as the old one, runs an ALTER on the new
by wolf550e 10y ago
Is it better than pt-online-schema-change from percona-toolkit? That thing creates a new table which is the same shape as the old one, runs an ALTER on the new table, sets up triggers on the old table to update the new table, and then copies the old rows in batches while monitoring replication slave lag. Then it renames the tables and drops the old one. You do need storage for twice the space of the table, at least temporarily.
- mcpherrinm 10y agoSquare's wrapper around pt-online-schema change is really slick: https://github.com/square/shift https://github.com/square/shift It has a nice webapp to monitor and run schema migrations, including peer review. I use it all the time at Square, and it's pretty great.