Module 8 - Section 4

Amazon Aurora

Amazon Aurora

a MySQL- and PostgreSQL-compatible relational database that is built for the cloud. It combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases

Amazon Aurora

Using ___ can reduce your database costs while improving the reliability and availability of the database

fully managed service

As a __, Aurora is designed to automate time-consuming tasks like provisioning, patching, backup, recovery, failure detection, and repair.

Enterprise-class relational database

Compatible with MySQL or PostgreSQL

Automate time-consuming tasks (such as provisioning, patching, backup, recovery, failure detection, and repair).

Amazon Aurora features (?):

• provisioning

• patching

• backup

• recovery

• failure detection

• repair

Amazon Aurora automates time-consuming tasks, such as:

• managed service

• pay-as-you-go

• fast and available

• simple

• compatible

Amazon Aurora service benefits:

drop-in compatibility

Amazon Aurora is designed to have ___ with MySQL and PostgreSQL database engines so that you can use most of your existing database tools with little or no change.

pay-as-you-go

Amazon Aurora is a ___ service

AWS Database Migration Service (AWS DMS), AWS Schema Conversion Tool

Aurora is a managed service that integrates with features such as ___ and the ___. These features are designed to help you move your dataset into Amazon Aurora.

highly available

Amazon Aurora is designed to be ___: it stores multiple copies of your data across multiple Availability Zones with continuous backups to Amazon S3

15 read replicas

Amazon Aurora can use up to ___ can be used to reduce the possibility of losing your data.

instant crash recovery

Amazon Aurora is designed for ___ if your primary database becomes unhealthy.

redo log

After a database crash, Amazon Aurora does not need to replay the ___ from the last database checkpoint. Instead, it performs this on every read operation. This reduces the restart time after a database crash to less than 60 seconds in most cases.

buffer cache

With Amazon Aurora, the ___ is moved out of the database process, which makes it available immediately at restart. This reduces the need for you to throttle access until the cache is repopulated to avoid brownouts.