6. Database Selection

Decision: OLTP relational

6. Database Selection

Decision: Predictable → RDS

6. Database Selection

Decision: High perf MySQL/PG → Aurora

6. Database Selection

Decision: Variable load → Aurora Serverless v2

6. Database Selection

Decision: Multi-region → Aurora Global DB

6. Database Selection

Decision: OLAP analytics

6. Database Selection

Decision: Redshift (RA3 for managed storage)

6. Database Selection

Decision: NoSQL

6. Database Selection

Decision: Key-value scalable → DynamoDB

6. Database Selection

Decision: Multi-region active-active → DynamoDB Global Tables

6. Database Selection

Decision: Document → DynamoDB / DocumentDB

6. Database Selection

Decision: Caching

6. Database Selection

Decision: Generic → ElastiCache (Redis recommended)

6. Database Selection

Decision: DynamoDB → DAX

6. Database Selection

Decision: Specialty

6. Database Selection

Decision: Time-series → Timestream

6. Database Selection

Decision: Graph → Neptune

6. Database Selection

Decision: Ledger → QLDB

6. Database Selection

Decision: Search → OpenSearch

6. Database Selection

Multi-AZ

HA, sync, standby idle (no reads)

Read Replica

scale reads, async, can promote

Aurora Features: 6 copies / 3 AZs

6. Database Selection

Aurora Features: Up to 15 read replicas (per region)

6. Database Selection

Global Database

5 secondary regions, < 1s RPO

Serverless v2

0.5-128 ACU

Backtrack (MySQL)

72h "undo"

Database Cloning

instant, copy-on-write

DynamoDB: Item max 400 KB

6. Database Selection

DynamoDB: 1 RCU = 1 strong/sec for 4 KB; 2 eventual/sec

6. Database Selection

DynamoDB: 1 WCU = 1 write/sec for 1 KB

6. Database Selection

PITR

35 days

Global Tables

multi-master multi-region

DynamoDB: Streams + DAX

6. Database Selection

DynamoDB: On-Demand vs Provisioned (switch 1x/24h)

6. Database Selection

Redis

persistence, replication, Multi-AZ, Pub/Sub

Memcached

simple, multi-threaded, no persistence