Modifying Parameters in a Parameter Template

Function

This API is used to modify parameters in a specified parameter template, including the parameter names, descriptions, and values.

URI

  • URI format

    PATH: /v1.0/{project_id}/configurations/{id}

    Method: PUT

  • Parameter description

    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    Specifies the project ID of a tenant in a region.

    id

    Yes

    Specifies the parameter template ID.

  • Restrictions

    • The modified parameter template name must be different from the name of an existing or a default parameter template. Default parameter templates cannot be modified.

    • Currently, the DB engines MySQL and PostgreSQL support modifying parameter templates.

    • The values of the edited parameters must be within the default value range of the specified database version. For details about the range of parameter values, see section "Modifying Parameters in a Parameter template " in the Relational Database Service User Guide.

    • Parameter template modifications will take effect for DB instances to which the parameter template applies. Some modifications take effect only after the DB instance reboots.

Request

  • Parameter description

    Table 2 Parameter description

    Name

    Mandatory

    Type

    Description

    configuration

    Yes

    Dictionary data structure. For details, see Table 3.

    Specifies the parameter template object.

    Table 3 configuration field data structure description

    Name

    Mandatory

    Type

    Description

    name

    No

    String

    Specifies the parameter template name. It contains a maximum of 64 characters and can contain only uppercase letters, lowercase letters, digits, hyphens (-), underscores (_), and periods (.).

    description

    No

    String

    Specifies the parameter template description. It contains a maximum of 256 characters and does not support the following special characters: !<>='&"

    values

    No

    Dictionary data structure. For details, see Table 4.

    Specifies the parameter values defined by users based on the default parameter template.

    Table 4 values field data structure description

    Name

    Mandatory

    Type

    Description

    key

    No

    String

    Specifies the parameter name. For example, in "max_connections": "10", the key is max_connections.

    value

    No

    String

    Specifies the parameter value. For example, in "max_connections": "10", the value is 10.

  • Request example

    {
      "configuration": {
        "name": "configuration_test",
        "description": "configuration_test",
        "values": {
           "max_connections": "10",
           "autocommit": "OFF"
        }
      }
    }
    

Normal Response

{
  "errCode": "RDS.0041",
  "externalMessage": "Operation accepted success."
}

Abnormal Response

For details, see Abnormal Request Results.