ModifyDBParameterGroup - Amazon Relational Database Service

Description

Modifies the parameters of a DBParameterGroup. To modify more than one parameter submit a list of the following: ParameterName, ParameterValue, and ApplyMethod. A maximum of 20 parameters can be modified in a single request.

	Note
	The `apply-immediate` method can be used only for dynamic parameters; the `pending-reboot` method can be used with MySQL and Oracle DB Instances for either dynamic or static parameters. For Microsoft SQL Server DB Instances, the `pending-reboot` method can be used only for static parameters.

Request Parameters

For information about the common parameters that all actions use, see Common Query Parameters.

Name Description Required

DBParameterGroupName

The name of the DB Parameter Group.

Constraints:

Must be the name of an existing DB Parameter Group
Must be 1 to 255 alphanumeric characters
First character must be a letter
Cannot end with a hyphen or contain two consecutive hyphens

Type: String

Yes

Parameters.member.N

An array of parameter names, values, and the apply method for the parameter update. At least one parameter name, value, and apply method must be supplied; subsequent arguments are optional. A maximum of 20 parameters may be modified in a single request.

Valid Values (for the application method): immediate | pending-reboot

	Note
	You can use the immediate value with dynamic parameters only. You can use the pending-reboot value for both dynamic and static parameters, and changes are applied when DB Instance reboots.

Type: Parameter list

Yes

Response Elements

The following elements come wrapped in a ModifyDBParameterGroupResult structure.

Name Description

Name	Description
`DBParameterGroupName`	The name of the DB Parameter Group. Type: String

DBParameterGroupName

The name of the DB Parameter Group.

Type: String

Errors

For information about the common errors that all actions use, see Common Errors.

Error	Description	HTTP Status Code
`DBParameterGroupNotFound`	DBParameterGroupName does not refer to an existing DB Parameter Group.	404
`InvalidDBParameterGroupState`	The DB Parameter Group cannot be deleted because it is in use.	400

Examples

Sample Request

https://rds.amazonaws.com/
    ?Action=ModifyDBParameterGroup
    &DBParameterGroupName=mydbparametergroup
    &Parameters.member.1.ParameterName=max_user_connections
    &Parameters.member.1.ParameterValue=24
    &Parameters.member.1.ApplyMethod=pending-reboot
    &Parameters.member.2.ParameterName=max_allowed_packet
    &Parameters.member.2.ParameterValue=1024
    &Parameters.member.2.ApplyMethod=immediate
    &Version=2012-04-23
    &SignatureVersion=2
    &SignatureMethod=HmacSHA256
    &Timestamp=2011-05-11T21%3A25%3A00.686Z
    &AWSAccessKeyId=<AWS Access Key ID>
    &Signature=<Signature>

Sample Response

<ModifyDBParameterGroupResponse xmlns="http://rds.amazonaws.com/doc/2012-04-23/">
  <ModifyDBParameterGroupResult>
    <DBParameterGroupName>mydbparametergroup</DBParameterGroupName>
  </ModifyDBParameterGroupResult>
  <ResponseMetadata>
    <RequestId>5ba91f97-bf51-11de-bf60-ef2e377db6f3</RequestId>
  </ResponseMetadata>
</ModifyDBParameterGroupResponse>