How actually rds parameter group is updated with multiaz failover reboot

0

Based on this document https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RebootInstance.html

Trying to exactly understand what actually happens like the basic case below:

  1. There is a none microsoft mysql rds instance, with multiaz enabled and default parameter group
  2. Then change the default parameter group of the instance to the new custom parameter group, with pending reboot
  3. Then manually reboot the instance, in order to apply the new parameter group

According to the document, the following process would be:

  1. the secondary, standby replica becomes the new primary instance

  2. the previous primary instance becomes the new secondary, then reboot starts

  3. the new secondary(the previous primary instance) is the one that rebooted, so I can assume that the new parameter group should be applied.

  4. But the current primary instance, which has just become the primary from the secondary, didn't get a chance to be rebooted, hence doubt if the new parameter group is actually applied on it

But checking the console, the status of the parameter group is shown as in-use. How could this be?

1 réponse
0
Réponse acceptée

Please note only reboot with failover results in the scenario that you have explained. And you are correct that the parameter group might not have been updated for multi-AZ instances when you invoke a reboot with failover. For reboot without failover, both the primary and secondary DB instances reboot, and parameters are updated after the reboot. Perhaps this is what you have done, and hence see the parameter group applied to primary. In any case, what I would recommend is, for applying the parameter group change for a multi-AZ RDS, always reboot without failover.

profile pictureAWS
EXPERT
répondu il y a un an
profile picture
EXPERT
vérifié il y a un an

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