Upgrading Postgres 9.3 with zero downtime
Cory Stephenson is a Data Reliability Engineer for Datadog. He got an early start on database administration with a highschool corse on Oracle 9i. Prior to joining Datadog, Cory worked as a software engineer at Tandem (formerly Devmynd), where he primarily used Postgres as the RDBMS. Cory lives in Chicago with his husband Aaron Kalin and their chosen family.
No video of the event yet, sorry!
With the advent of PGLogical, upgrading a PostgreSQL cluster with (relatively) zero down-time is somewhat easy. But PGLogical requires PostgreSQL 9.4 or later. With 9.3, it’s not even close to easy. Add in over a hundred clusters, with a combination of read-write, write-only, sharded clusters, and combinations of the three, and you have a whole cluster of problems. Join me as I describe how we upgraded these clusters with nearly zero downtime, using a combination of tools such as Kafka, Zookeeper, and Londiste.
- 2019 March 20 15:40
- 20 min
- Murray Hill
- Postgres Conference
- Use Cases