Ask Your Question
2

Which processor need to be used to query on CDC data from MySQL Binlog to any destination?

asked 2018-01-21 23:18:21 -0600

Maithri gravatar image

updated 2018-01-29 00:29:30 -0600

I want to fetch table data (2-3 tables) from mariadb,achieve CDC,apply some filter condition or query on this data using any processor and dump it to multiple destinations based on that conditions( or query).

I used MysqlBinary log origin and fetched data(CDC),I am stuck to choose a processor for this requirement.Please someone suggest me the solution for this requirement.

Thanks

edit retag flag offensive close merge delete

Comments

I've given a basic answer based on the filtering requirement. Can you expand on what you mean by 'query on this data'. Do you mean query MariaDB for additional data based on the CDC records?

metadaddy gravatar imagemetadaddy ( 2018-01-24 11:09:31 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2018-01-24 11:08:25 -0600

metadaddy gravatar image

You can filter records and send them to different destinations using the Stream Selector processor - just write conditions like:

${record:value('/fieldname') == 'bob'}

and send the records to different streams.

edit flag offensive delete link more

Comments

I want to fetch data from mariadb by joining tables with where conditions.I could achieve this by using JDBC query consumer.

Maithri gravatar imageMaithri ( 2018-01-24 23:27:11 -0600 )edit

But I want to achieve CDC as well, so JDBC query consumer did not support these changes from mariadb and I was suggested to use Mysql Binary Log.The problem I am facing here is that I cannot write the join query and the where conditions how I used for Jdbc Query consumer in Mysql Binary Log.

Maithri gravatar imageMaithri ( 2018-01-24 23:30:13 -0600 )edit

Example: select x,y,(select a from table b where a.b1=some value) from table a join table b on(a.somevale=c.somevalue)

Maithri gravatar imageMaithri ( 2018-01-24 23:31:51 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-21 23:18:21 -0600

Seen: 163 times

Last updated: Jan 29