Modifying parameters in a DB parameter group in Amazon RDS
You can modify parameter values in a customer-created DB parameter group; you can't change the parameter values in a default DB parameter group. Changes to parameters in a customer-created DB parameter group are applied to all DB instances that are associated with the DB parameter group.
Changes to some parameters are applied to the DB instance immediately without a reboot. Changes to other parameters are applied only after the DB instance is rebooted. The RDS console shows the status of the DB parameter group associated with a DB instance on the Configuration tab. For example, suppose that the DB instance isn't using the latest changes to its associated DB parameter group. If so, the RDS console shows the DB parameter group with a status of pending-reboot. To apply the latest parameter changes to that DB instance, manually reboot the DB instance.
![Parameter change pending reboot scenario](images/param-reboot.png)
To modify the parameters in a DB parameter group
-
Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/
. -
In the navigation pane, choose Parameter groups.
-
In the list, choose the name of the parameter group that you want to modify.
-
For Parameter group actions, choose Edit.
-
Change the values of the parameters that you want to modify. You can scroll through the parameters using the arrow keys at the top right of the dialog box.
You can't change values in a default parameter group.
-
Choose Save changes.
To modify a DB parameter group, use the Amazon CLI modify-db-parameter-group
command with the following
required options:
-
--db-parameter-group-name
-
--parameters
The following example modifies the max_connections
and
max_allowed_packet
values in the DB parameter group named
mydbparametergroup.
Example
For Linux, macOS, or Unix:
aws rds modify-db-parameter-group \ --db-parameter-group-name
mydbparametergroup
\ --parameters "ParameterName=max_connections
,ParameterValue=250
,ApplyMethod=immediate
" \ "ParameterName=max_allowed_packet
,ParameterValue=1024
,ApplyMethod=immediate
"
For Windows:
aws rds modify-db-parameter-group ^ --db-parameter-group-name
mydbparametergroup
^ --parameters "ParameterName=max_connections
,ParameterValue=250
,ApplyMethod=immediate
" ^ "ParameterName=max_allowed_packet
,ParameterValue=1024
,ApplyMethod=immediate
"
The command produces output like the following:
DBPARAMETERGROUP mydbparametergroup
To modify a DB parameter group, use the RDS API ModifyDBParameterGroup
operation with the following required parameters:
-
DBParameterGroupName
-
Parameters