Cloud Arena
Back to Databases

Amazon Aurora / Amazon RDS

aws

High-performance distributed relational database engine with 6-way multi-AZ replication and Serverless v2.

DATABASES
•Amazon Web Services

High-performance distributed relational database engine with 6-way multi-AZ replication and Serverless v2.

Click any section above to jump directly to it
GCP ➔ AWS Bridge
Fast-Track Mental Model Translation

Coming from Google Cloud?

Compare with Google Cloud SQL / AlloyDB for PostgreSQL

Both offer managed MySQL and PostgreSQL with enterprise high availability, but Aurora decouples compute and storage across a custom 6-way multi-AZ storage fabric similar to Google Cloud AlloyDB.

What's Conceptually Identical
  • Fully managed MySQL and PostgreSQL compatibility with automated backups and point-in-time recovery.
  • High availability multi-zone failover and horizontal read replicas.
  • IAM database authentication and integration with cloud secret managers.
Key Architectural Shifts in AWS
  • Architecture: Standard Cloud SQL uses persistent disk replication; Aurora uses a custom distributed log-structured storage fleet with 4-of-6 write quorums.
  • Replicas: Aurora read replicas share the same physical storage volume (<20ms lag); Cloud SQL replicas process WAL logs independently.
  • Serverless: Aurora Serverless v2 scales in fine-grained 0.5 ACU increments; Cloud SQL requires vertical VM resizing.
Syntax & Command Translator
Create Database Cluster / Instance
GCP:gcloud sql instances create prod-db --database-version=POSTGRES_15 --tier=db-custom-4-16384 --region=us-central1
AWS:az rds db-cluster create --db-cluster-identifier prod-cluster --engine aurora-postgresql

What is Amazon Aurora / Amazon RDS?

Amazon Aurora is a MySQL- and PostgreSQL-compatible relational database built for the cloud that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It features a distributed, log-structured, SSD-backed storage architecture that decouples compute from storage, automatically replicates data 6 ways across 3 Availability Zones, and scales storage up to 128 TiB with zero downtime.

Decision Guide: When to Choose This Service

When to Use Amazon Aurora / Amazon RDS

Use Amazon Aurora for enterprise transactional OLTP workloads, complex SQL queries, multi-region disaster recovery, and applications requiring MySQL/PostgreSQL compatibility with up to 5x throughput of standard engines.

When NOT to Use (Recommended Alternatives)

Do NOT use Amazon Aurora for massive petabyte-scale data warehouse analytics (use Amazon Redshift) or simple high-throughput key-value access where millisecond NoSQL suffices (use DynamoDB).

Core Architectural Pillars

Decoupled Shared Storage

Single virtualized storage volume auto-scaling up to 128 TiB shared by primary writer and up to 15 read replicas.

6-Way Multi-AZ Quorum

Replicates 6 copies across 3 AZs; tolerates loss of an entire AZ plus an additional storage node without write disruption.

Aurora Serverless v2

Instant scaling in fine-grained 0.5 ACU increments (1 GB RAM per 0.5 ACU) without dropping connections.

Aurora Global Database

Storage-level replication to secondary regions with <1s lag and sub-minute disaster recovery.

Fast Database Cloning

Zero-copy, copy-on-write database clones created in seconds for testing and CI/CD.