Mysql cdc to kafka connect is running, but there is no messages show up in the topic

Hi there,
I am following this hands-on lab to create a MySQL CDC connect to the Kafka cluster in the confluent cloud.

The connect does show a “running” state, however, there is no messages to the topic. I am wondering if this is something reproducible for you or it works fine for you out there.

Thanks,
Xingsheng

Hi @xsqian,

If you navigate to Confluent Cloud → Topics, how many topics do you see that start with mysql?

Hi @mkananizadeh
There are 2 topics that start with MySQL:
mysql01
mysql01.demo.CUSTOMERS

Thank you for including screenshots @xsqian ! When you change the offset to 0, do you see anything?
I attached a screen recording from my setup as a reference
Screen Recording 2022-03-16 at 09.18.14 AM
.

Actually the option for the drop-down for the offset it faded out for me

@xsqian is that the same thing with your mysql01 topic?

Hi @mkananizadeh
It’s the same for the mysql01 topic. Please see the screenshots below:

Could you type into the offset box? If you can, please enter 0 and then pick 0 / Partition: 0.

@mkananizadeh Actually there are messages in the mysql01 topic once I enter 0 and then pick 0 / partition: 0
Here is the screenshot:

@mkananizadeh Also, after all the trouble, I found the issue: the issue is when creating a connection, I need to have the demo. in front of table CUSTOMERS, so table to include should be demo.CUSTOMERS. Before I though since I put the demo to the include database field, so I only need CUSTOMERS in the include table field. Apparently that not the case, always need demo.CUSTOMERS. Please see the screenshot.
Thank you for your help!

2 Likes

Glad to hear you got it working :slight_smile: