使用canal 监听mysql binlog获取增量数据
配置mysql
sudo vi /etc/my.cnf
[mysqld]
log-bin=/var/lib/mysql/mysql-bin
binlog-format=ROW
server_id=1
添加canal用户,修改权限
CREATE USER canal IDENTIFIED BY 'canal';
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%';
FLUSH PRIVILEGES;
.
原创
2020-05-24 16:39:33 ·
1396 阅读 ·
0 评论