I encounter one or more of the following issues when attempting to change my Amazon RDS DB instance configuration:
- Errors occur when using commands such as SET to update the DB instance configuration.
- I am unable to update the DB instance configuration by changing parameter values of the parameter group.
- I can change parameter values, but the changes do not take effect.
- 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:
- RDS does not support the use of commands such as SET to update DB instance configuration variables.
- RDS does not support modification of parameter settings for a default DB parameter group.
- RDS supports modification of parameter settings for a customer DB parameter group, but not all modifications take effect immediately.
- 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.
- All RDS DB instance configuration changes must be performed by changing parameter values of the RDS DB parameter group for your DB instance.
- You can modify parameter values in a customer-created DB parameter group only.
- 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.
- 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
What are DB Parameter groups? How are they helpful?
Working with DB Parameter Groups
Modifying Parameters in a DB Parameter Group
Modifying a DB Instance Running the MySQL Database Engine
Modifying a DB Instance Running the Oracle Database Engine
Modifying a DB Instance Running the PostgreSQL Database Engine
Modifying a DB Instance Running the MariaDB Database Engine
Amazon RDS DB Parameter Changes Not Taking Effect
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