In this hands-on lab, we will work with Relational Database Service (RDS). This lab will provide you with hands-on experience with enabling Multi-AZ and backups, creating a read replica, promoting a read replica, and 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. (**Note:** This lab may take 10-15 minutes to provision.)
Successfully complete this lab by achieving the following learning objectives:
- Enable Multi-AZ Deployment
Enable multi-AZ deployment on the primary RDS database.
- Create a Read Replica
Create a read replica of the RDS database.
- 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.