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
已提问 1 年前497 查看次数
1 回答
0
已接受的回答

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
专家
已回答 1 年前
profile picture
专家
已审核 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则