AWS RDS Multi-AZ
Welcome to CloudAffaire and this is Debjeet.
In the last blog post, we have discussed AWS RDS Read Replica.
In this blog post, we will discuss AWS RDS Multi-AZ.
Amazon RDS provides high availability and failover support for DB instances using Multi-AZ deployments. Amazon RDS uses several different technologies to provide failover support. Multi-AZ deployments for Oracle, PostgreSQL, MySQL, and MariaDB DB instances use Amazon’s failover technology. SQL Server DB instances use SQL Server Database Mirroring.
In a Multi-AZ deployment, Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone. The primary DB instance is synchronously replicated across Availability Zones to a standby replica to provide data redundancy, eliminate I/O freezes, and minimize latency spikes during system backups. Using the RDS console, you can create a Multi-AZ deployment by simply specifying Multi-AZ when creating a DB instance. You can also use the console to convert existing DB instances to Multi-AZ deployments by modifying the DB instance and specifying the Multi-AZ option.
In the event of a planned or unplanned outage of your DB instance, Amazon RDS automatically switches to a standby replica in another Availability Zone if you have enabled Multi-AZ. The time it takes for the failover to complete depends on the database activity and other conditions at the time the primary DB instance became unavailable. The failover mechanism automatically changes the DNS record of the DB instance to point to the standby DB instance. As a result, you need to re-establish any existing connections to your DB instance.
Next, we are going to modify our existing AWS RDS PostgreSQL instance to make it Multi-AZ.
Prerequisite for this demo:
- AWS RDS PostgreSQL instance.
AWS RDS Multi-AZ:
Step 1: Login to AWS console and navigate to ‘RDS’.
Step 2: In the navigation pane, click ‘Databases’, select your RDS instance and click ‘Modify’.
Step 3: Navigate to ‘Instance specifications’ and enable ‘Multi-AZ deployment’ and apply the changes.
We have successfully converted our RDS instance into a Multi-AZ deployment. Next, we will perform a manual failover of our RDS instance.
Step 4: Select your AWS RDS instance and from ‘Actions’ click ‘Reboot’.
Enable ‘Reboot With Failover’ and click ‘Reboot’.
Hope you have enjoyed this article, with this, we are concluding our introductory series on AWS RDS. In the next blog post, we will start with a new AWS service.
To get more details on AWS RDS, please refer below AWS documentation