Changing the Failover Priority¶
Function¶
This API is used to change the failover priority for primary/standby DB instances to meet different service requirements. You can select Reliability First or Availability First.
Before calling an API, you need to understand the API in Authentication.
Before calling this API, obtain the required region and endpoint.
Constraints¶
This API is supported for MySQL only.
This API is supported for primary/standby DB instances only.
The failover priority cannot be changed if the DB instance is in any of the following statuses: creating, upgrading, creating users, or deleting users.
URI¶
URI format
PUT https://{Endpoint}/v3/{project_id}/instances/{instance_id}/failover/strategy
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.
instance_id
Yes
Specifies the DB instance ID.
Request¶
Parameter description
Table 2 Parameter description¶ Name
Mandatory
Type
Description
repairStrategy
Yes
String
Specifies the failover priority. Valid value:
reliability: Data reliability is preferentially ensured during the failover to minimize the amount of lost data. It is recommended for services that require high data consistency.
availability: Data availability is preferentially ensured during the failover to recover services quickly. It is recommended for services that have high requirements on the database online duration.
Request example
PUT https://{Endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/failover/strategy{ "repairStrategy": "availability" }
Response¶
Normal response
None
Example normal response
{}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.