debezium 订阅mysql The ‘topic.prefix‘ value is invalid: A value is required

原创已于 2022-12-04 15:25:11 修改 · 1.7k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #kafka #数据库

于 2022-12-04 14:57:50 首次发布

本文介绍了使用Docker搭建MySQL+Debezium+kafka+logstash+elasticsearch过程中遇到的问题，重点讨论了Debezium无法订阅MySQL的具体配置及解决办法。

想搭建mysql+debezium+kafka+logstash+elasticsearch
目前mysql、kafka、debezium都已经搭建成功，但是到debezium订阅mysql死活订阅不上去，百度也搜索不到相关信息
mysql debezium都是用docker搭建
kafka是linux环境搭建
在这里插入图片描述

{
    "name": "mysql-world-connector001",
    "config": {
        "connector.class": "io.debezium.connector.mysql.MySqlConnector",
        "tasks.max": "1",
        "database.hostname": "192.168.16.132",
        "database.port": "3306",
        "database.user": "root",
        "database.password": "123456",
        "database.server.id": "3306",
        "database.server.name": "world",
        "database.include.list": "world",
        "database.history.kafka.bootstrap.servers": "192.168.16.132:9092",
        "database.history.kafka.topic": "dbhistory.world",
        "include.schema.changes": "true",
        "database.allowPublicKeyRetrieval": "true"
    }
}


{
    "error_code": 400,
    "message": "Connector configuration is invalid and contains the following 1 error(s):\nThe 'topic.prefix' value is invalid: A value is required\nYou can also find the above list of errors at the endpoint `/connector-plugins/{connectorType}/config/validate`"
}