Snowcrash
Snowcrash

Reputation: 86297

RDS Parameter groups - dynamic and static

What's an example of a dynamic parameter vs a static parameter as mentioned here?

Here are some important points you should know about working with parameters in a DB parameter group:

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

Upvotes: 7

Views: 7619

Answers (2)

shiraev
shiraev

Reputation: 21

In addition to what @Michael - sqlbot said (I can't comment, tried to edit but was justifiably rejected)

This label represents -

ApplyType -> (string)

Specifies the engine specific parameters type.

https://docs.aws.amazon.com/cli/latest/reference/rds/describe-db-parameters.html#output:~:text=value.-,ApplyType

Upvotes: 1

Michael - sqlbot
Michael - sqlbot

Reputation: 179284

Open up and look at a parameter group in the console, or use aws rds describe-db-parameters, as documented on link you provided.

Each parameter is labeled as being static or dynamic, in both of these places.

Upvotes: 5

Related Questions