Applying a Parameter Template

Function

This API is used to apply a parameter template to one or more DB instances.

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

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

Constraints

• The following DB engines are supported: MySQL, PostgreSQL, and Microsoft SQL Server.

• For Microsoft SQL Server, only the following editions are supported: Microsoft SQL Server 2014 SE, 2016 SE, and 2016 EE.

URI

• URI format

  PUT https://{Endpoint}/v3/{project_id}/configurations/{config_id}/apply

• 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.

Request

• Parameter description

  Table 2 Parameter description

  Name	Mandatory	Type	Description
  instance_ids	Yes	Array of strings	Specifies the DB instance ID list object.

• Request example

  PUT https://{Endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/configurations/463b4b58-d0e8-4e2b-9560-5dea4552fde9/apply
  

  {
      "instance_ids": ["73ea2bf70c73497f89ee0ad4ee008aa2in01", "fe5f5a07539c431181fc78220713aebein01"]
  }
  

Response

• Normal response

  Table 3 Parameter description

  Name	Type	Description
  configuration_id	String	Specifies the parameter template ID.
  configuration_name	String	Specifies the parameter template name.
  apply_results	Array of objects	Specifies the result of applying the parameter template. For details, see Table 4.
  success	Boolean	Indicates whether the parameter template is applied to all requested DB instances successfully. true: The parameter template was successfully applied to all requested DB instances. false: The parameter template failed to be applied to one or more requested DB instances.

  Table 4 apply_results field data structure description

  Name	Type	Description
  instance_id	String	Indicates the DB instance ID.
  instance_name	String	Indicates the DB instance name.
  restart_required	Boolean	Indicates whether a reboot is required. true: A reboot is required. false: A reboot is not required.
  success	Boolean	Indicates whether the parameter template is applied to the DB instance successfully. true: The application was successful. false: The application failed.

• Example normal response

  {
      "configuration_id": "cf49bbd7d2384878bc3808733c9e9d8bpr01",
      "configuration_name": "paramsGroup-bcf9",
      "apply_results": [{
          "instance_id": "fe5f5a07539c431181fc78220713aebein01",
          "instance_name": "zyy1",
          "restart_required": false,
          "success": false
      }, {
          "instance_id": "73ea2bf70c73497f89ee0ad4ee008aa2in01",
          "instance_name": "zyy2",
          "restart_required": false,
          "success": false
      }],
      "success": false
  }
  

• 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-11-08 14:19 UTC - commit: aae1b12bfa160248d933bc69155302800af0d0fd