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?

gefragt vor 2 Jahren2996 Aufrufe
2 Antworten
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
beantwortet vor 2 Jahren
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
beantwortet vor 3 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen