Hacker News new | ask | show | jobs
by sansnomme 2560 days ago
How do you do live migrations? Do you shard, then suspend existing queries, and finally redirect?
1 comments
dianasaur323 2560 days ago
We spin up a separate instance that matches the type that you want to migrate to, restore a backup and stream the WAL logs. Then, we redirect.
link
sansnomme 2560 days ago
The good ol' event sourcing trick :D
link