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?

已提問 2 年前檢視次數 2996 次
2 個答案
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
已回答 2 年前
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
已回答 3 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南