Assuming that only one database table, each server table structure is the same, each add records from the server, and also add to the main server, consider the problem of broken network, each record has a unique ID will not be repeated, the primary data is all the data from the server and set, do you have any good solutions or ideas, thank you,

CodePudding user response:

Looking for a BI tools, such as KETTLE,

CodePudding user response:

The trigger, realizes the deletion record,

CodePudding user response:

Hhhh63, hello you can say the detailed point, before I see you hair of, demand roughly similar with me, I now realize is local resolution mysql binary log, get the insert/update/delete statements database changes, and then spread to the cloud library implementation, so that to realize the data synchronization, practical process data inconsistency problem, can you tell me about your proposal, thank you

CodePudding user response:

KETTLE is not suitable for my needs, I need the data change of local immediately to the cloud,

CodePudding user response:

Canal can understand it