I think PlanetScale folks have blogged well about how schema migration tools work and their traffic splitting, rewinding abilities are very nice.

https://docs.planetscale.com/learn/how-online-schema-change-...

https://planetscale.com/blog/its-fine-rewind-revert-a-migrat...