
Amazon Aurora Lab
Amazon Aurora Lab is a deeper dive into the Amazon Aurora service, use cases, architecture, features, and hands on labs.
Example Agenda
We created a sample agenda to help you plan, run, and follow up your Labs Day to ensure your event is successful. It can take 2-3 weeks to prepare, so please plan accordingly!
09:00
Welcome & Intros
15 min
Let's get started with AWS!
09:15
Introduction and Aurora Fundamentals
60 min
Introduction to Amazon Aurora and where it fits in the broader AWS service offering. Deep dive into the innovative architecture of the Aurora database service, covering data storage and durability, connectivity and service components.
10:15
Lab - Getting Started (PostgreSQL)
30 min
Getting started with Postgre SQL
10:45
Lab - Create a new Amazon Aurora PostgreSQL DB cluster manually (PostgreSQL)
30 min
Create a new Amazon Aurora PostgreSQL DB cluster manually. Connect to Aurora instance using a psql utility installed on a bastion instance.
11:15
Break
15 min
Take a minute to relax...
11:30
Management and Monitoring (MySQL & PostgreSQL)
60 min
Learn about the operational aspects of Aurora, how to manage Aurora clusters, the features and configuration controls available, and how to monitor aurora clusters and the monitoring features provided by the platform. This topic also covers Aurora Serverless, Performance Insights, Database Activity Streams, cloning, patching and upgrades.
12:30
Lunch
30 min
Enjoy your meal!
13:00
Lab - Clone an Aurora DB cluster and observe the divergence of the data and performance impact (PostgreSQL)
45 min
Clone an Aurora PostgreSQL cluster and verify the data divergence. Use pgbench workload to test the performance impact of cloning.
13:45
Lab - Use Performance Insights (PostgreSQL)
30 min
Examine the performance of your DB instances using RDS Performance Insights
14:15
HA/DR with Amazon Aurora (MySQL & PostgreSQL)
45 min
Learn about the high availability capabilities of Aurora, how failure recovery works, backup and DR options, and connection management best practices. Additionally this topic covers Cluster Cache Management, Aurora Global Database, and RDS Proxy
15:00
Break
15 min
Take a minute to relax...
15:15
Lab - Test Fault Tolerance (PostgreSQL)
45 min
Test the high availability and fault tolerance features provided by Amazon Aurora. Use RDS Proxy to minimize failover disruptions.
16:00
Performance Features and Optimization (MySQL & PostgreSQL)
30 min
Learn about the performance capabilities of the platform and the performance features and optimizations that AWS has built into Amazon Aurora that are unique to the platform, and do not exist in the open source engines.
16:30
Lab - Explore Aurora's query plan management feature for plan stability (PostgreSQL)
45 min
Learn QPM feature including plan capture, plan adaptability and plan management in Aurora PostgreSQL.
17:15
Conclusion & Next Steps
15 min
Here are some resources for you until next time...
