Support Event To Detect Column Changes For Mysql:5.7 about mysqlcdc HOT 7 CLOSED

@vinh3c
I think the event you are looking for is
RowsQueryEvent
See the docs for the repository on how to enable this event for MySQL or MariaDB

4.Optionally you can enable logging SQL queries that precede row based events and listen to RowsQueryEvent.

for MySQL:
binlog_rows_query_log_events = on

for MariaDB:
binlog_annotate_row_events = on

from mysqlcdc.

Hi,
I believe QueryEvent is written in binary log when DDL(alter table) operations are executed.
You can try and see if this event logs necessary information, extract the column information from the sql statement.

from mysqlcdc.

This lib is low level so parsing sql statements seems out of scope for the lib.
Also, unfortunately, currently I don't have time to support such high level abstractions

from mysqlcdc.

I'm trying with that. I work for me
Thanks @rusuly

from mysqlcdc.

Ok, just be informed that QueryEvent and RowsQueryEvent are two different events. The first is used when statement-based replication is enabled. RowsQueryEvent is used when row-based replication is used and it requires some configuration in the config file

from mysqlcdc.

I known that, QueryEvent come after Unknow Event. But i think it better when we have native event for that
Thanks rusuly.

from mysqlcdc.

Thanks @rusuly

from mysqlcdc.