Win the Data! Hands-on with Amazon Aurora

In this session, learn how to leverage the unique features of the Amazon Aurora platform to build faster, more scalable database applications optimized for the cloud.

Let's get started!

Sign in to the provided AWS account

At the beginning of the workshop you have been provided with a 12-character access code. This access code grants you permission to use a dedicated AWS account for the purposes of this workshop.

Go to https://dashboard.eventengine.run/, enter the access code and click Proceed.

EventEngine Login

On the Team Dashboard, please click AWS Console to log into the AWS Management Console.

EventEngine Dashboard

Click Open Console. For the purposes of this workshop, you will not need to use command line and API access credentials.

EventEngine Open Console

Get the environment parameters

Back on the Team Dashboard web page (browser tab), close the AWS Console Login modal window (shown above) using the x in the top right corner, or the OK button, and scroll down.

You will see a set of parameters that you will need during the labs. The names that appear in the Parameter column here, are referenced directly in the instructions in subsequent labs, using the parameter format: [parameter]. Replace the parameters with the corresponding values where indicated.

Stack Outputs

Start the labs

For your convenience, a lab environment has already been deployed for you. The lab environment contains the following resources:

  1. Two Amazon Aurora database clusters, one running MySQL, the other running PostgreSQL. They are named auroralab-mysql-cluster and auroralab-postgres-cluster. Each DB cluster contains two database instances (with names ending in node-1 and node-2), deployed each in two separate Availability Zones for Multi-AZ high availability. One of the DB instances is a writer (master), the other a reader (read-only replica).
  2. Two EC2-based workstations, one containing the necessary software to complete the Aurora MySQL labs, the other to be used for the Aurora PostgreSQL labs. You will connect to them using AWS Systems Manager - Session Manager, following the instructions provided. You do not need to install any client software on your computer.
  3. Supporting resources and network configuration, including: VPC, subnets, gateways, subnet groups, security groups, IAM roles, credentials stored in an AWS Secrets Manager secret.

Time permitting, you will run the following hands-on labs. Start with connecting to Aurora MySQL.

# Lab Module Recommendation Overview
1 Connect to Aurora MySQL Connect to the DB cluster for the first time and load an initial data set
2 Clone an Aurora DB cluster Clone an Aurora DB cluster and observing the divergence of the data set.
3 Deploy a Global Database Learn how to operate an Aurora Global Database cluster
4 Create a Serverless DB cluster Optional. Connect to your serverless cluster using the RDS Data API and Lambda functions.
5 Use the RDS Data API Optional. Connect to your serverless cluster using the RDS Data API and Lambda functions. Requires the previous lab.
6 Connect to Aurora PostgreSQL Connect to the lab environment for the Aurora PostgreSQL labs.
7 Use Query Plan Management Learn how to use the query plan management features of Aurora PostgreSQL.
8 Set up Database Activity Streams Enable Database Activity Streams, read and process events from the activity stream.