docker canal + canal-php 部署

版本：canal-server v1.1.5 + mysql 5.7 + canal-php

canal-server默认端口是11111，确保这个端口不被占用

一、mysql配置

• mysql开启binlog
  需要注意的是mysql server-id需要跟canal的slaveId不一样，canal默认为0

# my.cnf
log-bin=mysql-bin
binlog-format=ROW
server_id=1 

• 创建canal用户
  canal连接mysql默认的账户和密码都是canal
  grant SELECT, REPLICATION SLAVE, REPLICATION CLIENT on *.* to 'canal'@'%' identified by "canal";
flush privileges;

二、canal配置

• 拉取canal镜像
  docker pull canal/canal-server:v1.1.5
• 复制配置文件

### instance.properties  目录 /home/admin/canal-server/conf/example
canal.instance.gtidon=false
# position info
canal.instance.master.address=[本机ipv4]:3306
canal.instance.master.journal.name=
canal.instance.master.position=
canal.instance.master.timestamp=
canal.instance.master.gtid=
# rds oss binlog
canal.instance.rds.accesskey=
canal.instance.rds.secretkey=
canal.instance.rds.instanceId=
# table meta tsdb info
canal.instance.tsdb.enable=true
# username/password
canal.instance.dbUsername=canal
canal.instance.dbPassword=canal
canal.instance.connectionCharset = UTF-8
# enable druid Decrypt database password
canal.instance.enableDruid=false
# table regex
canal.instance.filter.regex=backendorder\\.t_kry_takeout_.*,backendorder\\.t_kry_product_.*,backendshare\\.t_backend_keruyun_bom_.*,backend\\.t_wx_.*
# table black regex
canal.instance.filter.black.regex=mysql\\.slave_.*
# mq config
canal.mq.topic=example
canal.mq.partition=0

• 创建canal容器
  docker run -d -v [本机文件位置]:/home/admin/canal-server/conf/example/instance.properties -p 11111:11111 --name canal canal/canal-server:v1.1.5
  查看/home/admin/canal-server/logs/example/example.log查看与数据库的连接情况

三、canal-php配置

• 拉取代码

$ composer require xingwenge/canal_php

或者直接下载

$ git clone https://github.com/xingwenge/canal-php.git

• 运行测试

  
  image.png