Feature request: support passing down Debezium properties

[sheltonsuen]

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

Yes, when using MySQL CDC we may need custom some properties of Debezium,
The default behavior of Risingwave MySQL CDC will create lock on the MySQL instance and cause other service unaviliable long time during snapshot sync time,

Describe the solution you'd like

we can custom the snapshot.locking.mode of Debezium

Describe alternatives you've considered

No response

Additional context

No response

[xxchan]

We've supported lock-free MySQL CDC in v1.5.0. What's the RisingWave version are you using?

Besides, RisingWave's MySQL CDC has a customized lock-free algorithm instead of solely relying on Debezium, so we can't use snapshot.locking.mode for that.

[sheltonsuen]

Version: 1.5.4

we didn't save any logs for that, but we do have noticed the MySQL CDC user has a long transaction lock,

I will retry later to see if there still this problem