–canal server安装
1.下载安装包 canal.deployer-1.1.4.tar.gz
https://github.com/alibaba/canal/releases
2.解压
进入安装目录:cd /usr
创建canal存放目录:mkdir canal
进入创建好的目录:cd canal
解压安装包:tar -zxvf canal.deployer-1.1.4.tar.gz
–canal admin安装
1.下载安装包 canal.admin-1.1.4.tar.gz
https://github.com/alibaba/canal/releases
2.解压
进入安装目录:cd /usr
创建canal存放目录:mkdir canal-admin
进入创建好的目录:cd canal-admin
解压安装包:tar -zxvf canal.admin-1.1.4.tar.gz
3.连接mysql并配置元数据库
mysql -h hadoop1 -u root -p
source /usr/canal-admin/conf/canal_manager.sql #执行sql会自动创建canal_manager库以及相应的表
GRANT ALL ON canal_manager.* TO ‘canal’@‘hadoop1’ IDENTIFIED BY ‘admin123A!’; #如果有需求还需要配置权限
flush privileges;
4.修改canal admin配置
#vi /usr/canal-admin/conf/application.yml
erver:
port: 8089 #admin ui界面端口
spring:
jackson:
date-format: yyyy-MM-dd HH:mm:ss
time-zone: GMT+8
spring.datasource:
address: hadoop1:3306 #admin元数据库访问
database: canal_manager
username: canal
password: admin123A!
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://
s
p
r
i
n
g
.
d
a
t
a
s
o
u
r
c
e
.
a
d
d
r
e
s
s
/
{spring.datasource.address}/
spring.datasource.address/{spring.datasource.database}?useUnicode=true&characterEncoding=UTF-8&useSSL=false
hikari:
maximum-pool-size: 30
minimum-idle: 1
canal:
adminUser: admin #admin ui账号密码
adminPasswd: 123456
5.修改canal server配置(每个节点都需要)
vi /usr/canal/conf/canal_local.properties
#register ip
canal.register.ip = 172.18.149.169 #该server本机IP,为防止一个机器多个IP
#canal admin config
canal.admin.manager = hadoop1:8089 #admin UI界面端口
canal.admin.port = 11110
canal.admin.user = admin #admin 账号
canal.admin.passwd = 6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 #加密之后的admin密码 mysql>select password(123456);
#admin auto register
canal.admin.register.auto = true #是否为集群模式
canal.admin.register.cluster = canal #集群名称
6.要先启动canal-admin,然后登陆UI界面进行配置,创建集群并配置集群参数(该参数会覆盖每个server上的参数文件)
sh /usr/canal-admin/bin/startup.sh
http://hadoop1:8089/ #登陆UI界面
#配置集群名称和ZK地址
canal
hadoop1:2181,hadoop2:2181,hadoop3:2181
7.启动canal server
sh /usr/canal/bin/startup.sh local #一切正常的情况下,页面上可以显示该server,如果不显示查看日志解决问题
8.创建实例,配置实例