How to failback to Original Writer instance after Upgrade

0

Currently i have 1 writer and 2 reader instance in AuroraDB. When I was trying to change the instance write instance type to larger instance, aurora automatically promoted a reader instance to writer. But after the upgrade finish, the original writer instance stayed as reader instance. Is there a way to have a automatic failback to the original writer after the upgrade is completed?

asked 2 years ago2939 views
2 Answers
0

Unfortunately, no. The upgrade is designed to failover first to reduce downtime. The readers and write should be on the similar instance class in Aurora cluster. You can try either of these:

  • Upgrade your new writer now, which would automatically failover to give your original configuration with both instances to new instance sizing.
  • Manually failover the cluster to switch the configuration from console, CLI or API call, and then you can upgrade reader without a failover.
AWS
answered 2 years ago
0

Note that when you perform a manual failover, you can specify which instance to fail over to, although specifying the instance ID is optional:

https://docs.aws.amazon.com/cli/latest/reference/rds/failover-db-cluster.html

What I like to do for Aurora clusters with >2 instances is put 2 of them in priority tier 0, and all the others in some other priority tier (2-15). That way, all the failovers default to switching between those 2 instances in the top priority tier and there's no worry about some other instance with a too-low capacity, wrong AZ, etc. being promoted to the writer.

johrss
answered 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions