AWS — Amazon Aurora Overview
What is Amazon Aurora? — Introduction to Amazon Aurora.
TL;DR
Amazon Aurora is a fully managed MySQL and PostgreSQL-compatible relational database built for the cloud that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.
Two types of DB instances make up an Aurora DB cluster:
Primary Instance — Supports read and write operations, and performs all of the data modifications to the cluster volume. Each Aurora DB cluster has one primary DB instance.
Replica Instances— Connects to the same storage volume as the primary DB instance and supports only read operations. Each Aurora DB cluster can have up to 15 Aurora Replicas in addition to the primary DB instance.
Key Points
- Amazon Aurora architecture gives separation of storage and compute.
- Automatic failover to reader instance — When a problem affects the primary instance, one of these reader instances takes over as the primary instance.
- Cluster endpoint always represents the current primary instance in the cluster. To use a connection string that stays the same even when a failover promotes a new primary instance, you connect to the cluster…