Lab - Migrating RDS MySQL to Aurora with Read Replica (Assessment Version)

Languages Available: Español (Latinoamérica) | Français | 日本語 | 한국어 | Português (Brasil)

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