参考文章:Canal - 安装    https://www.aliyun.com/jiaocheng/1131288.html?spm=5176.100033.2.7.7b422237XAirIe

前提摘要:mysql的binlog要开启状态,并配置binlog模式为row。

canal下载地址:   https://github.com/alibaba/canal/releases

在mysql创建 canal 账号并且赋予可以复制repication的权限

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

 

posted on 2018-10-18 09:10  zhaoqiang1980  阅读(115)  评论(0编辑  收藏  举报