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.

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 /v3/{project_id}/instances/{instance_id}/failover/strategy

• Example

  https://{Endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/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

  {
       "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.