| feature | RDS | Aurora |
|---|---|---|
| usage scenarios | rather predicable usage requirements, frequent usage | inpredictable usage pikes, infrequent usage |
| serverless | no | yes |
| engines | PostgreSQL, MySQL, MariaDB, Oracle, MS SQL Server | PostgreSQL, MySQL (AWS native, compatible with) |
| vertical CPU autoscaling | no | yes |
| vertical storage autoscaling | yes (backed by EBS) | yes (10GB to 64TB) |
| horizontal read autoscaling (read replicas) | up to 5 | up to 15 |
| performance | (n.a., baseline) | 3 x faster than PostgreSQL, 5 x faster than MySQL |
| reserved instances | yes (cost decrease of up to 60% in infrequent usage scenario) | no |
| cross region replication | configurable | per default |
| failover | Multi AZ configurable, slower | native HA, faster (30sec) |
| cost | (n.a., baseline) | approx. +20% (in frequent usage scenario only) |
| backups | automatic full backup (daily, 7-35 days retention) + transaction logs (every 5 min), manual snapshot (unlimited retention) | backtrack (data restore at any point in time approx. 1 min resolution, unlimited retention) |
| encryption (persisted) | KMS | KMS |
| encryption (transmission) | SSL | SLL |
| authentication | IAM token | IAM token |
Last active
March 28, 2022 20:30
-
-
Save fkromer/6100657fe7f2c6cd5f917291e3add01f to your computer and use it in GitHub Desktop.
Comparsion between Amazon RDS vs. Aurora key characteristics
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment