will RDS auto create a new instance whenever the primary instance failover in Aurora Cluster?

Question

In my scenario with only 1 instance (writer) in Aurora Cluster which my application does not have any statistics feature that required a read replica and it is kind of waste of money to have a standby backup reader instance, so may I know is there any strategy or configuration that enable auto create instance whenever the writer instance in Aurora Cluster failover?

joahna · Accepted Answer

If the primary instance in a DB cluster using single-master replication fails, Aurora automatically fails over to a new primary instance in one of two ways:
- By promoting an existing Aurora Replica to the new primary instance
- By creating a new primary instance (your scenario)

If the DB cluster doesn't contain any Aurora Replicas, then the primary instance is recreated in the same AZ during a failure event.

If there's an outage that affects an entire AZ and your provisioned or Aurora Serverless v2 cluster only contains a single DB instance, make sure to manually create one or more new DB instances in another AZ.

For more details, you can check the Amazon Aurora User Guide here: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.AuroraHighAvailability.html#Aurora.Managing.FaultTolerance

Pawan · Answer

Hi,

I can not able to add / create secondary region in RDS aurora getting this error. Please help me.
Error:  Your request to create DB instance globa-cluster-instance-1 has failed is in a state which is not valid for physical replication

will RDS auto create a new instance whenever the primary instance failover in Aurora Cluster?

Relevant content