Canal服务端集群版搭建

1
2
3
4
5
6
7
8
9
10
11
12
13
是否启用了日志
show variables like 'log_bin';
怎样知道当前的日志
show master status;
查看mysql binlog模式
show variables like 'binlog_format';
获取binlog文件列表
show binary logs;
查看当前正在写入的binlog文件
show master statusG
查看指定binlog文件的内容
show binlog events in 'mysql-bin.000002';

1
2
3
server-id=1
log-bin=/var/lib/mysql/mysql-bin

1
2
3
4
5
[mysqld]
log-bin=mysql-bin # 开启 binlog
binlog-format=ROW # 选择 ROW 模式
server_id=1 # 配置 MySQL replaction 需要定义，不要和 canal 的 slaveId 重复

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

1
2
wget https://github.com/alibaba/canal/releases/download/canal-1.1.5-alpha-2/canal.deployer-1.1.5-SNAPSHOT.tar.gz

1
2
3
4
5
6
#创建存储目录
mkdir /usr/local/canal

#解压到目录
tar zxvf canal.deployer-1.1.5-SNAPSHOT.tar.gz  -C /usr/local/canal

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
# 注册服务端的IP,可不配置默认为本机IP
canal.register.ip =

# canal admin相关配置
canal.admin.manager = 10.197.xx.xxx:8089
canal.admin.port = 11110
canal.admin.user = admin
# 密吗详见下方解释
canal.admin.passwd = 4ACFE3202A5FF5CF467898FC58AAB1D615029441
# 自动注册到canal admin开启
canal.admin.register.auto = true
# 注册到canal admin对应的集群名称
# 需要在canal-admin控制台新建集群test,并导入配置模板,并修改部分配置
canal.admin.register.cluster = test

1
2
3
# 指定使用 local 配置启动
sh bin/startup.sh local

1
2
vi logs/canal/canal.log

1
2
vi logs/example/example.log

1
2
sh bin/stop.sh