current position:Home>What is the description of the special case of DTS self built MySQL synchronizing to RDS MySQL?

What is the description of the special case of DTS self built MySQL synchronizing to RDS MySQL?

2022-02-04 16:46:35 Alibaba cloud Q & A

dts build by oneself MySQL Sync to RDS MySQL What is the description of the special case of ?




Take the answer 1:

When the source library is self built MySQL when In sync , If the source database switches between active and standby , Will cause the synchronization task to fail . because DTS The delay time of is obtained by comparing the timestamp of the last data synchronized to the target database with the current timestamp , The source library has not been executed for a long time DML Operation may result in inaccurate delay information . If the delay time displayed by the task is too large , You can execute a... In the source library DML Operation to update delay information . explain If the synchronization object is selected as the whole library , You can also create a heartbeat table , The heartbeat table updates or writes data regularly every second .


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

Random recommended