Aurora

Amazon Aurora is a fully managed, high-performance database engine compatible with both MySQL and PostgreSQL. With Aurora, you can achieve up to five times the throughput of MySQL and three times that of PostgreSQL, making it an ideal drop-in replacement that delivers superior performance.

Aurora’s enhanced performance is powered by its distributed, fault-tolerant, and self-healing storage system. By replicating data six times across three availability zones (AZs)—with two copies in each AZ—Aurora ensures high availability and durability. Although Aurora comes at a higher price point compared to standard RDS instances, it significantly simplifies database management by automating routine administrative tasks without the need to modify your database drivers or tooling.

When examining a typical application architecture, a user request is initially directed to an EC2 instance hosting your application. The application then interacts with an Aurora database to process the query and return the result through the same pathway.

Aurora continuously monitors the cluster's health. If the primary instance becomes unresponsive or encounters an issue, the system automatically promotes one of the replicas to primary, ensuring minimal disruption to application performance.

The cluster volume in Aurora is designed as a distributed and redundant storage solution spanning multiple AZs. Managed automatically by Aurora, this storage dynamically scales up to 128 terabytes as your data grows. Additionally, the self-healing storage continuously scans for and repairs any faulty disks or corrupted data blocks, leveraging SSDs and cross-AZ replication to maintain high durability even during an AZ failure.

Aurora provides multiple DNS endpoints to help efficiently route queries within the database cluster:

• Cluster/Writer Endpoint: Handles all write operations.
• Reader Endpoint: Distributes read operations across all available replicas.
• Custom Endpoints: Allow you to group instances with unique performance characteristics, such as those optimized for memory-intensive read operations.

These endpoints ensure that your application can quickly and efficiently perform the appropriate database operations.

Key Features of Amazon Aurora

• Up to five times the throughput of MySQL and three times that of PostgreSQL.
• Data is replicated across three availability zones with six copies maintained.
• A single primary instance manages all writes, complemented by up to 15 read-only replicas.
• A distributed, self-healing cluster volume that scales dynamically up to 128 terabytes.
• Multiple DNS endpoints to optimize read and write operations.