Obtaining Parameters in a Specified Parameter Template

Function

This API is used to obtain parameters of a specified parameter template.

• Before calling an API, you need to understand the API in Authentication.

• Before calling this API, obtain the required region and endpoint.

URI

• URI format

  GET https://{Endpoint}/v3/{project_id}/configurations/{config_id}

• Parameter description

  Table 1 Parameter description

  Name	Mandatory	Description
  project_id	Yes	Specifies the project ID of a tenant in a region. For details about how to obtain the project ID, see Obtaining a Project ID.
  config_id	Yes	Specifies the parameter template ID. When this parameter is empty (not space), the URL of the parameter template list is obtained. For details, see Obtaining a Parameter Template List.

Request

• Request parameters

  None

• Example

  GET https://rds.eu-de.otc.t-systems.com/v3/0483b6b16e954cb88930a360d2c4e663/configurations/463b4b58-d0e8-4e2b-9560-5dea4552fde9

Response

• Normal response

  Table 2 Parameter description

  Name	Type	Description
  id	String	Indicates the parameter template ID.
  name	String	Indicates the parameter template name.
  datastore_version_name	String	Indicates the database version name.
  datastore_name	String	Indicates the database name.
  description	String	Indicates the parameter template description.
  created	String	Indicates the creation time in the following format: yyyy-MM-ddTHH:mm:ssZ. T is the separator between the calendar and the hourly notation of time. Z indicates the time zone offset.
  updated	String	Indicates the update time in the following format: yyyy-MM-ddTHH:mm:ssZ. T is the separator between the calendar and the hourly notation of time. Z indicates the time zone offset.
  configuration_parameters	Array of objects	Indicates the parameters defined by users based on the default parameter templates. For details, see Table 3.

  Table 3 configuration_parameters field data structure description

  Name	Type	Description
  name	String	Indicates the parameter name.
  value	String	Indicates the parameter value.
  restart_required	Boolean	Indicates whether a restart is required. false indicates that a restart is not required. true indicates that a restart is required.
  readonly	Boolean	Indicates whether the parameter is read-only. false: The parameter is not read-only. true: The parameter is read-only.
  value_range	String	Indicates the parameter value range. For example, the value of integer is 0-1, and the value of boolean is true or false.
  type	String	Indicates the parameter type, which can be integer, string, boolean, list, or float.
  description	String	Indicates the parameter description.

• Example normal response

  {
      "id": "07fc12a8e0e94df7a3fcf53d0b5e1605pr01",
      "name": "default-mysql-5.6",
      "datastore_version_name": "5.6",
      "datastore_name": "mysql",
      "description": "Default parameter group for mysql 5.6",
      "created": "2017-05-05T04:40:51+0800",
      "updated": "2017-05-05T04:40:51+0800",
      "configuration_parameters": [
        {
          "name": "auto_increment_increment",
          "value": "1",
          "restart_required": false,
          "readonly": true,
          "value_range": "1-65535",
          "type": "integer",
          "description": "auto_increment_increment and auto_increment_offset are intended for use with master-to-master replication, and can be used to control the operation of AUTO_INCREMENT columns."
        },
        {
          "name": "autocommit",
          "value": "ON",
          "restart_required": false,
          "readonly": true,
          "value_range": "ON|OFF",
          "type": "boolean",
          "description": "The autocommit mode. If set to ON, all changes to a table take effect immediately. If set to OFF, you must use COMMIT to accept a transaction or ROLLBACK to cancel it. "
        }
      ]
  }
  

• Abnormal response

  For details, see Abnormal Request Results.

Status Code

• Normal

  200

• Abnormal

  For details, see Status Codes.

Error Code

For details, see Error Codes.

last updated: 2024-12-10 15:16 UTC - commit: 148bbcaa587d5f60ca229a738ab0fb7c0ed09ff7