Setting up AWS RDS in high availability mode

In this section, we will see how to create a MySQL database in AWS RDS across multiple Availability Zones. AWS RDS provides high availability and failover support for database instances using Multi-AZ deployments. In a Multi-AZ deployment, AWS RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone. The primary database synchronously replicates data across the Availability Zone to provide data redundancy and high availability in case of failure.

We need to follow this series of steps to do so:

1. Go to the AWS management console at https://console.aws.amazon.com/console/home and click on RDS under Database:
   

   Figure 7.1 – AWS RDS

2. In the next step, we will create a MySQL database instance by selecting Create database:
   

   Figure 7.2 – Creating an RDS database

3. In the next section, keep all the values as their defaults (Standard Create and Edition), select the MySQL icon...