Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Zero-downtime Postgres migrations - the hard parts

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →

Zero-downtime Postgres migrations - the hard parts

Talk video: http://www.thedotpost.com/2015/06/chris-sinjakli-zero-downtime-postgresql-migrations

As a payments company, GoCardless can't take unexpected downtime lightly. Back in January, we were hit by a 15 second API outage during a Postgres schema change. We thought we had all the bases covered, but obviously we'd missed something.

In the talk I briefly introduce the problem of zero-downtime schema changes, what happened to us, and give a few tips on how to avoid it happening to you.

The talk is a condensed version of this blog post: https://gocardless.com/blog/zero-downtime-postgres-migrations-the-hard-parts/

Presented at dotScale 2015

Chris Sinjakli

June 08, 2015

Transcript

11 slides

More Decks by Chris Sinjakli

Other Decks in Programming