Getting Started with Amazon Aurora Database Engine

Beginner

40 students completed the lab in ~42m

Total available time: 1h:10m

Be the first to rate this lab!

Introduction to the High Availability and High Performance Amazon Aurora Database Engine

Lab Overview

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.

Lab Objectives

Upon completion of this lab you will be able to:

  • Log in to the AWS Management Console
  • Connect to an EC2 instance 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

Lab Prerequisites

You should be familiar with:

  • Basic understanding of local operating system and computer use
  • Secure terminal connection software such as Terminal (macOS) or PuTTY (Windows)

Lab Environment

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

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

Follow these steps to learn by building helpful cloud resources

Log In to the Amazon Web Service Console

Your first step to start the Lab experience

Creating the Database Cluster

Create your multi-AZ Amazon Aurora database cluster

Connecting to the Virtual Machine using SSH

Create a secure connection to a remote machine

Using the Aurora Cluster

Load and query your database cluster

Failover the Aurora Cluster

Failover and delete cluster instances to test resilience

Restoring the Aurora Cluster

Create a new database instance and return to high availability

Cleaning up the Environment

Delete the lab resources