Suppose the primary RDS instance dies and it automatically fails over to the standby instance. At that point, do I need to do anything? Or does AWS automatically create a new standby instance, so that the whole situation recovers to the status before the fail over happened?
As far as i am aware , with multi-az AWS RDS , aws keeps a replica instance on the standby mode in another availability zone and fails over by pointing the dns endpoint to the standby instance automatically if the main instance dies. So the failover happens automatically with you having to do nothing much from the aws side. Also aws recovers the unhealthy instance automatically but will NOT failback to the recovered instance. All you need to take care is of that your application adapts to this dns change and automatically re-establishes connections if any connections fail , especially if you are using connection pooling from the app side.