3 ms·

so to sum it up short, create table, copy data, rename table. isnt this already tackled by tools created by percona and many others out in market? other than th

• byroot 10y ago
  You are thinking of pt-online-schema-change or Soundcloud's LHM. Those are tools to modify the schema. Here they were modifying the data. But yes, it works the same way, and it's not really novel in any way.
• adevine 10y ago
  "What else is new here" is you can't have any downtime, and you have to have a strategy for having your code work against the data in all of those transitional states during that process. A lot of migrations would be pretty trivial if you could have even a couple hours of downtime, but in an expectation of 24/7 availability that is no longer acceptable in most situations.