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.