Help Center> Relational Database Service> API Reference> API v3 (Recommended)> DB Instance Management> Changing a Single DB Instance to Primary/Standby DB Instances
View PDF

Changing a Single DB Instance to Primary/Standby DB Instances

Function

This API is used to change a single DB instance to primary/standby DB instances.

Constraints

  • Single DB instances billed in the yearly/monthly mode cannot be changed to primary/standby DB instances.
  • Single DB instances with certain specifications cannot be changed to primary/standby DB instances.

URI

  • URI format

    POST https://{Endpoint}/v3/{project_id}/instances/{instance_id}/action

  • Example

    https://rds.cn-north-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/action

  • 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

    single_to_ha

    Yes

    Object

    For details, see Table 3.
    Table 3 single_to_ha field data structure description

    Name

    Mandatory

    Type

    Description

    az_code_new_node

    Yes

    String

    Specifies the AZ code of the DB instance node.

    password

    No

    String

    This parameter is mandatory only when a Microsoft SQL Server DB instance type is changed from single to primary/standby.

    dsspool_id

    No

    String

    Specifies the dsspool ID of DeC users. The dsspool configured for each AZ is different. The dsspool ID of the DB instance node is used only for DeC users during the creation.
  • Request example 
    {
	"single_to_ha": {
		"az_code_new_node": "az2xahz",
		"password": "Test@1234567"
	}
}

    DeC user request example

    {
	"single_to_ha": {
		"az_code_new_node": "az2xahz",
		"password": "Test@1234567",
                "dsspool_id":"23728728428374823748327482r"
	}
}

Response

  • Normal response
    Table 4 Parameter description

    Name

    Type

    Description

    job_id

    String

    Indicates the task ID.
  • Example normal response 
    {
	"job_id": "2b414788a6004883a02390e2eb0ea227"
}
  • Abnormal response

    For details, see Abnormal Request Results.

Status Code

For details, see Status Codes.

Error Code

For details, see Error Codes.

Parent topic: DB Instance Management