This lab gives learners the opportunity to perform a migration from a standard Amazon Relational Database Service (Amazon RDS) MySQL platform to an Amazon Aurora MySQL cluster with even more robust high availability features.
In contrast to a standard lab. an Assessment Version of a lab provides high-level instructions with hints to implement the lab objectives and learners can use the 'Check score' functionality to validate their progress. Learners also have the option of detailed instructions to complete the lab.
Objectives
- Create an Aurora read replica cluster.
- Promote the Aurora read replica cluster to a standalone DB cluster.
- Add an additional reader instance to the cluster with highest failover priority.
- Perform a “failover” on the cluster.
Prerequisites
- A basic knowledge of AWS services as defined in the AWS Cloud Practitioner Essentials course.
- That you should be comfortable with navigating the AWS Management Console.
- A good understanding of SQL databases and running simple SQL queries.
Outline
Task 1: Explore the lab environment and connect to the database
Task 2: Create an Aurora read replica cluster
Task 3 Promote the Aurora read replica cluster to a standalone DB cluster
Task 4 Add an additional reader instance to the Aurora cluster with highest failover priority
Task 5 Perform a "failover" on the cluster