Synchronization Job
Provides a DTS Synchronization Job resource. For information about DTS Synchronization Job and how to use it, see What is Synchronization Job.
NOTE: Available since v1.138.0.
Notice
The expiration time cannot be changed after the work of the annual and monthly subscription suspended;
After the pay-as-you-go type job suspended, your job configuration fee will still be charged;
If the task suspended for more than 6 hours, the task will not start successfully.
Suspending the task will only stop writing to the target library, but will still continue to obtain the incremental log of the source, so that the task can be quickly resumed after the suspension is canceled. Therefore, some resources of the source library, such as bandwidth resources, will continue to be occupied during the period.
Charges will continue during the task suspension period. If you need to stop charging, please release the instance
When a DTS instance suspended for more than 7 days, the instance cannot be resumed, and the status will change from suspended to failed.
Import
DTS Synchronization Job can be imported using the id, e.g.
$ pulumi import alicloud:dts/synchronizationJob:SynchronizationJob example <id>
Properties
Migration object, in the format of JSON strings. For detailed definition instructions, please refer to the description of migration, synchronization or subscription objects. NOTE: From version 1.173.0, db_list
can be modified.
The delay rule time. When delay_notice
is set to true
, this parameter must be passed in. The threshold for triggering the delay alarm. The unit is second and needs to be an integer. The threshold can be set according to business needs. It is recommended to set it above 10 seconds to avoid delay fluctuations caused by network and database load.
The type of destination database. The default value is MYSQL. For the correspondence between supported target libraries and source libraries, see Supported Databases. When the database type of the target instance is KAFKA or MONGODB, you also need to pass in some information in the reserved parameter reserve
. For the configuration method, see the description of reserve
parameters. Valid values: ADS
, ADB30
, AS400
, DATAHUB
, DB2
, GREENPLUM
, KAFKA
, MONGODB
, MSSQL
, MySQL
, ORACLE
, PolarDB
, POLARDBX20
, POLARDB_O
, PostgreSQL
.
The ID of destination instance. If the target instance is a cloud database (such as RDS MySQL), you need to pass in the instance ID of the cloud database (such as the instance ID of RDS MySQL). If the target instance is a self-built database, the value of this parameter changes according to the value of destination_endpoint_instance_type
. For example, the value of destination_endpoint_instance_type
is: ** ECS
, then this parameter needs to be passed into the instance ID of ECS. ** DG
, then this parameter needs to be passed into the ID of database gateway. ** EXPRESS
, CEN
, then this parameter needs to be passed in the ID of VPC that has been interconnected with the source database. Note: when the value is CEN
, you also need to pass in the ID of CEN instance in the cloud enterprise network with the reserved parameter reserve
.
The type of destination instance. If the target instance is a PolarDB O engine cluster, the target instance type needs to be OTHER
or EXPRESS
as a self-built database, and access via public IP or dedicated line. If the target instance is the Kafka version of Message Queuing, the target instance type needs to be ECS
or EXPRESS
as a self-built database, and access via ECS or dedicated line. For the correspondence between supported targets and source instances, see Supported Databases. When the target instance is a self-built database, you also need to perform corresponding preparations, please refer to the overview of preparations. Valid values: ADS
, CEN
, DATAHUB
, DG
, ECS
, EXPRESS
, GREENPLUM
, MONGODB
, OTHER
, PolarDB
, POLARDBX20
, RDS
.
The region of destination instance. For the target instance region, please refer to the list of supported regions. Note: if the target is an Alibaba Cloud database, this parameter must be passed in.
The username of database account. Note: in most cases, you need to pass in the database account of the source library. The permissions required for migrating or synchronizing different databases are different. For specific permission requirements, see Preparing database accounts for data migration and Preparing database accounts for data synchronization.
The instance class. Valid values: large
, medium
, micro
, small
, xlarge
, xxlarge
. You can only upgrade the configuration, not downgrade the configuration. If you downgrade the instance, you need to submit a ticket.
DTS reserves parameters, the format is a JSON string, you can pass in this parameter to complete the source and target database information (such as the data storage format of the target Kafka database, the instance ID of the cloud enterprise network CEN). For more information, please refer to the parameter description of the Reserve parameter.
The type of source database. The default value is MySQL
. For the correspondence between supported source libraries and target libraries, see Supported Databases. When the database type of the source instance is MONGODB
, you also need to pass in some information in the reserved parameter Reserve
, for the configuration method, see the description of Reserve parameters. Valid values: AS400
, DB2
, DMSPOLARDB
, HBASE
, MONGODB
, MSSQL
, MySQL
, ORACLE
, PolarDB
, POLARDBX20
, POLARDB_O
, POSTGRESQL
, TERADATA
.
The ID of source instance. If the source instance is a cloud database (such as RDS MySQL), you need to pass in the instance ID of the cloud database (such as the instance ID of RDS MySQL). If the source instance is a self-built database, the value of this parameter changes according to the value of source_endpoint_instance_type
. For example, the value of source_endpoint_instance_type
is: ** ECS
, then this parameter needs to be passed into the instance ID of ECS. ** DG
, then this parameter needs to be passed into the ID of database gateway. ** EXPRESS
, CEN
, then this parameter needs to be passed in the ID of VPC that has been interconnected with the source database. Note: when the value is CEN
, you also need to pass in the ID of CEN instance in the cloud enterprise network with the reserved parameter reserve
.
The type of source instance. If the source instance is a PolarDB O
engine cluster, the source instance type needs to be OTHER
or EXPRESS
as a self-built database, and access via public IP or dedicated line. For the correspondence between supported source and target instances, see Supported Databases. When the source instance is a self-built database, you also need to perform corresponding preparations, for details, see Preparations Overview. Valid values: CEN
, DG
, DISTRIBUTED_DMSLOGICDB
, ECS
, EXPRESS
, MONGODB
, OTHER
, PolarDB
, POLARDBX20
, RDS
.
Source instance area, please refer to the list of supported areas for details. Note if the source is an Alibaba Cloud database, this parameter must be passed in.
The name of the role configured for the cloud account to which the source instance belongs. Note: this parameter must be passed in when performing cross Alibaba Cloud account data migration or synchronization. For the permissions and authorization methods required by this role, please refer to How to configure RAM authorization when cross-Alibaba Cloud account data migration or synchronization.
The username of database account. Note: in most cases, you need to pass in the database account of the source library. The permissions required for migrating or synchronizing different databases are different. For specific permission requirements, see Preparing database accounts for data migration and Preparing database accounts for data synchronization.