...
/Testing the Multi-AZ RDS Automatic Failover
Testing the Multi-AZ RDS Automatic Failover
Learn to test the automatic failover of the multi-AZ RDS database.
We'll cover the following...
We've converted our RDS database to a multi-AZ deployment. But the only visible outcome of this change was the multi-AZ configuration parameter changing from no to yes.
The underlying EC2 instances used by RDS are also not visible to us, so we don’t know how many EC2 instances are running behind the scenes.
How do we know that the database actually performs a failover in case of a problem? There are a few ways we can test this:
-
We can perform a reboot of the RDS database and check the reported availability zone. It should switch to the failover availability zone after the reboot (because as soon as the primary instance is stopped due to the reboot, the secondary failover, which is located in the secondary AZ, will take its place).
Unfortunately, it can take up to 10 minutes for the availability zone configuration field to reflect the new reality.
