Re:In MySQL, use “utf8mb4” instead of “utf8” (2016)
by Spivak on Wednesday January 12, 2022 @07:36PM
(#29915153)
So you're right but also wrong thanks to good tooling. If you have enough discipline to not put triggers on your tables then pt-online-schema-change has got you sorted. Does it take forever? Yep, but does it matter that it takes forver? Nope because it doesn't lock tables.
And even if you do have triggers https://github.com/github/gh-ost you can still do it.