Amazon Aurora Labs for MySQL

Welcome to the AWS workshop and lab content portal for Amazon Aurora MySQL compatible databases! Here you will find a collection of workshops and other hands-on content aimed at helping you gain an understanding of the Amazon Aurora features and capabilities.

The resources on this site include a collection of easy to follow instructions with examples, templates to help you get started and scripts automating tasks supporting the hands-on labs. These resources are focused on helping you discover how advanced features of the Amazon Aurora MySQL database operate. Prior expertise with AWS and MySQL-based databases is beneficial, but not required to complete the labs.

Overview of labs

The following labs are currently available:

Prerequisites

You will need to complete the following prerequisites before running any other labs. Do this first!

# Lab Module Recommendation Overview
1 Get started using the lab environment Required, start here Set up the lab environment and provision the prerequisite resources.
2 Connect to the Session Manager workstation Required Connect to the EC2 based workstation using Session Manager, so you can interact with the database.
Labs for Aurora Provisioned DB clusters
# Lab Module Recommendation Overview
1 Create a New DB Cluster Optional Create a new Amazon Aurora MySQL DB cluster manually. This is optional, as you can also deploy the environment with a cluster provisioned automatically for you.
2 Connect, Load Data and Auto Scale Recommended Connect to the DB cluster, load an initial data set from S3 and test read replica auto scaling. The initial data set may be used in subsequent labs.
3 Clone a DB Cluster Recommended Clone an Aurora DB cluster and observing the divergence of the data set.
4 Backtrack a DB Cluster Recommended Backtrack an Aurora DB cluster to fix an accidental DDL operation.
5 Use Performance Insights Recommended Examine the performance of your DB instances using RDS Performance Insights.
6 Test Fault Tolerance Recommended Examine the failover process in Amazon Aurora MySQL and how it can be optimized.
Labs for Aurora Serverless DB clusters
# Lab Module Recommendation Overview
1 Create an Aurora Serverless DB cluster Required Create a new Amazon Aurora Serverless MySQL DB cluster manually.
2 Use Aurora Serverless with AWS Lambda functions Recommended Connect to your DB cluster using the RDS Data API and Lambda functions.
Aurora Global Database Workshop
# Lab Module Recommendation Overview
1 Create Infrastructure Required Create a multi-region environment to use with Aurora Global Database.
2 Create Global Database Recommended Create a Global Database which will span across multiple regions.
3 Connect Application Recommended Connect a Business Intelligence application to the global database.
4 Monitor Latency Recommended Create an Amazon CloudWatch Dashboard to monitor the latency, replicated IO and the cross region replication data transfer of the global database.
5 Failover Recommended Simulate a regional failure and DR scenario.
6 Failback Optional Fail back to the original primary region.
Machine Learning with Amazon Aurora
# Lab Module Recommendation Overview
1 Overview and Prerequisites Required Setup a sample schema and data for machine learning integration.
2 Use Comprehend with Aurora Recommended Integrate Aurora with the Comprehend Sentiment Analysis API and make sentiment analysis inferences via SQL commands.
3 Use SageMaker with Aurora Recommended Integrate Aurora with SageMaker Endpoints to infer customer churn in a data set using SQL commands.
4 Cleanup Lab Resources Recommended Clean up after the labs and remove unneeded AWS resources.

You can also discover exercises, labs and workshops related to Amazon Aurora on the Related Labs and Workshops page.

Lab environment at a glance

To simplify the getting started experience with the labs, we have created foundational templates for AWS CloudFormation that provision the resources needed for the lab environment. These templates are designed to deploy a consistent networking infrastructure, and client-side experience of software packages and components used in the lab.

The environment deployed using CloudFormation includes several components:

Additional software needed for labs

You do not need any special software on the computer you are using for these labs, except an up to date web browser. The templates and scripts setting up the lab environment install the following software in the lab environment for the purposes of deploying and running the labs:

  • mysql-client package. MySQL open source software is provided under the GPL License.
  • sysbench available using the GPL License.
  • test_db available using the Creative Commons Attribution-Share Alike 3.0 Unported License.
  • Percona's sysbench-tpcc available using the Apache License 2.0.