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?

demandé il y a 2 ans2996 vues
2 réponses
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
répondu il y a 2 ans
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
répondu il y a 3 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions