Catalogue / lyft-2023-aurora-postgres-upgrade

Lyft upgrades a 30 TB Aurora Postgres transactions database from v10 to v13 with about 7 minutes of downtime, using cloning and logical replication

Lyft, 2023. Payment platform transactions Aurora Postgres database.

Organisation
Lyft
Evidence
Reported from production
Source
Postgres Aurora DB major version upgrade with minimal downtime

Lyft Engineering, published 2024-03-11

Records

Decision#d1

Upgrade Aurora Postgres v10 to v13 via copy-on-write cloning and native logical replication instead of pg_upgrade or DMS

Decision#d2

Halt cutover writes with an Envoy circuit breaker and read-only source DB, and repoint via Route53 DNS

Sign in to read what was chosen, what was rejected and what it cost, each with its place in the source. An account is free.