dm icon indicating copy to clipboard operation
dm copied to clipboard

"MIXED" binlog format support

Open CrazyNash opened this issue 6 years ago • 4 comments

Feature Request

Is your feature request related to a problem? Please describe:

Describe the feature you'd like:

Customer MySQL instance runs with "MIXED" binlog format, and can't change for some reasons like master-slave set up already. Customer wants to sync data to TiDB, DM doesn't support this now.

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy:

CrazyNash avatar Aug 21 '19 07:08 CrazyNash

Thank you for your feedback, but we may not support it in the short term.

csuzhangxc avatar Aug 21 '19 07:08 csuzhangxc

@ericsyh PTAL, I think we can take a closer look at the usage scenario, maybe it's a general case

IANTHEREAL avatar Aug 22 '19 10:08 IANTHEREAL

I need this feature strongly.

YouhuaLi avatar Nov 22 '19 19:11 YouhuaLi

MIXED binlog format may write original SQL in binlog, a DELETE ... id > xxx should be faster than DELETE per row, and this will improve synchronize speed.

lance6716 avatar Jun 03 '21 11:06 lance6716