AWS Aurora
summary
Amazon Aurora adds a Postgres 9.6 codebase to a log‑structured storage service that writes only change records, coalesces blocks, and backs segments to S3 with six copies across three AZs. Benchmarks show 2–3x performance and up to 85x faster recovery versus vanilla Postgres, read replicas share the same storage for single‑digit‑millisecond propagation, and failover targets aim for ~3–10s. Case studies report zero schema changes migrating from SQL Server, a claimed 11.5x cost reduction, 50% faster page loads and multi‑fold TPS gains.
AI-written summary · about
chapters (26)
- 0:00PostgreSQL Compatibility for Amazon Aurora
- 1:45Traditional relational databases are hard to scale
- 2:04Traditional approaches to scale databases
- 3:41Reimagining the relational database What if you were inventing the database today?
- 7:08Scale-out, distributed, log structured storage
- 8:10Amazon Aurora Storage Engine Overview
- 9:12Amazon Aurora Storage Engine Fault-tolerance
- 10:12Amazon Aurora Replicas
- 10:51Amazon Aurora Continuous Backup
- 11:22Amazon Aurora Instant Crash Recovery
- 11:57Faster, more predictable failover with Amazon Aurora
- 13:28Benchmark System Configurations
- 15:37Amazon Aurora Loads Data 3x Faster Database initialization is three times faster than PostgreSQL
- 19:22How Does Amazon Aurora Achieve High Performance?
- 21:08Write 0 Traffic in an Amazon Aurora
- 24:21Applications Restart Faster With
- 26:23First Step: Enhanced Monitoring
- 27:26Performance Insights at a glance
- 28:11Beyond Measuring Database Load
- 28:43Amazon Aurora with PostgreSQL Compatibility - Launch Roadmap
- 30:04TechnologyOne
- 31:20The Amazon Aurora Database Family
- 32:02Uberfusion Case Study - Data Migration for SSO Media
- 36:17Migration Steps
- 37:01The Solution and Benefits
- 37:56Questions
related talks
55mAmazon Aurora: A deep-dive into what's new
18mPostgreSQL at Amazon
19mPostgreSQL at Amazon
43mDeep dive into Amazon Aurora and its innovations
28mGet started with Amazon Aurora DSQL
10mPostgres on AWS: Run 5X faster on metal, migrate anywhere
50mIntroduction to Serverless Databases for MySQL and PostgreSQL
21mSave, Grow and Innovate using AWS Databases
