Function

This API is used to set DB instance parameters.

A parameter template (with same name as the DB instance) will be created if needed.

URI

• URI format

  PATH: /rds/v1/{project_id}/instances/{nodeId}/parameters

  Method: PUT

• Parameter description

  Table 1 Parameter description

  Name	Mandatory	Description
  project_id	Yes	Specifies the project ID of a tenant in a region.
  nodeId	Yes	Specifies the primary node ID of the DB instance. NOTE: This field is not the DB instance ID. You are advised to use API v3 and the DB instance ID to perform related operations.

• Constraints
  • 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 "Modifying Parameters in a Parameter Template" in the Relational Database Service User Guide.
  • Modifying sensitive parameters, for example, lower_case_table_names, may have risks. For details, see Precautions for Modifying MySQL Parameters in the Relational Database User Guide.
  • If a parameter of the primary DB instance is modified, the corresponding parameter of the standby DB instance is modified simultaneously. You cannot modify the parameters of the standby DB instance. You can modify the parameters of read replicas.

Request

• Parameter description

  Table 2 Parameter description

  Name	Type	Description
  values	Dictionary data structure	Specifies the parameter value list. key specifies the parameter name. value specifies the parameter value.

• Request example

  {
      "values": {
           "connect_timeout": 17,
           "sync_binlog": 1
      }
  }

Normal Response

• Parameter description

  Table 3 Parameter description

  Name	Type	Description
  shouldRestart	String	Indicates whether the parameter needs to be restarted for the modifications to take effect. The value 1 indicates that the parameter needs to be restarted for the modifications to take effect. The value 0 indicates that the parameter does not need to be restarted for the modifications to take effect
  setParameteResult	String	Indicates the parameter modification result. The value 1 indicates that the modifications are successful on the primary DB instance but failed on the standby DB instance. 0 indicates that the modifications are successful on every DB instance.

• Response example

  { 
       "shouldRestart": "0",
       "setParameteResult": "0" 
  }

Abnormal Response

For details, see Abnormal Request Results.