Postgres is the new default
summary
Engine Yard makes Postgres the default database, migrating from MySQL 5.x to Postgres 9.0/9.1 by overhauling provisioning with Chef cookbooks, EBS snapshots to S3, and automated backups from slaves; monitoring uses postgres_check and collectd and slaves run as hot standby slaves in different AZs. Adoption jumps (roughly 158 → 2,774 Postgres instances after defaulting; ~9,000 MySQL environments remain), alpha releases bite, 32‑bit instance limits block rollout, and the tooling and migration paths mostly work but need polishing.
AI-written summary · about
chapters (13)
- 0:00Start
- 3:32Engine Yard Cloud
- 4:55Stage 1
- 5:07Why love Postgres?
- 9:02Stage 2
- 10:17Stage 3
- 11:40Multiple Architectures
- 13:32Installation
- 13:54Configuration
- 14:45Replication
- 16:14Monitoring
- 19:27Future Directions
- 28:09DB Stacks
related talks
16mWhy PostgreSQL took the crown from MySQL and what lies ahead
31m#PostgreSQL to #MySQL: A DBA Perspective
15mBuilding for the Future and Betting Big on Postgres
51mScaling Postgres to the next level at OpenAI
43mJust Use Postgres.
40mDB for next project? Why, Postgres, of course
19mPostgreSQL at Amazon
18mPostgres for the modern enterprise