Database Services
Managed database services let you focus on your data and queries instead of database administration. Cloud providers offer relational, NoSQL, and specialized database options.
Database Landscape
┌─────────────────────────────────────────────────────┐
│ MANAGED DATABASE OPTIONS │
├───────────────┬───────────────┬─────────────────────┤
│ Relational │ NoSQL │ Specialty │
│ (SQL) │ │ │
│ │ Key-Value: │ Graph: Neptune │
│ RDS │ DynamoDB │ │
│ Aurora │ Document: │ Time Series: │
│ Cloud SQL │ CosmosDB │ Timestream │
│ PostgreSQL │ Wide-Column: │ │
│ MySQL │ Cassandra │ Cache: ElastiCache │
│ │ │ │
├───────────────┼───────────────┼─────────────────────┤
│ ACID, joins, │ Flexible │ Specialized query │
│ complex queries│ schemas, │ patterns │
│ │ high scale │ │
└───────────────┴───────────────┴─────────────────────┘
Relational Databases (RDS)
Managed relational databases handle patching, backups, replication, and scaling. Amazon RDS supports MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server. Aurora is AWS's own database engine offering MySQL and PostgreSQL compatibility with 5x better performance.
NoSQL Databases
DynamoDB: A fully managed key-value and document database. It delivers single-digit millisecond performance at any scale. Ideal for gaming leaderboards, session management, and IoT data.
Cosmos DB: Azure's globally distributed, multi-model database. Supports document, key-value, graph, and column-family data models.
When to Use What
┌──────────────────────────┬────────────────────────┐
│ Use Case │ Database Choice │
├──────────────────────────┼────────────────────────┤
│ E-commerce transactions │ RDS (PostgreSQL) │
│ User session storage │ DynamoDB │
│ Social media graph │ Neptune │
│ Real-time analytics │ Redshift / BigQuery │
│ IoT sensor data │ Timestream │
│ Caching frequent queries│ ElastiCache (Redis) │
│ Global user data │ Cosmos DB │
└──────────────────────────┴────────────────────────┘
Pro Tips
Start with managed services — they save you months of operational work. Use read replicas to offload reporting queries. Enable automated backups with point-in-time recovery. Always test your failover process before you need it.