search

pingcap / dm

Data Migration Platform
Apache License 2.0
456 stars 188 forks source link

"MIXED" binlog format support #245

Open CrazyNash opened 5 years ago

CrazyNash commented 5 years ago

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:

csuzhangxc commented 5 years ago

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

IANTHEREAL commented 5 years ago

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

YouhuaLi commented 4 years ago

I need this feature strongly.

lance6716 commented 3 years ago

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.