Good luck with that. Actually number of records is irrelevant. It is… — andreyka26_se

andreyka26_se@programming_space · 1.1K subscribers Open in TelegramOpen

Good luck with that.

Actually number of records is irrelevant. It is about reliability.

You can never be sure your migration will work without error 100% on prod instance.

If it does not - you have downtime, lost data(as recovery is from backup, or roll forward the fix, that might not work as well).

You dont have control and monitoring. In sharded env - again, you cannot do it atomically on multiple shards.

Aaand it does not work for all types of migration/storages (it can be much more complicated than boolean field)

Especially on highload systems - never do that. Always do 3 steps approach

t.me/programming_space/2383 Translate