AWS - Aurora五, 16/10/2020 - 23:51 的修訂版本




SaaS - Relational Database Service (RDS)


high performance (5x MySQL)
up to 15 low-latency read replicas (Asynchronous, In-region, milliseconds)
cross-region replicas (Physical / Logical replication)
point-in-time recovery(up to 5 minutes in the past), DB Snapshot
continuous backup to S3
Amazon Aurora automatically maintains 6 copies of your data across 3 AZs
encryption through AWS Key Management Service (KMS)
encryption of data in transit using SSL
compatible with existing MySQL and PostgreSQL
prioritize certain replicas as failover targets over others
Aurora Multi-Master
Aurora Parallel Query

High Availability and Replication

Each 10GB chunk of your database volume is replicated six ways
loss of up to two copies of data without affecting database write availability and
up to three copies without affecting read availability

Aurora Replicas in the same AWS Region share the same underlying storage as the primary instance

Amazon RDS will automatically detect a problem with your primary instance and trigger a failover. If you are using the Cluster Endpoint, your read/write connections will be automatically redirected to an Amazon Aurora Replica that will be promoted to primary.

Aurora Parallel Query

No changes in query syntax are required.
The query optimizer will automatically decide whether to use PQ for your specific query.

may incur higher IO costs