Patching Databases in Batches
Function
This API is used to patch databases in batches.
Constraints
- This API supports the following instances:
- GeminiDB Cassandra
- GeminiDB Influx
- GeminiDB Redis
- Upgrade is triggered immediately, so patch databases during off-peak hours.
Authorization Information
Each account has permissions to call all APIs, but IAM users must have the required permissions specifically assigned.
- If you are using role/policy-based authorization, see the required permissions in Permissions and Supported Actions.
- 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
gaussdbfornosql:instance:batchUpgradeDatabaseVersion
write
-
-
nosql:instance:batchUpgradeDatabaseVersion
-
URI
POST /v3/{project_id}/instances/db-upgrade
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| project_id | Yes | String | Definition Project ID of a tenant in a region. To obtain this value, see Obtaining a Project ID. Constraints N/A Range The value contains 32 characters. Only letters and digits are allowed. Default Value N/A |
Request Parameters
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| X-Auth-Token | Yes | String | Definition User token You can obtain the token by calling the IAM API by following Obtaining a User Token Through Password Authentication. Constraints N/A Range N/A Default Value N/A |
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| instance_ids | Yes | Array of strings | Definition IDs of instances where databases need to be patched. To obtain the value, call the Querying Instances and Details API. Constraints Instance IDs only of the same engine can be transferred at a time. A maximum of 10 instance IDs can be transferred at a time. |
Response Parameters
Status code: 202
| Parameter | Type | Description |
|---|---|---|
| upgrade_results | Array of UpgradeResult objects | Definition Batch upgrade result |
| Parameter | Type | Description |
|---|---|---|
| job_id | String | Definition Task ID returned only when a patch installation task is successfully submitted Range N/A |
| instance_id | String | Definition Instance ID Range N/A |
| error_code | String | Definition Error code returned only when a patch installation task fails to be submitted Range N/A |
| error_message | String | Definition Failure cause returned only when a patch installation task fails to be submitted Range N/A |
Status code: 400
| Parameter | Type | Description |
|---|---|---|
| error_code | String | Definition Error code Range N/A |
| error_msg | String | Definition Error message Range N/A |
Status code: 500
| Parameter | Type | Description |
|---|---|---|
| error_code | String | Definition Error code Range N/A |
| error_msg | String | Definition Error message Range N/A |
Example Requests
POST https://{Endpoint}/v3/619d3e78f61b4be68bc5aa0b59edcf7b/instances/db-upgrade
{
"instance_ids" : [ "046287aae57843b1a7bc61b7a8812f41in13", "3d1e04f49efa473a8c7eaf07ed7ff870in13" ]
} Example Responses
Status code: 202
Accepted
{
"upgrade_results" : [ {
"instance_id" : "046287aae57843b1a7bc61b7a8812f41in13",
"job_id" : "e4616470-733d-41de-a9b0-a260709293d3"
}, {
"instance_id" : "3d1e04f49efa473a8c7eaf07ed7ff870in13",
"error_code" : "DBS.200011",
"error_message" : "The status of DB instance does not allow the operation."
} ]
} Status Codes
For details, see Status Codes.
Error Codes
For details, see Error Codes.
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot