Re:GitHub's online schema migration for MySQL
by kd22 on Thursday May 03, 2018 @10:52AM
(#16986542)
Can someone shed some light on how this tool compares to something like Flyway?
[ Parent
| on HN ]
Re:GitHub's online schema migration for MySQL
by bpicolo on Thursday May 03, 2018 @10:58AM
(#16986606)
It's an alternative to e.g. pt-online-schema-change [0]. The problem is that, for very large mysql tables / clusters, running DDL against the tables live will lock up reads/writes against the table for ages. These tools allow you to run those changes without taking downtime.
https://www.percona.com/doc/percona-toolkit/LATEST/pt-online...