需要开启binlog日志
准备数据库的url信息
debezium与kafka相配和连接器,版本要匹配
在kafka的connect-distributed.properties当中添加
plugin.path=/soft/kafaka/kafka_2.12-3.4.0/connector
启动连接器
sh connect-distributed.sh …/config/connect-distributed.properties
json配置文件在postman中访问 post kakfa:8083/connectors
{
"name": "inventory-connector", #当在KafkaConnect服务注册时,连接器的名称
"config": {
"connector.class": "io.debezium.connector.mysql.MySqlConnector", #连接器的类名
"database.hostname": "10.10.81.179", #MySQL服务器地址
"database.port": "3306", #msql端口
"database.user": "root", #账号
"database.password": "123456", #密码
"database.server.id": "1" , #mysql的server.id
"topic.prefix": "fullfillment", #topic名称
"database.include.list": "inventory", #要采集的表名
"schema.history.internal.kafka.bootstrap.servers": "10.10.81.171:9092", #kafka节点
"schema.history.internal.kafka.topic": "schemahistory.fullfillment",
"include.schema.changes": "true" #指定连接器是否应该在名为fulfillment可供使用者使用的带有DDL更改的事件
}
}