Catalogue / gridium-2021-aurora-migration

Gridium moves a 3 TB analytics Postgres database to Aurora and undoes a more-than-doubled bill by upsizing cache memory, shifting reads and repacking tables

Gridium. Energy analytics database.

Organisation
Gridium
Evidence
Reported from production
Source
Migrating to Aurora: easy except the bill

Gridium Engineering, published 2021

Records

Decision#d1

Migrate the Energy analytics database from multi-AZ Postgres RDS to Aurora for elastic storage

Decision#d2

Upsize the Aurora writer for buffer cache, route reads to a downsized replica, and run pg_repack on bloated tables to cut billed I/O

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.