Menu
How to change the parameter group of an AWS RDS instance?
I've created a new parameter group. So now I have default and my new one.
In RDS Dashboard > Instances, on my instance under configuration details I see that default group is selected.
But don't see anywhere to edit the group on the instance. Clicking the group under configuration details loads the parameter group page.
This entire article never actually mentions how to change the group on the instance. http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html
531
To modify an RDS DB instance configuration, follow these steps: Create a DB parameter group. View the parameter values for a DB parameter group to confirm that the Is Modifiable property is true. Modify the parameters in a DB parameter group.
Modify the default security group, or. Create a new security group (as your have done), then go to the RDS console, click on your database, then choose Instance actions -> Modify and modify the security groups that are associated with the DB instance (add the new security group, remove the default security group)
DB parameter groups act as a container for engine configuration values that are applied to one or more DB instances. A default DB parameter group is created if you make a database instance without specifying a custom DB parameter group.
A DB cluster parameter group acts as a container for engine configuration values that are applied to every DB instance in an Aurora DB cluster. For example, the Aurora shared storage model requires that every DB instance in an Aurora cluster use the same setting for parameters such as innodb_file_per_table .
To change anything like that you click on the RDS instance and then select "Modify". In the Modify screen you can select a different parameter group.
183
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
