Datax, synchronous data, mysql sqlserver bidirectional

Mysql sqlserver bidirectional synchronization

You encounter a pit when using sqlserver to connect to the server (without going into details), so use the following alternative.

Reference:

The solution of real-time synchronization of mysql to mssql

Https:// × × w.cnblogs.com/liweis/p/4749961.html

DataX Alibaba Group's offline data synchronization tool / platform (efficient data synchronization between various heterogeneous data sources).

Home page https://github.com/alibaba/DataX

Introduction to https://github.com/alibaba/DataX/blob/master/introduction.md

Support Data Channels (click to read or write will have specific instructions) https://github.com/alibaba/DataX

Quick Start https://github.com/alibaba/DataX/blob/master/userGuid.md

Configure the database on both sides:

Create a new table with the same structure as the synchronous table, add a column of OpType, a column of CTimes (default is the current time), and a column of operation status status (0 not operated, 1 has already operated) use different triggers to write the corresponding values to the OpType column (I for insert record, U for modify record, D for delete record)

PS:DataX cannot physically delete all the logic in the stored procedure

Use DataX synchronization, use CTime in where to distinguish what needs to be synchronized, and then complete the logic in the stored procedure

DataX uses notes

If there is a trigger on the table that executes with the write, execution means that if there is an error, it may also be in the trigger, but the error message does not indicate that the error occurred at that step.

After a period of development, I found that I still need to write a lot of code and cannot be physically deleted, so I chose not to continue. I found a good open source software called SymmetricDS, which is currently under development.