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.
Import
DTS Synchronization Job can be imported using the id, e.g.
$ pulumi import alicloud:dts/synchronizationJob:SynchronizationJob example <id>
Properties
The start point or synchronization point of incremental data migration, the format is Unix timestamp, and the unit is seconds.
The data verification task of the migration or synchronization instance, in the format of a JSON string, such as parameter limits or alarm configurations. For more information, see the DataCheckConfigure parameter description datacheckconfigure-parameter.
Whether to perform full data migration or full data initialization. Valid values: true
, false
.
Whether to perform incremental data migration or synchronization. Valid values: true
, false
.
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.
When the ID of the dedicated cluster is input, the task is scheduled to the corresponding cluster.
The delay notice. Valid values: true
, false
.
The delay phone. The mobile phone number of the contact who delayed the alarm. Multiple mobile phone numbers separated by English commas ,
. This parameter currently only supports China stations, and only supports mainland mobile phone numbers, and up to 10 mobile phone numbers can be passed in.
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 name of the database to which the migration object belongs in the target instance. Note: when the target instance or target database type is PolarDB O engine, AnalyticDB PostgreSQL, PostgreSQL, MongoDB database, this parameter is available and must be passed in.
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 IP of source endpoint. When destination_endpoint_instance_type
is OTHER
, EXPRESS
, DG
, CEN
, this parameter is available and must be passed in.
The SID of Oracle database. Note: when the value of DestinationEndpointEngineName is Oracle and the Oracle database is a non-RAC instance, this parameter is available and must be passed in.
The ID of the Alibaba Cloud account to which the target RDS MySQL instance belongs. can be configured only when the target instance is RDS MySQL. This parameter is used to migrate or synchronize data across Alibaba Cloud accounts. You also need to enter the destinationendpointrle parameter.
The password of database account.
The port of source endpoint. When the target instance is a self-built database, this parameter is available and must be passed in.
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 role name of the Alibaba Cloud account to which the target instance belongs. This parameter must be entered when data migration or synchronization across Alibaba Cloud accounts is performed. For the permissions and authorization methods required by this role.
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 environment label of the DTS instance. The value is: normal, online.
The ID of synchronization instance, it must be an ID of alicloud.dts.SynchronizationInstance
.
The name of synchronization job.
The error notice. Valid values: true
, false
.
The error phone. The mobile phone number of the contact who error the alarm. Multiple mobile phone numbers separated by English commas ,
. This parameter currently only supports China stations, and only supports mainland mobile phone numbers, and up to 10 mobile phone numbers can be passed in.
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 name of the database to which the migration object belongs in the source instance. Note: this parameter is only available and must be passed in when the source instance, or the database type of the source instance is PolarDB O engine, PostgreSQL, or MongoDB database.
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
.
The IP of source endpoint. When source_endpoint_instance_type
is OTHER
, EXPRESS
, DG
, CEN
, this parameter is available and must be passed in.
The SID of Oracle database. When the value of SourceEndpointEngineName is Oracle and the Oracle database is a non-RAC instance, this parameter is available and must be passed in.
The ID of Alibaba Cloud account to which the source instance belongs. Note: passing in this parameter means performing data migration or synchronization across Alibaba Cloud accounts, and you also need to pass in the source_endpoint_role
parameter.
The password of database account.
The port of source endpoint. When the source instance is a self-built database, this parameter is available and must be passed in.
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.
Data Delivery link switch instance id
Whether to perform library table structure migration or initialization. Valid values: true
, false
.
Synchronization direction. Valid values: Forward
, Reverse
. Only when the property sync_architecture
of the alicloud.dts.SynchronizationInstance
was bidirectional
this parameter should be passed, otherwise this parameter should not be specified.