I encounter one or more of the following issues when attempting to change my Amazon RDS DB instance configuration:

  1. Errors occur when using commands such as SET to update the DB instance configuration.
  2. I am unable to update the DB instance configuration by changing parameter values of the parameter group.
  3. I can change parameter values, but the changes do not take effect.
  4. Some DB parameter group parameters cannot be modified under any circumstances.

Modification of your Amazon RDS DB instance configuration is subject to the following limitations:

  1. RDS does not support the use of commands such as SET to update DB instance configuration variables.
  2. RDS does not support modification of parameter settings for a default DB parameter group.
  3. RDS supports modification of parameter settings for a customer DB parameter group, but not all modifications take effect immediately.
  4. DB parameter group parameters with an Is Modifiable property value of false cannot be modified under any circumstances.

Follow the steps in Creating a DB Parameter Group and Modifying Parameters in a DB Parameter Group to modify your Amazon RDS DB instance configuration.

  1. All RDS DB instance configuration changes must be performed by changing parameter values of the RDS DB parameter group for your DB instance.
  2. You can modify parameter values in a customer-created DB parameter group only.
  3. Dynamic parameter settings take effect immediately. Static parameter settings take effect only after a graceful reboot of associated DB instances. Failover does not gracefully stop the DB engine and will not apply any changes to static parameter settings. For more information about initiating a graceful reboot, see Amazon RDS DB Parameter Changes Not Taking Effect.
  4. DB parameter group parameters can be modified if the Is Modifiable property of the parameter is true. To determine which parameters can be modified, see Viewing Parameter Values for a DB Parameter Group.

Amazon RDS, parameter group, malformed input, rds-modify-db-parameter-group, RebootDbInstance, SET statement, dynamic, static, pending-reboot, failover, manual reboot required


Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center.

Published: 2015-11-04