canal:官方链接
启动canal-admin使用weget命令获取canal1.1.6的文件
wget https://github.com/alibaba/canal/releases/download/canal-1.1.6/canal.admin-1.1.6.tar.gz # 解压文件 tar -zxvf canal.admin-1.1.6.tar.gz
将conf/canal_manager.sql导入到自己相应的数据库中
修改conf/application.yml
server:
port: 8089
spring:
jackson:
date-format: yyyy-MM-dd HH:mm:ss
time-zone: GMT+8
spring.datasource:
address: 127.0.0.1:3306
database: canal_manager
username: canal
password: canal
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://${spring.datasource.address}/${spring.datasource.database}?useUnicode=true&characterEncoding=UTF-8&useSSL=false
hikari:
maximum-pool-size: 30
minimum-idle: 1
canal:
adminUser: admin
adminPasswd: admin
# 切换到bin目录下 sh startup.sh # 在浏览器IP加端口号能访问即可默认用户名 admin/123456启动canal-server
docker方式启动
拉取对应版本的镜像
docker pull canal/canal-server:v1.1.6
先获取启动文件
docker run -itd canal/canal-server:v1.1.6
进入容器
# 9c6659ad63f1 容器启动对应的CONTAINER_ID docker exec -it 9c6659ad63f1 /bin/bash
新建canal目录将容器内canal.properties 文件复制出来
mkdir canal docker cp 9c6659ad63f1:/home/admin/canal-server/conf/canal.properties /root/canal
修改canal.properties文件(原有的内容可全部删除)
# register ip canal.register.ip = # canal admin config canal.admin.manager = 127.0.0.1:8089 canal.admin.port = 11110 canal.admin.user = admin canal.admin.passwd = 4ACFE3202A5FF5CF467898FC58AAB1D615029441 # admin auto register canal.admin.register.auto = true canal.admin.register.cluster =
启动canal-server
# 此处端口可以 -p 10913是本机使用的端口号 11111是容器内使用的端口号 docker run -itd -p 11110:11110 -v /root/canal/canal.properties:/home/admin/canal-server/conf/canal.properties -v /root/canal/logs/:/home/admin/canal-server/logs/ --name cannal-server2 canal/canal-server:v1.1.6
在canal-admin页面刷新即可看见已经注册
docker run -itd -p 3306:3306 -v /root/mysql/data/:/var/lib/mysql -v /root/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /root/mysql/mysql-files:/var/lib/mysql-files -e MYSQL_ROOT_PASSWORD=123456 mysql:8.
my.cnf配置文件
[mysqld] pid-file=/var/run/mysqld/mysqld.pid #socket= /var/run/mysqld/mysqld.sock datadir=/var/lib/mysql #log-error= /var/log/mysqld-error.log #slow-query-log-file= /var/log/slow-query.#log bind-address=0.0.0.0 # 如果使用最简配置,则此行之后的配置可忽略 # 开启binlog server_id=1 log_bin=mysql-bin binlog_format=ROW secure_file_priv= # 设置MySQL日志时区和主机一样;不设置的话默认为UTC log_timestamps=SYSTEM #sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES lower_case_table_names=1 character-set-server=utf8mb4 collation-server=utf8mb4_general_ci



