Home > database >  Binlog update view
Binlog update view

Time:11-18

We have a demand, a view to other parts of the mysql moved into an entity list,

Canal can realize incremental synchronization based on binlog table,

I'm A instance of A view VW based on tables T1 and T2,

Then update T1, want to pass the canal to identify T1 binlog, put A instance of VW view to move to another instance of VW ,
Don't know if you could achieve?



CodePudding user response:

Can write their own client, screening out the T1 table related Binlog, logic is then free to play, but the premise is T1 Binlog, can get the VM table of a unique identifier
  • Related