Migrating RDS MySQL to Aurora with Read Replica

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.

Level

Intermediate

Duration

1 Hours 0 Minutes

Course Objectives

By the end of this lab, you will be able to do the following:

• 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.

Intended Audience

This course is intended for:

Data Engineers

Developers

Infrastructure Engineers

Prerequisites

This lab requires:

• 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.

Course 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