This lab provides you with hands-on experience in implementing a high-availability Amazon RDS MySQL database using Multi-AZ configuration. You'll set up secure connectivity, manage database objects, and test failover scenarios, gaining practical skills in production-grade database disaster recovery on AWS.
Objectives
- Deploy an Amazon RDS MySQL database instance with Multi-AZ configuration.
- Establish secure connectivity between Amazon EC2 and Amazon RDS.
- Create and manage database objects in RDS MySQL.
- Implement and verify Multi-AZ failover procedures.
Prerequisites
- To successfully complete this lab, you should be familiar with basic navigation of the AWS Management Console, and be comfortable running commands on a Linux command line.
Outline
Task 1: Create an Amazon RDS Instance
Task 2: Connect to your RDS database from EC2
Task 3: Create database objects in your RDS database
Task 4: Test Multi-AZ failover for your RDS database