Lessons from Migrating a 10 TB PostgreSQL Cluster to AWS
summary
A presentation about migrating a large PostgreSQL cluster (10 TB) used at Zalando to AWS, covering challenges of supporting over 700 clusters with mixed high-OLTP and OLAP workloads. It describes the migration experience and operational considerations when moving a high-load PostgreSQL deployment to the cloud (AWS).
AI-written summary · about
chapters (12)
- 0:00Introduction
- 3:21Original infrastructure issues
- 6:14Reasons for AWS migration
- 9:01AWS solution choices
- 15:30Spot instance savings
- 19:45Instance selection and config
- 24:21Data migration methods
- 27:55Switching process
- 33:39Backup tools
- 34:00Results and early issues
- 40:14Comparison with other clouds
- 46:59Q&A
related talks
19mPostgreSQL at Amazon
26mMastering Large-Scale PostgreSQL Migration
41mRunning Highly Available Postgres in AWS RDS
46mBig databases, many servers, data center or cloud - it's all here!
23mCCC Intelligent Solutions Achieves Improved Efficiency with Oracle to AWS PostgreSQL
49mPractical Guide to Migrating +100 Large PostgreSQL to the Cloud
50mFrom VMs to Cloud-Native PostgreSQL in Kubernetes...
48mMigrating to PostgreSQL: Strategies, Sovereignty, and Success