Deploying an Amazon RDS Multi-AZ and Read Replica

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Enable Multi-AZ Deployment

Enable multi-AZ deployment on the primary RDS database.

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

Create a read replica of the RDS database.

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

Promote the read replica to be the primary database. In addition, you need to alter the CNAME DNS record set in Route 53 to now point to the new primary database’s 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.