2.5. Core AWS Services: Databases
Databases are critical components for almost all applications, providing a structured way to store and manage data. Imagine databases like different organizational systems: RDS is like a spreadsheet with strict columns and rows (structured, relational), while DynamoDB is like a filing system where each folder can contain different types of documents (flexible, NoSQL). Without choosing the right database type, applications either struggle with rigid schemas that can't adapt to changing data — or lack the transactional guarantees needed for financial operations, and when data integrity breaks, the entire business logic fails.
💡 First Principle: The First Principle of AWS databases is to provide managed, scalable, and specialized solutions for diverse data needs, enabling users to choose the right database for their application while abstracting the complexities of database administration.
Scenario: A company needs to store transactional customer data, product catalogs (with flexible schema), and historical sales data for analytics. They need to choose the appropriate database service for each.
Reflection Question: How do diverse AWS database services (e.g., RDS, DynamoDB, Aurora) fundamentally enable businesses to choose the right database solution for their data based on model, access patterns, and scalability, while simplifying database administration?
| Feature | Amazon RDS | Amazon DynamoDB | Amazon Aurora |
|---|---|---|---|
| Model | Relational (SQL) | NoSQL (key-value/document) | Relational (SQL) |
| Engines | MySQL, PostgreSQL, MariaDB, Oracle, SQL Server | Proprietary | MySQL- and PostgreSQL-compatible |
| Scaling | Vertical (resize) + Read Replicas | Automatic horizontal | Auto-scaling storage + Read Replicas |
| Performance | Standard | Single-digit ms at any scale | 5× MySQL, 3× PostgreSQL |
| Management | Managed (patching, backups) | Fully serverless option | Managed |
| Best For | Traditional apps, ACID transactions | High-traffic web/mobile, IoT | Enterprise workloads needing performance + compatibility |