Modifies the basic and advanced information about a database instance in Data Management (DMS). The basic information includes the hosting mode of the instance, the instance account username and password, and features that are enabled for the instance. The advanced information includes the environment type, the instance name in DMS, and the timeout period for querying and exporting data.
Debugging
Authorization information
Request parameters
| Parameter | Type | Required | Description | Example |
|---|---|---|---|---|
| InstanceId | string | Yes | The ID of the instance. You can call the ListInstances or GetInstance operation to query the instance ID. | 183**** |
| Tid | long | No | The ID of the tenant. Note
You can move the pointer over the profile picture in the upper-right corner of the DMS console to obtain the tenant ID.
| 23**** |
| InstanceType | string | No | The type of the database instance. For more information about the valid values of this parameter, see DbType parameter. | MySQL |
| InstanceSource | string | No | The source of the database instance. Valid values:
| RDS |
| NetworkType | string | No | The network type of the database instance. Valid values:
| VPC |
| EnvType | string | No | The type of the environment in which the database instance is deployed. Valid values:
| dev |
| EcsInstanceId | string | No | The ID of the ECS instance. Note
This parameter is required if InstanceSource is set to ECS_OWN.
| i-2zei9gs1t7h8l7ac**** |
| VpcId | string | No | The VPC ID. Note
This parameter is required if InstanceSource is set to VPC_IDC.
| vpc-bp10wnlcmor**** |
| EcsRegion | string | No | The region in which the ECS instance resides. Note
This parameter is required if InstanceSource is set to RDS, ECS_OWN, or VPC_IDC.
| cn-hangzhou |
| Host | string | No | The endpoint that is used to connect to the database instance. | 192.XXX.0.56 |
| Port | integer | No | The port that is used to connect to the database instance. | 3306 |
| Sid | string | No | The system ID (SID) of the database instance. Note
This parameter is required if InstanceType is set to ORACLE.
| testSid |
| DatabaseUser | string | No | The account that is used to log on to the database instance. | testsdb |
| DatabasePassword | string | No | The password of the account that is used to log on to the database instance. | test*** |
| InstanceAlias | string | No | The alias of the database instance. Specify an alias that can help you quickly identify the database instance in Data Management (DMS). | instance_test |
| DbaId | long | No | The ID of the user who assumes the database administrator (DBA) role. You can call the ListUsers or GetInstance operation to obtain the value of this parameter. | 27**** |
| QueryTimeout | integer | No | The timeout period for querying data from the database instance. Unit: seconds. | 7200 |
| ExportTimeout | integer | No | The timeout period for exporting data from the database instance. Unit: seconds. | 86400 |
| EnableSellTrust | string | No | Specifies whether to enable the security hosting feature for the database instance. Valid values:
| Y |
| EnableSellStable | string | No | Specifies whether to enable Stable Change for the database instance. Valid values:
| NULL |
| EnableSellCommon | string | No | Specifies whether to enable Security Collaboration for the database instance. Valid values:
| Y |
| SafeRule | string | No | The name of the security rule set for the database instance. This parameter is required if Security Collaboration is enabled. You can call the ListStandardGroups or GetInstance operation to obtain the name of the security rule set from GroupName. | |
| EnableSellSitd | string | No | Specifies whether to enable sensitive data protection. Valid values:
| Y |
| DataLinkName | string | No | The name of the database link for cross-database queries. Note
| dblink_test |
| DdlOnline | integer | No | Specifies whether to enable lock-free schema change. Valid values:
Note
Supported databases include ApsaraDB RDS for MySQL, PolarDB for MySQL, ApsaraDB MyBase for MySQL, and third-party MySQL databases.
| 2 |
| UseDsql | integer | No | Specifies whether to enable cross-instance query for the database instance. Valid values:
Note
Supported databases include MySQL, SQL Server, PostgreSQL, PolarDB for Oracle, and Redis.
| 1 |
| SkipTest | boolean | No | Specifies whether to skip the connectivity test. Valid values:
| false |
| TemplateId | long | No | The ID of the classification and grading template. You can call the ListClassificationTemplates operation to query the template ID. | 31*** |
| TemplateType | string | No | The type of the classification and grading template. You can call the ListClassificationTemplates operation to query the template type. | INNER |
| UseSsl | integer | No | Specifies whether to allow Data Management Service (DMS) to connect to the database instance by using SSL connections. Before you use SSL connections, make sure that the SSL encryption feature is enabled for the database instance. Valid values:
Note
| 0 |
Response parameters
Examples
Sample success responses
JSONformat
{
"RequestId": "0C1CB646-1DE4-4AD0-B4A4-7D47DD52E931",
"ErrorCode": "UnknownError",
"ErrorMessage": "UnknownError",
"Success": true
}Error codes
For a list of error codes, visit the Service error codes.
Change history
| Change time | Summary of changes | Operation |
|---|---|---|
| 2024-03-20 | The request parameters of the API has changed | View Change Details |
