Ready for the real environment experience?
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.
Upon completion of this lab you will be able to:
- Log in to the AWS Management Console
- Use EC2 Instance Connect 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
You should be familiar with:
- Basic understanding of the Linux bash shell
- Conceptual understanding of SQL and databases
Before completing the lab instructions the environment will look as follows:
After completing the lab instructions the environment should look similar to:
May 12th, 2020 - Migrated to Instance Connect
September 16th, 2019 - Updated the lab IAM policy to allow the RDS DB instance to be created after recent changes AWS' made to IAM condition processing for creating RDS DB instances
August 19th, 2019 - Increased the duration of the Lab to allow for a better-paced learning environment
June 27th, 2019 - Added a custom validation lab step to check the work performed in the lab
May 13th, 2019 - Updated screenshots and instructions related to the creation of the DB cluster
February 10th, 2019 - Updated the Lab security policy to allow for new IAM permissions in the RDS Console
January 10th, 2019 - Added a validation Lab Step to check the work you perform in the Lab
September 14th, 2018 - Updated instructions and screenshots to match the current Aurora Console interfaces
Eric is a Lab Researcher and Developer working to add to Cloud Academy's library of hands-on labs. He is an IT veteran who enjoys the ever-changing landscape of cloud computing. He also relishes live classical music performances, because sometimes engineering is better heard than seen.