current position:Home>What is the description of the processing mode configuration of the target existing table in the RDS MySQL synchronization to polardb MySQL Cluster?

What is the description of the processing mode configuration of the target existing table in the RDS MySQL synchronization to polardb MySQL Cluster?

2022-02-04 17:30:22 Alibaba cloud Q & A

RDS MySQL Sync to PolarDB MySQL What is the description of the processing mode configuration of the target existing table in the cluster ?




Take the answer 1:

Pre check and report errors : Check whether there is a table with the same name in the target database . If there is no table with the same name in the target database , Pass the inspection item ; If there is a table with the same name in the target database , Then an error will be prompted in the pre check phase , The data synchronization task will not be started .

explain If the table with the same name in the target library is inconvenient to delete or rename , You can change the name of the table in the target library , See library table column name mapping . Ignore the error and continue : Skip checking whether there is a table with the same name in the target database . Warning Select ignore the error and continue to execute , Data may be inconsistent , Bring risks to the business , for example : When the table structure is consistent , If you encounter a record with the same value as the primary key of the source database in the target database : Full volume period ,DTS The record in the target cluster will be retained , That is, the record in the source database will not be synchronized to the target database . Incremental period ,DTS The record in the target cluster will not be retained , That is, the record in the source database will be overwritten in the target database . In case of inconsistent table structure , May result in failure to initialize data 、 Only the data of some columns can be synchronized or the synchronization fails .


copyright notice
author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/02/202202041730206591.html

Random recommended