Querying the Estimated Database Patch Upgrade Duration

API Description

This API is used to query the estimated database patch upgrade duration.

Authorization Information

Each account has all the permissions required to call all APIs, but IAM users must be assigned the required permissions.

If you are using role/policy-based authorization, see Permissions Policies and Supported Actions for details on the required permissions.

If you are using identity policy-based authorization, the following identity policy-based permissions are required.

Action	Access Level	Resource Type (*: required)	Condition Key	Alias	Dependencies
dds:instance:getUpgradeDuration	read	instance	g:EnterpriseProjectId	dds:instance:list	-

URI

URI format
GET /v3/{project_id}/instances/{instance_id}/db-upgrade-duration

URI example

https://dds.cn-north-1.myhuaweicloud.com/v3/619d3e78f61b4be68bc5aa0b59edcf7b/instances/{instance_id}/db-upgrade-duration

**Table 1** Request Parameters
Name	Mandatory	Type	Description
X-Auth-Token	Yes	String	Definition User token obtained from IAM. For details, see Authentication. Constraints N/A Range N/A Default Value N/A
project_id	Yes	String	Definition Project ID of a tenant in a region. Obtain the project ID by following the instructions in Obtaining a Project ID. Constraints N/A Range N/A Default Value N/A
instance_id	Yes	String	Definition Instance ID, which can be obtained by calling the API described in Querying Instances and Details. If you do not have an instance, call the API described in Creating a DB Instance to create one. Constraints N/A Range N/A Default Value N/A

Request

None

Response

Parameter description

**Table 2** Response body parameters
Name	Type	Description
strategies	Array of Table 3 objects	Definition Upgrade policy list. Range N/A

**Table 3** DurationStrategies
Name	Type	Description
strategy	String	Definition Upgrade policy. Range minimized_interrupt_time: indicates the shortest interruption time. minimized_upgrade_time: indicates the minimum upgrade duration.
estimated_upgrade_duration	Integer	Definition Upgrade duration, in minutes. Range N/A

Example Request

GET https://{endpoint}/v3/619d3e78f61b4be68bc5aa0b59edcf7b/instances/{instance_id}/db-upgrade-duration

Example Response

Status code: 200

Success.

{    
  "strategies" : [ {     
  "strategy" : "minimized_interrupt_time",   
  "estimated_upgrade_duration" : 10   
  }, {     
    "strategy" : "minimized_upgrade_time",   
    "estimated_upgrade_duration" : 5  
  } ]  
}