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?

loui
asked 10 months ago470 views
1 Answer
0
Accepted Answer

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
answered 10 months ago
profile picture
EXPERT
reviewed 10 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