This commentary from Mercari Engineering outlines their strategy for a zero-downtime database migration. It is the first part in a series, focusing on the initial design for achieving strong data consistency.
https://engineering.mercari.com/en/blog/entry/20241113-designing-a-zero-downtime-migration-solution-with-strong-data-consistency-part-i/