Aurora
💡 Definition
Amazon Aurora is a relational database engine built for the cloud. It is fully managed by RDS and is compatible with MySQL and PostgreSQL.
🔑 Key Concepts
- Performance: Up to 5x faster than standard MySQL databases and 3x faster than standard PostgreSQL databases.
- Storage: Automatically grows storage as needed, up to 128TB.
- Durability: Data is replicated 6 times across 3 AZs. Self-healing storage.
- Aurora Serverless: An on-demand, auto-scaling configuration for Aurora (starts up, shuts down, and scales capacity based on application needs).
⚙️ How it Works
You choose Aurora as the engine when creating an RDS instance. It uses a cloud-native storage layer that is separate from the compute instances, allowing for faster replication and recovery.
🎯 Use Cases
- Enterprise Applications: Critical applications requiring high availability and performance.
- SaaS Applications: Multi-tenant applications.
- Variable Workloads: Using Aurora Serverless for infrequent or unpredictable traffic.
💰 Pricing Model
- Instance Hours: Charged per DB instance hour.
- Storage: Charged per GB-month of storage used.
- I/O Rate: Charged per million I/O requests.
📝 Exam Tips (CLF-C02)
- "MySQL and PostgreSQL compatible".
- "5x faster than MySQL".
- "Serverless" option available.
- Managed by RDS.