Overview of Labs

Overview of labs

The following labs are currently available, as part of the lab content portal:

# Time Lab Module Recommendation Overview
1 30mins Prerequisites Required, start here Set up the lab environment and provision the prerequisite resources
2 15-25mins Creating a New Aurora Cluster Manually Optional Create a new Amazon Aurora PostgreSQL DB cluster manually
3 50-60mins Fast Cloning Recommended Clone an Aurora DB cluster and observe the divergence of the data set
4 45mins Query Plan Management Recommended Control execution plans for a set of SQL statements that you want to manage
5 45-60mins Cluster Cache Management Recommended Improve the performance of the new primary/writer instance after a DB failover occurs
6 25mins Database Activity Streaming Recommended Monitor Amazon Aurora database activity using Database Activity Streams
7 30-40mins RDS Performance Insights Recommended Examine the performance of your DB instances using RDS Performance Insights
8 30mins Create dataset and Auto Scale Recommended Load test data, run a read-only workload and observe Aurora Auto Scaling in action
9 30-45mins Test Fault Tolerance Recommended Test the high availability and fault tolerance features provided by Amazon Aurora. Use RDS Proxy to minimize failover disruptions.
10 45-60mins Aurora Global Database Recommended Create Aurora global database, monitor and perform DR using managed planned failover and unplanned failover
11 45-60mins Aurora Serverless Recommended Create an Aurora Serverless Cluster and Interact with it using AWS Lambda and RDS Data API
12 30-45 mins Aurora Machine Learning Recommended Integrate Aurora with the Comprehend Sentiment Analysis API and Amazon Sagemaker to make inferences via SQL commands

Lab environment at a glance

To simplify the getting started experience for 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, client-side experience of software packages and components used in the labs.

Generic Architecture

The environment deployed using CloudFormation includes several components:

  • Amazon VPC network configuration with public and private subnets
  • Database subnet group and relevant security groups for the Aurora PostgreSQL cluster and AWS Cloud9 environment
  • AWS Cloud9 configured with the software components needed for the labs
  • IAM roles with cluster permissions for enhanced monitoring, S3 access and logging
  • Custom cluster and DB instance parameter groups for the Amazon Aurora PostgreSQL cluster, enabling some extensions and useful parameters
  • Optionally, Amazon Aurora DB cluster with 2 nodes: a primary/writer and read replica
  • If the cluster is created for you, the master database credentials will be generated automatically and stored in AWS Secrets Manager

Additional software needed for labs

The templates and scripts setting up the lab environment install the following software in the lab environment for assisting with the labs: