| MySQL |
Native |
Compatible, 5x Native Throughput |
|
| MariaDB |
Native |
|
|
| PostgreSQL |
Native |
Compatible, 3x Native Throughput |
Based on |
| Oracle |
Native |
|
|
| SQL Server |
Native |
|
|
| Workload |
OLTP |
OLTP |
OLAP |
| Availability |
Multi-AZ, Automatic host replacement |
Multi-AZ and Multi-Region cluster options |
Clustered by default. Multi-AZ and Multi-Region options |
| Durability |
Automatic backups with point-in-time recovery. Manual snapshots. |
Multi-AZ cluster volume, Automatic backups with point-in-time recovery, manual clones |
Automatic data node replacement (Cluster is unavailable for queries while replacing a data node.) |
| Consistency |
Read-after-write on source. Read replica lag as per each native engine. |
Read-after-write on primary. Milliseconds on in-region replicas. Seconds on cross-region replicas. |
Transactional consistency on producer and consumer clusters. |
| Partitioning |
Native sharding |
MySQL tablespaces, PostgreSQL partitions |
Supported only in Spectrum |
| Elasticity |
Relatively straightforward vertical and horizontal scaling. Can run Reserved Instances or On Demand |
As RDS or has a serverless offering that automatically starts, scales, and stops infrastructure as necessary, but has some limitations. |
More complex to resize leveraging elastic resize, classic resize, snapshot, restore, and resize or automated concurrency scaling. |
| Storage Size Limit |
64 TiB (MySQL, MariaDB, PostgreSQL, Oracle), 16 TiB (SQL Server) |
128 TiB |
Petabytes (directly), Exabytes (Spectrum / S3) |
| Table Size Limit |
|
64 TiB (MySQL), 32 TiB (PostgreSQL) |
|
YouTube!