How do I modify the values of an Amazon RDS DB parameter group?

Short description

You can modify parameter values in a custom DB parameter group. However, you can't change the parameter values in a default DB parameter group. If you're experiencing an issue when you modify the value of a DB parameter group, review the following common issues:

• SET commands can't be used to update RDS DB instance configurations. For more information, see SET Statements on the MySQL website.
• You can't change the values of a default RDS DB parameter group.
• If your changes aren't in effect, then it might be because not all modifications are applied immediately.
• If you can't modify DB parameters under any circumstances, then it might be because the parameter's property value for Is Modifiable is false.

For more information, see DB parameter groups for Amazon RDS DB instances.

Resolution

To change an RDS DB instance configuration, you must change the parameter values of the DB parameter group for your RDS DB instance. To modify an RDS DB instance configuration, complete the following steps:

1. Create a DB parameter group.
2. View the parameter values for a DB parameter group to confirm that the Is Modifiable property is true.
3. Modify the parameters in a DB parameter group.

After the custom DB parameter group is applied, the DB parameter group status for that instance changes to Pending reboot in the Amazon RDS console. This means that the parameter group is applied, but the parameter changes aren't applied yet. After a manual reboot of the RDS DB instance, the parameter changes are applied. And the DB parameter group status for the instance changes from Pending reboot to In sync. DB instances require a manual reboot in the following circumstances:

• You replace the current parameter group with a different parameter group.
• You modify and save a static parameter in a custom parameter group.

Static parameter change takes effect after you manually reboot the RDS DB instance. For more information, see Parameter groups for Amazon RDS. A reboot doesn't occur when you modify a dynamic parameter in a custom parameter group. For more information, see Amazon RDS DB parameter changes not taking effect.

Related information

Managing an Amazon Aurora DB cluster