Deploying an Amazon RDS Multi-AZ and Read Replica

1.5 hours
  • 3 Learning Objectives

About this Hands-on Lab

Welcome to this live hands-on AWS lab, where we will be working with the Relational Database Service (RDS).

**NOTE:** This lab may take 10-15 minutes to provision.

This lab will provide you with hands-on experience with:

– Enabling Multi-AZ and backups
– Creating a read replica
– Promoting a read replica
– Updating the RDS endpoint in Route 53

Multi-AZ and read replicas serve different purposes with RDS. Multi-AZ is strictly for failover, as the standby instances cannot be read from by an application. Read replicas are used for improved performance and migrations. With read replicas, you can write to the primary database and read from the read replica. Because a read replica can be promoted to be the primary database, it makes for a great tool in disaster recovery and migrations.

Good luck, and enjoy the hands-on lab!

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Enable Multi-AZ Deployment
  1. Navigate to EC2 > Load Balancers.
  2. Copy the DNS name of the load balancer.
  3. Open a new browser tab, and enter the DNS name. We will use this web page to test failovers and promotions in this lab.
  4. Navigate to RDS > Databases.
  5. Click on our database instance.
  6. Click Modify.
  7. Click Yes for Multi-AZ deployment.
  8. Change Backup Retention to 1 day, needed later for read replicas.
  9. Click Continue.
  10. Click Apply immediately, and then Modify DB Instance.
  11. Once the instance shows Multi-AZ is enabled, reboot the primary.
  12. Use the web page to monitor the outage (normally about 30 seconds).
  13. The Multi-AZ standby is now the primary.
Create a Read Replica
  1. Check the circle beside the database instance.
  2. Click Actions.
  3. Choose Create read replica.
  4. Choose US East (N. Virginia) for destination region.
  5. Enter a name.
  6. Choose Create read replica.
Promote the Read Replica and Change the CNAME Records Set in Route 53 to the New Endpoint
  1. Once the read replica is available, check the circle next to it.
  2. Click Actions.
  3. Choose Promote.
  4. Click Continue, and then Promote Read Replica.
  5. Use the web page to monitor for downtime.
  6. Once the read replica is available, copy the endpoint.
  7. Open Route 53 in a new tab.
  8. Edit the database.sysopsdatabase.com record to use the read replica endpoint.
  9. Monitor using the web page for downtime.

Additional Resources

Please go ahead and log in to the live environment with the cloud_user credentials provided.

Make sure you are using us-east-1 as your region throughout the lab.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?