Amazon Aurora is a MySQL-compatible relational database engine available as an Amazon Relational Database Service (RDS) option. Aurora offers up to five times better performance than MySQL with commercial-grade security, availability, and reliability. In this lab you will deploy, load, query, monitor, and failover a multiple Availability Zone (AZ) Aurora database.

Learning Objectives

Upon completion of this lab you will be able to:

• Log in to the AWS Management Console
• Use EC2 Instance Connect to communicate with Aurora
• Create a multi-AZ Aurora database deployment
• Load and query data in Aurora
• Failover an Aurora instance and recover with no data loss

Prerequisites

You should be familiar with:

• Basic understanding of the Linux bash shell
• Conceptual understanding of SQL and databases

Lab Environment

Before completing the lab instructions the environment will look as follows:

After completing the lab instructions the environment should look similar to:

Updates

March 17th, 2023 - Resolved an issue that caused the lab to fail to set up on rare occasions

October 21st, 2022 - Updated step that creates the DB cluster to reflect latest UI

August 31st, 2022 - Updated the instructions and screenshots to reflect the latest UI

May 25th, 2022 - Updated the instructions and screenshots to reflect the latest UI

December 9, 2021 - Updated instructions for clarity and grammar

October 23rd, 2021 - Resolved an issue that caused the database to fail to create in some cases due to service-linked role issue

May 12th, 2020 - Migrated to Instance Connect

September 16th, 2019 - Updated the lab IAM policy to allow the RDS DB instance to be created after recent changes AWS' made to IAM condition processing for creating RDS DB instances

August 19th, 2019 - Increased the duration of the Lab to allow for a better-paced learning environment

June 27th, 2019 - Added a custom validation lab step to check the work performed in the lab

May 13th, 2019 - Updated screenshots and instructions related to the creation of the DB cluster

February 10th, 2019 - Updated the Lab security policy to allow for new IAM permissions in the RDS Console

January 10th, 2019 - Added a validation Lab Step to check the work you perform in the Lab

September 14th, 2018 - Updated instructions and screenshots to match the current Aurora Console interfaces