Amazon Aurora
What is it?
Amazon Aurora is a cloud-native relational database, compatible with MySQL and PostgreSQL, built for higher performance and availability than running them yourself.
Explain like I'm 5
Why was it created?
AWS rebuilt the storage layer of relational databases for the cloud to get better performance, durability, and availability while staying compatible with popular engines.
Where is it used?
- High-traffic relational workloads
- Apps needing strong availability
- MySQL/PostgreSQL-compatible systems
- Scalable cloud databases
Why should developers care?
Aurora is a popular high-end managed database on AWS, so it's worth knowing when it's chosen over plain RDS.
How does it work?
Aurora keeps the familiar MySQL/PostgreSQL interfaces but replaces the storage engine with a distributed, fault-tolerant layer that replicates data across zones automatically, enabling fast failover and read scaling.
Real-world example
A growing app on MySQL moves to Aurora for the same compatibility but better throughput, automatic multi-zone replication, and fast failover.
Common use cases
- High-performance relational databases
- High-availability requirements
- Read-heavy scaling with replicas
- Drop-in for MySQL/PostgreSQL apps
Advantages
- High performance
- Built-in multi-zone replication
- MySQL/PostgreSQL compatible
- Fast failover and read scaling
Disadvantages
- Costs more than basic RDS
- AWS-specific (lock-in)
- Overkill for small apps
- Less control than self-hosting
When should you use it?
When you need a high-performance, highly-available relational database compatible with MySQL or PostgreSQL.
When should you avoid it?
For small workloads where standard RDS or a single database is cheaper and sufficient.
Alternatives
Related terms
Interview questions
Beginner
- What is Amazon Aurora?
- What databases is it compatible with?
Intermediate
- How does Aurora differ from standard RDS?
- How does it achieve high availability?
Senior
- Why does Aurora separate compute from a distributed storage layer?
- When is Aurora worth the extra cost over RDS?
Common misconceptions
- "Aurora is a brand-new database language" — it's compatible with MySQL and PostgreSQL, so existing apps usually work as-is.
- "Aurora is just RDS" — it shares the managed model but re-engineers storage for performance and availability.
Fun facts
- Aurora separates compute from a distributed, self-healing storage layer.
- It comes in MySQL-compatible and PostgreSQL-compatible editions.
Timeline
- 2015 — Amazon Aurora becomes generally available
Learning resources
Quick summary
Amazon Aurora is a MySQL/PostgreSQL-compatible cloud database re-engineered for higher performance and availability than self-managed databases.
Cheat sheet
- Cloud-native relational database
- MySQL/PostgreSQL compatible
- Distributed, replicated storage
- Higher performance than basic RDS