Ask Your Question

Revision history [back]

How to use new binlog file as offset?

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?

Thanks in advance

How to use new binlog file as offset?

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?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

How to use new binlog file as offset?

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