Updated on 2022-08-16 GMT+08:00

Manually Switching Primary/Standby DB Instances

Function

This API is used to manually switch primary/standby DB instances as required.

Constraints

  • This API is supported for MySQL only.
  • This API is supported for primary/standby DB instances only.
  • Primary/standby DB instances cannot be switched if they are in any of the following statuses: creating, rebooting, upgrading, changing instance class, restoring, changing port, creating users, or deleting users.

URI

  • URI format

    PUT https://{Endpoint}/v3/{project_id}/instances/{instance_id}/failover

  • Example

    https://rds.my-kualalumpur-1.alphaedge.tmone.com.my/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/failover

  • 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

    None

  • Request example
    {}

Response

  • Normal response

    Name

    Description

    workflowId

    Indicates the task ID.

    instanceId

    Indicates the DB instance ID.

    nodeId

    Indicates the node ID.

  • Example normal response
    {
        "workflowId":"072beb09-0573-40bf-bfe8-4be5cec9e85a",
        "instanceId":"794c38e5309344818f4b33b86ebce9b4in03",
        "nodeId":"b94ba815747040f1b0d641cd13364a06no03"
    }
  • Abnormal response

    For details, see Abnormal Request Results.

Status Code

For details, see Status Codes.

Error Code

For details, see Error Codes.