Sampling parameter for spot check
Used by actions: CreateMigrateJob, DescribeMigrateJobs, ModifyMigrateJob.
Name | Type | Required | Description |
---|---|---|---|
SelectRowsPerTable | Integer | Yes | Data content check parameter, which refers to the proportion of the rows selected for data comparison in all the rows of the table. Value: an integer between 1 and 100. |
TablesSelectAll | Integer | Yes | Data content check parameter, which refers to the proportion of the tables selected for data detection in all the tables. Value: an integer between 1 and 100. |
TablesSelectCount | Integer | Yes | Data quantity check parameter, which checks whether the numbers of rows are identical. It refers to the proportion of the tables selected for quantity check in all the tables. Value: an integer between 1 and 100. |
Target instance information, which is correlated with the migration task type
Used by actions: CreateMigrateJob, DescribeMigrateJobs, ModifyMigrateJob.
Name | Type | Required | Description |
---|---|---|---|
InstanceId | String | Yes | Target instance ID, such as cdb-jd92ijd8 |
Region | String | Yes | Target instance region, such as ap-guangzhou |
Ip | String | No | Target instance VIP, which has been disused and does not need to be entered |
Port | Integer | No | Target instance Vport, which has been disused and does not need to be entered |
ReadOnly | Integer | No | Only valid for MySQL currently. For instance-level migration, the value range is: 1 (read-only), 0 (read/write) |
User | String | No | Target database account |
Password | String | No | Target database password |
Message and prompt for migration task error
Used by actions: DescribeMigrateJobs.
Name | Type | Description |
---|---|---|
ErrorLog | String | Specific error log, including error code and error message |
HelpDoc | String | Help document URL corresponding to error |
Describes the specific migration process
Used by actions: DescribeMigrateJobs.
Name | Type | Description |
---|---|---|
StepAll | Integer | Total number of steps |
StepNow | Integer | Current step |
Progress | String | Overall progress, such as "10" |
CurrentStepProgress | String | Progress of current step, such as "1" |
MasterSlaveDistance | Integer | Master/slave lag in MB, which is valid during incremental sync and currently supported by TencentDB for Redis and MySQL |
SecondsBehindMaster | Integer | Master/slave lag in seconds, which is valid during incremental sync and currently supported by TencentDB for MySQL |
StepInfo | Array of MigrateStepDetailInfo | Step information |
Migration task details
Used by actions: DescribeMigrateJobs.
Name | Type | Description |
---|---|---|
JobId | String | Data migration task ID |
JobName | String | Data migration task name |
MigrateOption | MigrateOption | Migration task configuration options |
SrcDatabaseType | String | Source instance database type: MySQL, Redis, MongoDB, PostgreSQL, MariaDB, Percona |
SrcAccessType | String | Source instance access type. Value range: extranet (public network), cvm (CVM-created instance), dcg (Direct Connect-enabled instance), vpncloud (Tencent Cloud VPN-enabled instance), cdb (TencentDB instance), ccn (CCN instances) |
SrcInfo | SrcInfo | Source instance information, which is correlated with the migration task type |
DstDatabaseType | String | Target instance access type: MySQL, Redis, MongoDB, PostgreSQL, MariaDB, Percona |
DstAccessType | String | Target instance access type, which currently only supports cdb (TencentDB instance) |
DstInfo | DstInfo | Target instance information |
DatabaseInfo | String | Information of the source table to be migrated. If the entire instance is to be migrated, this field should be [] |
CreateTime | Timestamp | Task creation/submission time |
StartTime | Timestamp | Task start time |
EndTime | Timestamp | Task end time |
Status | Integer | Task status. Value range: 1 (Creating), 3 (Checking), 4 (CheckPass), 5 (CheckNotPass), 7 (Running), 8 (ReadyComplete), 9 (Success), 10 (Failed), 11 (Stopping), 12 (Completing) |
Detail | MigrateDetailInfo | Task details |
ErrorInfo | Array of ErrorInfo | Prompt message for task error, which is not null or empty when an error occurs with the task |
Tags | Array of TagItem | Tag Note: this field may return null , indicating that no valid values can be obtained. |
SrcInfoMulti | Array of SrcInfo | Information of the source instance, a cluster edition instance whose access type is not cdb .Note: This field may return null , indicating that no valid values can be obtained. |
Migration task configuration options
Used by actions: CreateMigrateJob, DescribeMigrateJobs, ModifyMigrateJob.
Name | Type | Required | Description |
---|---|---|---|
RunMode | Integer | Yes | Task operation mode. Value range: 1 (immediate execution), 2 (scheduled execution) |
ExpectTime | Timestamp | No | Expected execution time in the format of yyyy-mm-dd hh:mm:ss. If runMode=2, this field is required |
MigrateType | Integer | No | Data migration type. Value range: 1 (structural migration), 2 (full migration), 3 (full + incremental migration) |
MigrateObject | Integer | No | Migration subject. 1: entire instance; 2: specified table |
ConsistencyType | Integer | No | Parameter of spot data consistency check. 1: not configured; 2: full check; 3: spot check; 4: check inconsistent tables only; 5: no check |
IsOverrideRoot | Integer | No | Whether to overwrite the target database with the root account of the source database. Value range: 0 (no), 1 (yes). This value should be 0 for table or structural migration |
ExternParams | String | No | Additional parameters for different databases, which are described in JSON format. The following parameters can be defined for Redis: { "ClientOutputBufferHardLimit":512, Hard capacity limit of slave buffer (MB) "ClientOutputBufferSoftLimit":512, Soft capacity limit of slave buffer (MB) "ClientOutputBufferPersistTime":60, Soft limit duration of slave buffer (s) "ReplBacklogSize":512, Circular buffer capacity limit (MB) "ReplTimeout":120, Replication timeout period (s) } The following parameters can be defined for MongoDB: { 'SrcAuthDatabase':'admin', 'SrcAuthFlag': "1", 'SrcAuthMechanism':"SCRAM-SHA-1" } MySQL currently does not support configuring additional parameters. |
ConsistencyParams | ConsistencyParams | No | Only used for "spot data consistency check". It is required if ConsistencyType is spot check |
Information of steps in migration
Used by actions: DescribeMigrateJobs.
Name | Type | Description |
---|---|---|
StepNo | Integer | Step number |
StepName | String | Step name |
StepId | String | Step ID |
Status | Integer | Step status. Value range: 0 (default), 1 (succeeded), 2 (failed), 3 (in progress), 4 (not started) |
StartTime | String | Start time of current step in the format of yyyy-mm-dd hh:mm:ss . This field is meaningless if it does not exist or is emptyNote: this field may return null, indicating that no valid values can be obtained. |
Source instance information
Used by actions: CreateMigrateJob, DescribeMigrateJobs, ModifyMigrateJob.
Name | Type | Required | Description |
---|---|---|---|
AccessKey | String | No | Alibaba Cloud AccessKey, which is applicable if the source database is an Alibaba Cloud ApsaraDB for RDS 5.6 instance |
Ip | String | No | Instance IP address |
Port | Integer | No | Instance port |
User | String | No | Instance username |
Password | String | No | Instance password |
RdsInstanceId | String | No | Alibaba Cloud ApsaraDB for RDS instance ID, which is applicable if the source database is an Alibaba Cloud ApsaraDB for RDS 5.6/5.7 instance |
CvmInstanceId | String | No | Short CVM instance ID in the format of ins-olgl39y8 . It is the same as the instance ID displayed on the CVM Console page. For CVM-based self-created instances, this field needs to be passed in |
UniqDcgId | String | No | Direct Connect gateway ID in the format of dcg-0rxtqqxb |
VpcId | String | No | VPC ID in the format of vpc-92jblxto |
SubnetId | String | No | VPC Subnet ID in the format of subnet-3paxmkdz |
UniqVpnGwId | String | No | VPN gateway ID in the format of vpngw-9ghexg7q |
InstanceId | String | No | Database instance ID in the format of cdb-powiqx8q |
Region | String | No | Region name, such as ap-guangzhou |
Supplier | String | No | For Alibaba Cloud ApsaraDB for RDS instances, enter "aliyun"; otherwise, enter "others" |
CcnId | String | No | CCN instance ID, such as ccn-afp6kltc Note: This field may return null, indicating that no valid values can be obtained. |
EngineVersion | String | No | Database version. This parameter is valid only when the instance is an RDS instance. Value: 5.6 or 5.7. Default value: 5.6 |
Error message displayed when the subscription configuration was queried.
Used by actions: DescribeSubscribeConf.
Name | Type | Description |
---|---|---|
Message | String | Error message. Note: This field may return null , indicating that no valid values can be obtained. |
Subscription instance information
Used by actions: DescribeSubscribes.
Name | Type | Required | Description |
---|---|---|---|
SubscribeId | String | No | Data subscription instance ID |
SubscribeName | String | No | Data subscription instance name |
ChannelId | String | No | ID of channel bound to data subscription instance |
Product | String | No | Name of product bound to data subscription instance |
InstanceId | String | No | ID of database instance bound to data subscription instance |
InstanceStatus | String | No | Status of database instance bound to data subscription instance |
SubsStatus | String | No | Data subscription instance configuration status. Valid values: unconfigure, configuring, configured |
ModifyTime | String | No | Last modified time |
CreateTime | String | No | Creation time |
IsolateTime | String | No | Isolation time |
ExpireTime | String | No | Expiration time |
OfflineTime | String | No | Deactivation time |
ConsumeStartTime | String | No | Last modified consumption starting time point. If it has never been modified, this field is 0 |
Region | String | No | Data subscription instance region |
PayType | Integer | No | Billing mode. 1: pay-as-you-go |
Vip | String | No | Data subscription instance VIP |
Vport | Integer | No | Data subscription instance Vport |
UniqVpcId | String | No | Unique ID of the VPC where the data subscription instance VIP resides |
UniqSubnetId | String | No | Unique ID of the subnet where the data subscription instance VIP resides |
Status | String | No | Data subscription instance status. Valid values: creating, normal, isolating, isolated, offlining, offline |
SdkConsumedTime | String | No | Timestamp of the last message confirmed by the SDK. If the SDK keeps consuming, this field can also be used as the current consumption time point of the SDK |
Tags | Array of TagItem | No | Tag Note: this field may return null , indicating that no valid values can be obtained. |
AutoRenewFlag | Integer | No | Whether auto-renewal is enabled. 0: do not enable; 1: enable Note: this field may return null , indicating that no valid values can be obtained. |
SubscribeVersion | String | No | Subscription instance edition. ·txdts : legacy data subscription; kafka : data subscription in Kafka editionNote: this field may return null , indicating that no valid values can be obtained. |
Data subscription object
Used by actions: ActivateSubscribe, DescribeSubscribeConf, ModifySubscribeObjects.
Name | Type | Required | Description |
---|---|---|---|
ObjectsType | Integer | Yes | Data subscription object type. 0: database, 1: database table Note: this field may return null, indicating that no valid values can be obtained. |
DatabaseName | String | Yes | Name of subscribed database Note: this field may return null, indicating that no valid values can be obtained. |
TableNames | Array of String | No | Array of table names in subscribed database Note: this field may return null, indicating that no valid values can be obtained. |
Sale information of data subscription region
Used by actions: DescribeRegionConf.
Name | Type | Description |
---|---|---|
RegionName | String | Region name, such as Guangzhou Note: this field may return null, indicating that no valid values can be obtained. |
Region | String | Region ID, such as ap-guangzhou Note: this field may return null, indicating that no valid values can be obtained. |
Area | String | Region name, such as South China Note: this field may return null, indicating that no valid values can be obtained. |
IsDefaultRegion | Integer | Whether it is the default region. 0: no, 1: yes Note: this field may return null, indicating that no valid values can be obtained. |
Status | Integer | Purchasable status of current region. 1: normal, 2: beta test, 3: not purchasable Note: this field may return null, indicating that no valid values can be obtained. |
Tag filtering
Used by actions: DescribeMigrateJobs, DescribeSubscribes.
Name | Type | Required | Description |
---|---|---|---|
TagKey | String | Yes | Tag key value |
TagValue | Array of String | No | Tag value |
Tag
Used by actions: CreateMigrateJob, CreateSubscribe, DescribeMigrateJobs, DescribeSubscribeConf, DescribeSubscribes.
Name | Type | Required | Description |
---|---|---|---|
TagKey | String | Yes | Tag key value |
TagValue | String | No | Tag value Note: this field may return null , indicating that no valid values can be obtained. |
Was this page helpful?