Question about mysql-cdc configuration

[suyanhj]

Hi, I’ve read in some articles that SeaTunnel supports resuming from breakpoints (i.e. exactly-once and incremental recovery). I also checked the official documentation for the mysql-cdc source connector and found the startup.mode option.

I understand that the initial mode means a full snapshot of the table followed by incremental sync (full + binlog). However, I’m a bit confused about the difference between earliest and latest.

Which mode should I use if I want SeaTunnel to automatically resume from the last processed offset after the job is paused or interrupted?

I'm currently using the Zeta engine instead of Flink.

Thanks in advance!

[davidzollo]

you can use `initial` if you'd like to `full + binlog`. `earliest` and `latest` are just used for the binlog, which means that you choose `earliest` binlog or `latest` binlog

[liunaijie]

Hi @suyanhj

Which mode should I use if I want SeaTunnel to automatically resume from the last processed offset after the job is paused or interrupted?

when job is paused or interrupted, you should restart the job from last checkpoint (savepoint). checkpoint save the last read pos, so we can resume the job from last read pos.

If you just re-submit the job without any states, it will read data from the pos configed by startup.mode option.