mysql debezium force to snapshot

[추추]

Hello!

I want to snapshot using mysql debezium.

but, I already got snapshot before. and streaming now.

On document, It seems mysql debezium has no snapshot forcely.

How can I execute snapshot forcely like postgresql debezium (snapshot.mode: always)?

[jiri.p...@gmail.com]

Hi,

what is your scenario? Why do you need to execute the snapshot again? Do you want to do it with each start?

 

J.

[추추]

Hi, 
We use table.include.list when using debezium. becuze, there are many temporary tables which we don't want to get.

So, If other team creates new table and put some data, we should get snapshot of new tables. 

Also,  At the development stage. I sometimes deleted all data and get new snapshot.

2021년 5월 27일 목요일 오후 3시 36분 37초 UTC+9에 jiri.p...@gmail.com님이 작성:

[Gunnar Morling]

Hi,

As of Debezium 1.6, there is support for ad-hoc snapshots, initiated while the connector is running [1]. This should address your requirements. Would love to get your feedback on this.

Best,

--Gunnar

[1] https://debezium.io/documentation/reference/connectors/mysql.html#_incremental_snapshot