RDS
Relational Database Service.It uses SQL as a query language.
- Automated provisioning, OS patching
- Continuous backups and restore to specific timestamp (Point in Time Restore)!
- Monitoring dashboards
- Read replicas for improved read performance
- Multi AZ setup for DR (Disaster Recovery)
- Maintenance windows for upgrades
- Scaling capability(vertical and horizontal)
- Storage backed by EBS
- BUT Can't SSH into your instances
Amazon Aurora
proprietary technology from AWS (not open sourced)
RDS Deployments: Replicas, Multi-AZ
- Read Replicas:
scale the read workload of your DB,
can create up to 5 Read Replicas
data is only written to the main DB
- Multi-AZ:
failover in case of AZ outage (high availability)
data is only read/written to the main database
can only have one other AZ as failover
- Multi-Region:
disaster recovery in case of region issue
local performance for global reads
replication cost
Amazon ElastiCache
In-memory databases with high performance, low latency.
Reduce load off databases for read intensive workloads.
NoSQL database
not a relational database
DynamoDB
serverless database. fast and consistent in performance. millisecond latency.
- DynamoDB Accelerator-Dax : in-mamory cache for DynamoDB