If I modify a DB Instance or the DB parameter group associated with the instance, should I reboot the instance
for the changes to take effect?
A.
No
B.
Yes
If I modify a DB Instance or the DB parameter group associated with the instance, should I reboot the instance for the changes to take effect?
If I modify a DB Instance or the DB parameter group associated with the instance, should I reboot the instance
for the changes to take effect?
When you change a dynamic parameter and save the DB parameter group, the change is applied immediately regardless of the Apply Immediately setting. When you change a static parameter and save the DB parameter group, the parameter change will take effect after you manually reboot the DB instance.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html
yes
When you change the DB parameter group associated with a DB instance, you must manually reboot the instance before the new DB parameter group is used by the DB instance.
Answer : Yes – B
B
When you change a dynamic parameter and save the DB parameter group, the change is applied immediately regardless of the Apply Immediately setting. When you change a static parameter and save the DB parameter group, the parameter change will take effect after you manually reboot the DB instance
looks like both are right. What is the logic to choose B ?
They ommitted the key information about whether the change is for a dynamic or static parameter. I don’t understand testing with questions where you could justify your response with an example in either direction.
B.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.DBInstance.Modifying.html
Most modifications to a DB instance can be applied immediately or applied during the next maintenance window. Some modifications, such as parameter group changes, require that you manually reboot your DB instance for the change to take effect. Some modifications result in an outage because Amazon RDS must reboot your DB instance for the change to take effect.
Note
When you modify some DB instance settings, an outage occurs because the DB instance is rebooted. Review the impact to your database and applications before modifying your DB instance settings.
So, I think in general, you need to either manually reboot the instance or apply the changes immediately which means an instance reboot.
B
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.DBInstance.Modifying.html
Most modifications to a DB instance can be applied immediately or applied during the next maintenance window. Some modifications, such as parameter group changes, require that you manually reboot your DB instance for the change to take effect. Some modifications result in an outage because Amazon RDS must reboot your DB instance for the change to take effect.
B.
Yes
Answer is A. Big NO as I do this daily. You do not have to reboot the instance. You can set it to happen during maintenance window or tick thge “apply immediately” check box and the modification will be applied immediately without reboot.
From Duck Bro’s link, you have to reboot the instance for modification such as parameter group to take effect, but I have not personally rebooted any instance when I make these changes . I apply immediately and when I check the instance, the new parameter group is applied. So not sure which is the correct answer now A or B
its “B”
if the DB instance is not using the latest changes to its associated DB parameter group, the RDS console shows the DB parameter group with a status of pending-reboot. You would need to manually reboot the DB instance for the latest parameter changes to take effect for that DB instance.