Performing Primary/Standby Switchovers in Batches
Function
This API is used to perform primary/standby switchovers in batches.
Constraints
This API only applies to tasks in the Disaster recovery in progress or Disaster recovery failed status. A switchover can be performed when the DR database can be properly connected. Dual-active DR does not support the switchover.
URI
POST /v3/{project_id}/jobs/batch-switchover
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| project_id | Yes | String | Project ID of a tenant in a region For details about how to obtain the project ID, see Obtaining a Project ID. |
Request Parameters
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| Content-Type | Yes | String | The content type. The default value is application/json. |
| X-Auth-Token | Yes | String | User token obtained from IAM. |
| X-Language | No | String | Request language type Default value: en-us Values:
|
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| jobs | Yes | Array of strings | IDs of batch primary/standby switchover tasks. |
Response Parameters
Status code: 202
| Parameter | Type | Description |
|---|---|---|
| results | Array of objects | Returned of batch primary/standby switchover tasks. For details, see Table 5. |
| count | Integer | Total number. |
| Parameter | Type | Description |
|---|---|---|
| job_id | String | Task ID. |
| updated_at | String | Update time, in the format yyyy-MM-dd'T'HH:mm:ss'Z'. |
| source_db | Object | Source database. For details, see Table 6. |
| target_db | Object | Destination database. For details, see Table 6. |
| job_direction | String | Task direction. Values:
|
| is_target_readonly | Boolean | Whether the destination database is read-only. |
| error_msg | String | Error message |
| error_code | String | Error code |
| Parameter | Type | Description |
|---|---|---|
| id | String | Database ID. |
| obj_id | String | Object ID |
| instance_name | String | Name of the RDS DB instance. |
| db_type | String | Database type. Values:
|
| db_user | String | Database user. |
| db_password | String | Database password. |
| manage_ip | String | Management IP address. |
| traffic_ip | String | Traffic IP address. |
| db_port | Integer | Database port. |
| region | String | Region where the RDS DB instance is located. |
| created_at | String | Creation date, in the format yyyy-MM-dd'T'HH:mm:ss'Z'. |
| updated_at | String | Modification date, in the format yyyy-MM-dd'T'HH:mm:ss'Z'. |
| ip | String | Private IP address of the replication instance. |
| public_ip | String | EIP of the replication instance. |
| az_code | String | AZ code. |
| security_group_id | String | ID of the security group to which the source database belongs. |
| subnet_id | String | ID of the subnet where the source database is located. |
| vpc_id | String | ID of the VPC where the source database is located. |
| volume_size | Long | Storage space of a replication instance. |
| full_trans_user_pwd | String | Ciphertext password of the user for full migration. |
| increment_trans_user_pwd | String | Ciphertext password of the incremental migration user. |
| ssl_link | Boolean | Whether SSL is enabled. |
| ssl_cert_key | String | SSL certificate content. |
| ssl_cert_name | String | SSL certificate name. |
| ssl_cert_check_sum | String | Checksum value of the SSL certificate content. |
| ssl_cert_password | String | SSL certificate password, in ciphertext. |
| db_version | String | Database version. |
| mongo_ha_mode | String | Mongo HA mode. Values:
|
| project_id | String | Project ID of an RDS DB instance. |
| cluster_mode | String | Cluster mode. Values:
|
| instance_id | String | RDS DB instance ID. |
| db_name | String | Oracle service name. |
| topic | String | Name of the mrskafka topic. |
| safe_mode | Integer | Whether to enable Kerberos authentication for MRSKafka. Values:
|
| kerberos_vo | Object | Information required for Kerberos authentication. For details, see Table 7. |
| multi_write_db_id | String | ID of the multi-write database. |
Example Request
Performing primary/standby switchovers in batches
https://{endpoint}/v3/054ba152d480d55b2f5dc0069e7ddef0/jobs/batch-switchover
{
"jobs" : [ "8d0e8e36-a618-490d-8a46-8c61ac9jb502" ]
} Example Response
Status code: 202
Accepted
{
"count" : 1,
"results" : [ {
"job_id" : "8d0e8e36-a618-490d-8a46-8c61ac9jb502",
"updated_at" : "2020-12-18T06:38:37Z",
"source_db" : {
"id" : "2706a49b-6dd0-4b70-b2a8-36cf0034703d",
"region" : "eu-west-101",
"ip" : "192.168.1.144",
"topic" : null,
"obj_id" : "0b51710fd4e54d6bb90ab91bf68f86efno01",
"instance_name" : "rds-zw-source",
"db_type" : "mysql",
"db_user" : "root",
"db_password" : "********",
"manage_ip" : null,
"traffic_ip" : "192.168.1.144",
"db_port" : 3306,
"created_at" : "2020-12-16T12:09:54Z",
"updated_at" : "2020-12-18T06:33:09Z",
"public_ip" : null,
"az_code" : "az3xahz",
"security_group_id" : "652cbe2d-d487-407e-b666-d01948b33879",
"subnet_id" : "c6f66ccb-be7a-499e-aa8a-1389355e67a8",
"vpc_id" : "7c73a425-885b-4e54-a0e6-ef9ee271a1db",
"volume_size" : null,
"full_trans_user_pwd" : "******",
"increment_trans_user_pwd" : "******",
"ssl_link" : false,
"ssl_cert_key" : null,
"ssl_cert_name" : null,
"ssl_cert_check_sum" : null,
"ssl_cert_password" : null,
"db_version" : "5.7.31",
"mongo_ha_mode" : null,
"project_id" : "054ba152d480d55b2f5dc0069e7ddef0",
"cluster_mode" : "Single",
"instance_id" : "3efbb0f1241f429e8e1d8f99ab094c7ain01",
"db_name" : null,
"safe_mode" : null,
"kerberos_vo" : null,
"multi_write_db_id" : null
},
"target_db" : {
"id" : "81ca3c57-029b-4a37-8f2d-2ee5f128ef9d",
"region" : "eu-west-101",
"ip" : "192.168.1.60",
"topic" : null,
"obj_id" : "b46e908dbbb44bb3b17f0a75c908d1d7no01",
"instance_name" : "rds-zw-target",
"db_type" : "mysql",
"db_user" : "root",
"db_password" : "********",
"manage_ip" : null,
"traffic_ip" : "192.168.1.60",
"db_port" : 3306,
"created_at" : "2020-12-16T12:09:55Z",
"updated_at" : "2020-12-18T06:33:08Z",
"public_ip" : null,
"az_code" : "az3xahz",
"security_group_id" : "652cbe2d-d487-407e-b666-d01948b33879",
"subnet_id" : "c6f66ccb-be7a-499e-aa8a-1389355e67a8",
"vpc_id" : "7c73a425-885b-4e54-a0e6-ef9ee271a1db",
"volume_size" : 40,
"full_trans_user_pwd" : "******",
"increment_trans_user_pwd" : "******",
"ssl_link" : false,
"ssl_cert_key" : null,
"ssl_cert_name" : null,
"ssl_cert_check_sum" : null,
"ssl_cert_password" : null,
"db_version" : "5.7.31",
"mongo_ha_mode" : null,
"project_id" : "054ba152d480d55b2f5dc0069e7ddef0",
"cluster_mode" : "Single",
"instance_id" : "a3ab61173b1b4533b8c3dfc2bb3ec828in01",
"db_name" : null,
"safe_mode" : null,
"kerberos_vo" : null,
"multi_write_db_id" : null
},
"job_direction" : "down",
"is_target_readonly" : false
} ]
} Status Code
| Status Code | Description |
|---|---|
| 202 | Accepted |
| 400 | Bad Request |
Error Code
For details, see Error Code.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.