Stripe: Online migrations at scale

Stripe: Online migrations at scale

This 2017 blog entry from Jacqueline Xu at Stripe provides a very clear description of the "dual writes" pattern for applying complex data migrations without downtime: dual write to new and old tables, update the read paths, update the write paths and finally remove the now obsolete data - illustrated with an example of upgrading customers from having a single to multiple subscriptions.

Via @eatonphil

blog clear data databases downtime migrations scale stripe tables