hands-on lab

Getting Started with Amazon Aurora Database Engine

Beginner
Up to 1h 30m
5,508
4.6/5
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.

Description

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

About the author

Avatar
Eric Raub, opens in a new tab
Labs Researcher and Developer
Students
12,032
Labs
3

Eric is a Lab Researcher and Developer working to add to Cloud Academy's library of hands-on labs. He is an IT veteran who enjoys the ever-changing landscape of cloud computing. He also relishes live classical music performances, because sometimes engineering is better heard than seen.

Covered topics

Lab steps

Logging In to the Amazon Web Services Console
Creating the Database Cluster
Connecting to the Virtual Machine using EC2 Instance Connect
Using the Aurora Cluster
Failover the Aurora Cluster
Restoring the Aurora Cluster