- 安装:docker pull nacos/nacos-server
- 启动:docker run ‐p 11111:11111 ‐‐name canal ‐d docker.io/canal/canal‐server
如何配置监听?
1) 配置mysql的binlog 并且设置格式为row(表示没次修改都对应一条日志)
show VARIABLES like “%log_bin%”
set global binlog_format=ROW;
2)创建账号并授权
create user canal@’%’ IDENTIFIED by ‘canal’;
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT,SUPER ON . TO ‘canal’@’%’;
FLUSH PRIVILEGES;
3)重启mysql docker restart mysql;
4)查看是否配置成功
5)配置canal-server
1.修改/home/admin/canal-server/conf/canal.properties 新增一个id标示
2.修改/home/admin/canal-server/conf/example/instance.properties 变化的数据库以及表,