Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Change Parameter Group of AWS RDS instance

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

like image 531
Andrew Avatar asked Jun 08 '17 14:06

Andrew


People also ask

How do I change the parameter group in RDS?

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.

Can you change RDS instance security 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)

What is DB parameter group in AWS?

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.

What is a DB cluster 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 .


1 Answers

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.

like image 183
Mark B Avatar answered Oct 29 '22 22:10

Mark B