| Basis | ⭐ Amazon Aurora | Non-Aurora Engines |
|---|---|---|
| Compatible DB Engines | Postgres, MySQL | Postgres, MySQL, Oracle, MS SQL |
| Performance | 👍 5x faster than RDS MySQL, 3x than RDS Postgres. - High throughput (200K writes/second) |
Comparatively slower than Aurora Engines |
| Serverless Computing support | ✅ Yes, through Aurora Serverless | ❌ Not-Supported |
| High Availability - Storage (automatic failover) | ✅ Yes - By default, Aurora synchronously replicates data in 6 storage notes in 3 AZs. |
If Multi-AZ enabled, its supported. |
| High Availability - Compute (automatic failover) | ✅ Yes | If Multi-AZ enabled, its supported. |
| ⏱️ High Availability - Fail Over time | 👍 If Multi-AZ enabled, less than 30 secs (since a replica would be promoted based on Priority-tier). - Otherwise up to 10 minutes (since new replacement DB instance would be created). |
If Multi-AZ enabled, around 60-120 seconds. |
| High Availability - Read Replica promotion | ✅ Automatic promotion of replica to primary instance, in case of fail-over. | 👎 Replica can be MANUALLY promoted to primary instance, in case of fail-over. |
| Scalability - Read Replicas | 👍 Upto 15 read-replicas per master, within same region | Up to 5 read-replicas |
| ⏱️ Scalability - Read Replica lag | 🚀 ~100 ms (max 1 second) - Since same data volume is shared in Aurora. |
~ few seconds to minutes |
| Auto-Scaling - Storage | 👍 Enabled by default | Disabled by default |
| Auto-Scaling - Compute | ✅ Yes, through Read Replicas or vertical scaling using Aurora Serverless v2 | ✅ Yes, through Read Replicas |
| ⭐ IOPs (input/output operations per second) | Greater than 80K IOPS | Max 80K IOPS |
| Storage Type | Uses a single, virtual cluster volume that uses SSDs. | Supports Amazon EBS solid state drive (SSD)-based storage types. |
| Storage Limit | 👍 Supports upto 128 TB DB size | Supports upto 64 TB DB size |
| DB Version Upgrades | ✅ All instances are updated together. | 👎 Primary, Replicas needs to be upgraded independently. |
| Database Cloning | ✅ Supported | ❌ Not-Supported |
| Multi-Master support | ✅ Yes | ❌ Not-Supported |
| Cross-Region Read Replicas | ✅ Supported | ✅ Supported |
| Multi-Region replication support | ✅ Yes, through Aurora Global Database | ❌ Not-Supported |
| Cross-Region Automated backups | ✅ Supported | ✅ Supported |
| Crash Recovery | 👍 Quicker than RDS | - |
