Kafka Kafka-Connect Debezium 目标:同步Mysql

Kafka Kafka-Connect Debezium 目标:同步Mysql



  • 现阶段实现到 通过以上插件可以实现检测到Mysql 把更改信息通过 Connect 写入到 Kafka的topic中一下是对现阶段的记录。由于需要多个包,采用docker来进行
  1. 首先安装docker
    1. yum install docker
    2. systemctl start docker
  2. 下载镜像 debezium/zookeeper:0.9
    1. docker pull debezium/zookeeper:0.9
    2. 运行zookeeper docker run -it --rm --name zookeeper -p 2181:2181 -p 2888:2888 -p 3888:3888 debezium/zookeeper:0.9
  3. 下载镜像debezium/kafka:0.9
    1. docker pull debezium/kafka:0.9
    2. docker run -it --rm --name kafka -p 9092:9092 --link zookeeper:zookeeper debezium/kafka:0.9
  4. 安装mysql
    1. docker run -it --rm --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=debezium -e MYSQL_USER=mysqluser -e MYSQL_PASSWORD=mysqlpw debezium/example-mysql:0.9
  5. Mysql-client
    1. docker run -it --rm --name mysqlterm --link mysql --rm mysql:5.7 sh -c ‘exec mysql -h"MYSQLPORT3306TCPADDR"−P"MYSQL_PORT_3306_TCP_ADDR" -P"
PS D:\kingbaseProject\crmp-data-syncjob> mvn dependency:tree -Dincludes="io.debezium:*,org.apache.kafka:*" [INFO] Scanning for projects... [INFO] ------------------------------------------------------------------------ [INFO] Reactor Build Order: [INFO] [INFO] 多数据源同步服务 [pom] [INFO] crmp-data-syncjob-common [jar] [INFO] crmp-data-syncjob-domain [jar] [INFO] crmp-data-syncjob-dao [jar] [INFO] crmp-data-syncjob-service [jar] [INFO] crmp-data-syncjob-web [jar] [INFO] [INFO] -------------------< com.crmp.ecc:crmp-data-syncjob >------------------- [INFO] Building 多数据源同步服务 1.0.0-SNAPSHOT [1/6] [INFO] from pom.xml [INFO] --------------------------------[ pom ]--------------------------------- [INFO] [INFO] --- maven-dependency-plugin:3.3.0:tree (default-cli) @ crmp-data-syncjob --- [INFO] com.crmp.ecc:crmp-data-syncjob:pom:1.0.0-SNAPSHOT [INFO] +- io.debezium:debezium-core:jar:1.9.8.Final:compile [INFO] | \- io.debezium:debezium-api:jar:1.9.8.Final:compile [INFO] +- io.debezium:debezium-connector-mysql:jar:1.9.8.Final:compile [INFO] | \- io.debezium:debezium-ddl-parser:jar:1.9.8.Final:compile [INFO] +- io.debezium:debezium-connector-oracle:jar:1.9.8.Final:compile [INFO] +- org.apache.kafka:kafka-clients:jar:3.6.1:compile [INFO] +- org.apache.kafka:connect-api:jar:3.6.1:compile [INFO] +- org.apache.kafka:connect-json:jar:3.6.1:compile [INFO] \- org.apache.kafka:connect-transforms:jar:3.6.1:compile [INFO] [INFO] ---------------< com.crmp.ecc:crmp-data-syncjob-common >---------------- [INFO] Building crmp-data-syncjob-common 1.0.0-SNAPSHOT [2/6] [INFO] from crmp-data-syncjob-common\pom.xml [INFO] --------------------------------[ jar ]--------------------------------- [INFO] [INFO] --- maven-dependency-plugin:3.3.0:tree (default-cli) @ crmp-data-syncjob-common --- [INFO] com.crmp.ecc:crmp-data-syncjob-common:jar:1.0.0-SNAPSHOT [INFO] +- io.debezium:debezium-core:jar:1.9.8.Final:compile [INFO] | \- io.debezium:debezium-api:jar:1.9.8.Final:compile [INFO] +- io.debezium:debezium-connector-mysql:jar:1.9.8.Final:compile [INFO] | \- io.debezium:debezium-ddl-parser:jar:1.9.8.Final:compile [INFO] +- io.debezium:debezium-connector-oracle:jar:1.9.8.Final:compile [INFO] +- org.apache.kafka:kafka-clients:jar:3.6.1:compile [INFO] +- org.apache.kafka:connect-api:jar:3.6.1:compile [INFO] +- org.apache.kafka:connect-json:jar:3.6.1:compile [INFO] \- org.apache.kafka:connect-transforms:jar:3.6.1:compile [INFO] [INFO] ---------------< com.crmp.ecc:crmp-data-syncjob-domain >---------------- [INFO] Building crmp-data-syncjob-domain 1.0.0-SNAPSHOT [3/6] [INFO] from crmp-data-syncjob-domain\pom.xml [INFO] --------------------------------[ jar ]--------------------------------- [INFO] [INFO] --- maven-dependency-plugin:3.3.0:tree (default-cli) @ crmp-data-syncjob-domain --- [INFO] com.crmp.ecc:crmp-data-syncjob-domain:jar:1.0.0-SNAPSHOT [INFO] +- io.debezium:debezium-core:jar:1.9.8.Final:compile [INFO] | \- io.debezium:debezium-api:jar:1.9.8.Final:compile [INFO] +- io.debezium:debezium-connector-mysql:jar:1.9.8.Final:compile [INFO] | \- io.debezium:debezium-ddl-parser:jar:1.9.8.Final:compile [INFO] +- io.debezium:debezium-connector-oracle:jar:1.9.8.Final:compile [INFO] +- org.apache.kafka:kafka-clients:jar:3.6.1:compile [INFO] +- org.apache.kafka:connect-api:jar:3.6.1:compile [INFO] +- org.apache.kafka:connect-json:jar:3.6.1:compile [INFO] \- org.apache.kafka:connect-transforms:jar:3.6.1:compile [INFO] [INFO] -----------------< com.crmp.ecc:crmp-data-syncjob-dao >----------------- [INFO] Building crmp-data-syncjob-dao 1.0.0-SNAPSHOT [4/6] [INFO] from crmp-data-syncjob-dao\pom.xml [INFO] --------------------------------[ jar ]--------------------------------- [INFO] [INFO] --- maven-dependency-plugin:3.3.0:tree (default-cli) @ crmp-data-syncjob-dao --- [INFO] com.crmp.ecc:crmp-data-syncjob-dao:jar:1.0.0-SNAPSHOT [INFO] +- io.debezium:debezium-core:jar:1.9.8.Final:compile [INFO] | \- io.debezium:debezium-api:jar:1.9.8.Final:compile [INFO] +- io.debezium:debezium-connector-mysql:jar:1.9.8.Final:compile [INFO] | \- io.debezium:debezium-ddl-parser:jar:1.9.8.Final:compile [INFO] +- io.debezium:debezium-connector-oracle:jar:1.9.8.Final:compile [INFO] +- org.apache.kafka:kafka-clients:jar:3.6.1:compile [INFO] +- org.apache.kafka:connect-api:jar:3.6.1:compile [INFO] +- org.apache.kafka:connect-json:jar:3.6.1:compile [INFO] \- org.apache.kafka:connect-transforms:jar:3.6.1:compile [INFO] [INFO] ---------------< com.crmp.ecc:crmp-data-syncjob-service >--------------- [INFO] Building crmp-data-syncjob-service 1.0.0-SNAPSHOT [5/6] [INFO] from crmp-data-syncjob-service\pom.xml [INFO] --------------------------------[ jar ]--------------------------------- [INFO] [INFO] --- maven-dependency-plugin:3.3.0:tree (default-cli) @ crmp-data-syncjob-service --- [INFO] com.crmp.ecc:crmp-data-syncjob-service:jar:1.0.0-SNAPSHOT [INFO] +- io.debezium:debezium-core:jar:1.9.8.Final:compile [INFO] | \- io.debezium:debezium-api:jar:1.9.8.Final:compile [INFO] +- io.debezium:debezium-connector-mysql:jar:1.9.8.Final:compile [INFO] | \- io.debezium:debezium-ddl-parser:jar:1.9.8.Final:compile [INFO] +- io.debezium:debezium-connector-oracle:jar:1.9.8.Final:compile [INFO] +- org.apache.kafka:kafka-clients:jar:3.6.1:compile [INFO] +- org.apache.kafka:connect-api:jar:3.6.1:compile [INFO] +- org.apache.kafka:connect-json:jar:3.6.1:compile [INFO] \- org.apache.kafka:connect-transforms:jar:3.6.1:compile [INFO] [INFO] -----------------< com.crmp.ecc:crmp-data-syncjob-web >----------------- [INFO] Building crmp-data-syncjob-web 1.0.0-SNAPSHOT [6/6] [INFO] from crmp-data-syncjob-web\pom.xml [INFO] --------------------------------[ jar ]--------------------------------- [INFO] [INFO] --- maven-dependency-plugin:3.3.0:tree (default-cli) @ crmp-data-syncjob-web --- [INFO] com.crmp.ecc:crmp-data-syncjob-web:jar:1.0.0-SNAPSHOT [INFO] +- io.debezium:debezium-core:jar:1.9.8.Final:compile [INFO] | \- io.debezium:debezium-api:jar:1.9.8.Final:compile [INFO] +- io.debezium:debezium-connector-mysql:jar:1.9.8.Final:compile [INFO] | \- io.debezium:debezium-ddl-parser:jar:1.9.8.Final:compile [INFO] +- io.debezium:debezium-connector-oracle:jar:1.9.8.Final:compile [INFO] +- org.apache.kafka:kafka-clients:jar:3.6.1:compile [INFO] +- org.apache.kafka:connect-api:jar:3.6.1:compile [INFO] +- org.apache.kafka:connect-json:jar:3.6.1:compile [INFO] \- org.apache.kafka:connect-transforms:jar:3.6.1:compile [INFO] ------------------------------------------------------------------------ [INFO] Reactor Summary for 多数据源同步服务 1.0.0-SNAPSHOT: [INFO] [INFO] 多数据源同步服务 ........................................... SUCCESS [ 1.667 s] [INFO] crmp-data-syncjob-common ........................... SUCCESS [ 0.128 s] [INFO] crmp-data-syncjob-domain ........................... SUCCESS [ 0.065 s] [INFO] crmp-data-syncjob-dao .............................. SUCCESS [ 0.079 s] [INFO] crmp-data-syncjob-service .......................... SUCCESS [ 0.090 s] [INFO] crmp-data-syncjob-web .............................. SUCCESS [ 0.075 s] [INFO] ------------------------------------------------------------------------ [INFO] BUILD SUCCESS [INFO] ------------------------------------------------------------------------ [INFO] Total time: 2.571 s [INFO] Finished at: 2025-11-25T14:41:40+08:00 [INFO] ------------------------------------------------------------------------
最新发布
11-26
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值