RDS Failover

Reading time ~1 minute

Our reporting engine is likely to point at a Read Replica of our database so we wondered what happens when the instance fails. Do we have to detect the failure? Do we have to manually find a new instance?

Here’s what I found:

The failover mechanism automatically changes the DNS record of the DB instance to point to the standby DB instance. As a result, you will need to re-establish any existing connections to your DB instance.

This seems to imply that while you may need to reconnect, you don’t have to reconfigure the connection. This also seems to be referencing the primary instance, but I would assume it applies to Read Replicas but I would like to verify with an RDS expert.

Perils of a Family-First Software Developer

I've just survived a RIF, my skills and tool set are built around technologies that were modern 10 years ago, my interviewing skills have...… Continue reading

AWS CodeStar and TypeScript - Part 3

Published on May 28, 2017

AWS CodeStar and TypeScript - Part 2

Published on May 17, 2017