3 Amazon Aurora in Practice Free Online FlashCards

What is Amazon Aurora?

Amazon Aurora is a managed relational database engine in Amazon RDS, with MySQL-compatible and PostgreSQL-compatible editions.

How are Aurora compute and storage organized?

An Aurora cluster combines database instances with a shared cluster volume, so readers do not each need a full separate copy of the database.

What does the Aurora writer instance do?

The writer instance handles database reads and writes.

What roles can Aurora reader instances serve?

Reader instances handle read-only work and can be promoted to writer after a failure.

How is Aurora storage distributed within a Region?

Aurora replicates storage across six storage nodes in three Availability Zones within one Region.

Which Aurora endpoint should applications use for writes?

Use the cluster (writer) endpoint for writes; it follows the current writer after failover.

What is the reader endpoint for?

Use the reader endpoint for read-only connections; it distributes connections among available readers.

What should be checked before migrating to Aurora?

Compatibility is substantial, not identical. Test required features, extensions, versions, drivers, and application assumptions against the specific Aurora version.

How can a provisioned Aurora cluster scale compute vertically?

For provisioned clusters, changing the writer or reader instance size is a vertical compute-scaling option.

What does adding Aurora Replicas scale?

Adding Aurora Replicas can scale read throughput, up to 15 replicas per cluster. It does not scale writes; the writer remains responsible for changes.

How does Aurora Serverless v2 respond to variable compute demand?

Aurora Serverless v2 adjusts each serverless writer or reader’s capacity within a configured range to accommodate variable compute demand.

How does Aurora storage scale as data grows?

The cluster volume grows as data grows, without pre-provisioning a fixed volume size. Maximum capacity depends on engine version.