526互联

Canal安装部署

发布时间 2023-07-18 20:27:23作者: lwx_R

1.下载安装包解压

2.mysql配置

2.1 启动binlog功能

  • 查看是否启动
show variables like 'binlog_format%'
  • 修改my.cnf配置
log-bin=mysql-bin #添加这一行就 ok   
binlog-format=ROW #选择 row 模式    
server_id=1       #配置 mysql replaction 需要定义，不能和canal的slaveId重复

2.2 赋权限

CREATE USER canal IDENTIFIED BY 'canal';
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%';    
-- GRANT ALL PRIVILEGES ON *.* TO 'canal'@'%' ;    
FLUSH PRIVILEGES;

3.修改配置

  • conf/example/instance.properties
# username/password
canal.instance.dbUsername=root
canal.instance.dbPassword=
  • bin/startup.cmd
set CANAL_OPTS= -DappName=otter-canal -Dlogback.configurationFile="D:\Code\Canal\conf\logback.xml" -Dcanal.conf="%canal_conf%"

4.启动

启动startup.cmd