How to use new binlog file as offset?

asked 2018-12-26 01:13:18 -0600

Maithri gravatar image

updated 2019-01-22 23:32:28 -0600

I am using MySQL Binary Log as origin for CDC.Here the pipeline uses binlog filename:position to read the last committed offset.I have a situation where it is needed to delete the binlog file after 10 days, after this if I run the pipeline it gives error as it cannot find the binlog file and the position.In this case I want to use the same pipeline and use the new binlog file.Is this possible in any way? I tried with start from beginning option as well.Getting same error: unable to find binlog file or position.Is there any way to pick the new binlog file using same pipeline ?

Thanks in advance

edit retag flag offensive close merge delete