RDS Aurora
RDS vs Aurora
| RDS | Aurora |
|---|---|
| Master/Slave Architecture | Master and Read Replicas |
| Master and Slave have their own separate underlying hardware storage | Master and Slave share same underlying hardware storage cluster across a region. |
| Cannot Access Slave except in Disaster Recovery | Can Always Access Read Replicas |
| eg: PostgreSQL, MySQL, MariaDB, Oracle, SQL Server | Aurora replicas are distributed across the AZs that a db cluster spans in a region. |
| Oracle RAC is not supported by RDS. | Allows incremental backups up to 35 days. |
| Allows backtracking of db up to 7 days back | |
| Allows Cloning the db with not much delay ( 5 - 10 mins) | |
| Allows parallel querying of same kinda data (parellelizes io and compute) | |
| Allows Autoscaling replicas for read workloads | |
| Supports Global database (Cross-region replication at storage hardware level by streams of transaction logs). DR in a cross-region less than a min. |
Oracle RAC (Real Application Clusters) is not supported by RDS. ie why you need to deploy the database in an EC2 instance.
Aurora Serverless
Concept of Warm pool of instances (without any data) ready to swap into an existing serverless cluster as capacity is needed.
Connections are managed by a shared proxy layer which brokers connections and stops interruptions due to scaling events or failures.
ACU : 1 Aurora Capacity Unit (2GB + 1vCPU)
- If an AZ fails, switching to a new AZ takes time with increased failover time.
- Supports Query Editor using Data API.
- You can connect to DB in both ways as mysql connection as well as via AWS API.