Amazon Relational Database Service (RDS) is a fully-managed relational database platform by AWS.
It automates provisioning, patching, backups, replication, and failover so you can focus on data and applications — not database plumbing.
Traditional DB management challenges RDS solves:
| Problem | RDS Solution |
|---|---|
| Server setup & patching | Automated maintenance |
| Manual backups | Automated backups + point-in-time restore |
| High availability setup | Multi-AZ failover |
| Slow scaling | One-click or Auto Scaling storage & compute (Aurora) |
| Security effort | Encryption, IAM, VPC controls built-in |
Goal: Reduce operational toil and let teams scale secure DBs globally.
| Engine | Best For |
|---|---|
| MySQL | Open-source apps, web workloads |
| PostgreSQL | Modern distributed apps, analytics features |
| MariaDB | Replacement for MySQL with better performance in many cases |
| Oracle | Enterprise workloads |
| SQL Server | Microsoft ecosystem workloads |
| Amazon Aurora (MySQL / PostgreSQL compatible) | Cloud-optimized DB with best performance & auto-scaling |
Aurora is the premium option (5x MySQL, 3x PostgreSQL performance).
| Mode | Description |
|---|---|
| Single-AZ | Lowest cost, dev environments |
| Multi-AZ Standby | HA, synchronous replication, automatic failover |
| Multi-AZ Cluster (New) | High throughput and fast failover (Aurora-like) |
| Read Replicas | Scale reads, global databases possible |