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.
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.
Access
public
Parameters
Parameter |
Type |
Required |
Description |
---|---|---|---|
|
Required |
The name of the DB Parameter Group. Constraints:
|
|
|
Required |
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): 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.
|
|
|
Optional |
An associative array of parameters that can have the following keys:
|
Returns
Type |
Description |
---|---|
A |
Examples
Modify database parameter group values.
// Instantiate the class $rds = new AmazonRDS(); $response = $rds->modify_db_parameter_group('myParamGroup', array( array('ParameterName' => 'max_user_connections', 'ParameterValue' => '24', 'ApplyMethod' => 'pending-reboot'), array('ParameterName' => 'max_allowed_packet', 'ParameterValue' => '1024', 'ApplyMethod' => 'immediate'), )); // Success? var_dump($response->isOK());Result:
bool(true)
Related Methods
Source
Method defined in services/rds.class.php | Toggle source view (12 lines) | View on GitHub