How to Set up Debezium connector for MySQL

Eddy Tran 40 Reputation points
2024-01-04T04:35:19.8966667+00:00

I have a mysql database "testdb" and I want to stream data from "testdb" to Azure Event Hub, I set up everthing following this link https://video2.skills-academy.com/en-us/azure/event-hubs/event-hubs-kafka-connect-debezium and it's worked.

User's image

User's image

If I set up the connectors like the above image, each table has changed data then a repective eventhub will created such as: table "testdb.employees" -> eventhub "dbserver1.testdb.employees", table "testdb.persons" -> eventhub "dbserver1.testdb.persons".

My question is how can I set up the content of connectors in order to the changes in each table will go to the eventhub "dbserver1" without createing a new eventhub like "dbserver1.testdb.employees", "dbserver1.testdb.persons"?

Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
591 questions
0 comments
Accepted answer
  1. AnnuKumari-MSFT 31,896 Reputation points Microsoft Employee
    2024-01-05T17:25:49.77+00:00

    Hi Eddy Tran ,

    Welcome to Microsoft Q&A platform.

    Here are few of the articles and documentations which might help you in resolving your query. Kindly check the below resources:

    https://debezium.io/documentation/reference/stable/connectors/mysql.html#setting-up-mysql

    https://debezium.io/documentation/reference/0.10/configuration/topic-routing.html

    https://hevodata.com/learn/debezium-mysql/

    Hope it helps. Kindly let us know how it goes. Thankyou

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest