https://my.oschina.net/teddyIH/blog/3102095
然后在MySQL中需要创建一个用户，并授权：
— 使用命令登录：mysql -u root -p
— 创建用户 用户名：canal 密码：Canal@123456
create user ‘canal’@’%’ identified by ‘Canal@123456’;
— 授权 .表示所有库
grant SELECT, REPLICATION SLAVE, REPLICATION CLIENT on . to ‘canal’@’%’ identified by ‘Canal@123456’;

下一步在MySQL配置文件my.cnf设置如下信息：
image.png

查看修改状态
image.png

canal-admin部署

下载镜像

  1. #拉取 canal Admin镜像
  2. $ docker pull canal/canal-admin:v1.1.4

启动容器

  1. #拉取启动脚本
  2. wget https://raw.githubusercontent.com/alibaba/canal/master/docker/run_admin.sh
  4. #运行脚本 此时mysql在docker内部
  5. sh  run_admin.sh -e server.port=8089 \
  6.          -e canal.adminUser=admin \
  7.          -e canal.adminPasswd=admin 
  9. sh  run_admin.sh -e server.port=8089 \
  10.     -e canal.adminUser=admin \
  11.     -e canal.adminPasswd=admin \
  12.     -e spring.datasource.address=39.103.173.206 \
  13.     -e spring.datasource.database=canal_manager_alpha \
  14.     -e spring.datasource.username=root \
  15.     -e spring.datasource.password=Aa11223344
  17. #查看启动日志
  18. $ docker logs canal-admin
  20. DOCKER_DEPLOY_TYPE=VM
  21. ==> INIT /alidata/init/02init-sshd.sh
  22. ==> EXIT CODE: 0
  23. ==> INIT /alidata/init/fix-hosts.py
  24. ==> EXIT CODE: 0
  25. ==> INIT DEFAULT
  26. Generating SSH1 RSA host key:                              [  OK  ]
  27. Starting sshd:                                             [  OK  ]
  28. Starting crond:                                            [  OK  ]
  29. ==> INIT DONE
  30. ==> RUN /home/admin/app.sh
  31. ==> START ...
  32. start mysql ...
  33. Starting mysqld:                                           [  OK  ]
  34. start mysql successful
  35. start admin ...
  36. start canal successful
  37. ==> START SUCCESSFUL ...

数据库脚本

  1. CREATE DATABASE /*!32312 IF NOT EXISTS*/ `canal_manager_alpha` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;
  3. USE `canal_manager_alpha`;
  5. SET NAMES utf8;
  6. SET FOREIGN_KEY_CHECKS = 0;
  8. -- ----------------------------
  9. -- Table structure for canal_adapter_config
  10. -- ----------------------------
  11. DROP TABLE IF EXISTS `canal_adapter_config`;
  12. CREATE TABLE `canal_adapter_config` (
  13.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  14.   `category` varchar(45) NOT NULL,
  15.   `name` varchar(45) NOT NULL,
  16.   `status` varchar(45) DEFAULT NULL,
  17.   `content` text NOT NULL,
  18.   `modified_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  19.   PRIMARY KEY (`id`)
  20. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  22. -- ----------------------------
  23. -- Table structure for canal_cluster
  24. -- ----------------------------
  25. DROP TABLE IF EXISTS `canal_cluster`;
  26. CREATE TABLE `canal_cluster` (
  27.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  28.   `name` varchar(63) NOT NULL,
  29.   `zk_hosts` varchar(255) NOT NULL,
  30.   `modified_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  31.   PRIMARY KEY (`id`)
  32. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  34. -- ----------------------------
  35. -- Table structure for canal_config
  36. -- ----------------------------
  37. DROP TABLE IF EXISTS `canal_config`;
  38. CREATE TABLE `canal_config` (
  39.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  40.   `cluster_id` bigint(20) DEFAULT NULL,
  41.   `server_id` bigint(20) DEFAULT NULL,
  42.   `name` varchar(45) NOT NULL,
  43.   `status` varchar(45) DEFAULT NULL,
  44.   `content` text NOT NULL,
  45.   `content_md5` varchar(128) NOT NULL,
  46.   `modified_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  47.   PRIMARY KEY (`id`),
  48.   UNIQUE KEY `sid_UNIQUE` (`server_id`)
  49. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  51. -- ----------------------------
  52. -- Table structure for canal_instance_config
  53. -- ----------------------------
  54. DROP TABLE IF EXISTS `canal_instance_config`;
  55. CREATE TABLE `canal_instance_config` (
  56.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  57.   `cluster_id` bigint(20) DEFAULT NULL,
  58.   `server_id` bigint(20) DEFAULT NULL,
  59.   `name` varchar(45) NOT NULL,
  60.   `status` varchar(45) DEFAULT NULL,
  61.   `content` text NOT NULL,
  62.   `content_md5` varchar(128) DEFAULT NULL,
  63.   `modified_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  64.   PRIMARY KEY (`id`),
  65.   UNIQUE KEY `name_UNIQUE` (`name`)
  66. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  68. -- ----------------------------
  69. -- Table structure for canal_node_server
  70. -- ----------------------------
  71. DROP TABLE IF EXISTS `canal_node_server`;
  72. CREATE TABLE `canal_node_server` (
  73.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  74.   `cluster_id` bigint(20) DEFAULT NULL,
  75.   `name` varchar(63) NOT NULL,
  76.   `ip` varchar(63) NOT NULL,
  77.   `admin_port` int(11) DEFAULT NULL,
  78.   `tcp_port` int(11) DEFAULT NULL,
  79.   `metric_port` int(11) DEFAULT NULL,
  80.   `status` varchar(45) DEFAULT NULL,
  81.   `modified_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  82.   PRIMARY KEY (`id`)
  83. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  85. -- ----------------------------
  86. -- Table structure for canal_user
  87. -- ----------------------------
  88. DROP TABLE IF EXISTS `canal_user`;
  89. CREATE TABLE `canal_user` (
  90.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  91.   `username` varchar(31) NOT NULL,
  92.   `password` varchar(128) NOT NULL,
  93.   `name` varchar(31) NOT NULL,
  94.   `roles` varchar(31) NOT NULL,
  95.   `introduction` varchar(255) DEFAULT NULL,
  96.   `avatar` varchar(255) DEFAULT NULL,
  97.   `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  98.   PRIMARY KEY (`id`)
  99. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  101. SET FOREIGN_KEY_CHECKS = 1;
  103. -- ----------------------------
  104. -- Records of canal_user
  105. -- ----------------------------
  106. BEGIN;
  107. INSERT INTO `canal_user` VALUES (1, 'admin', '6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9', 'Canal Manager', 'admin', NULL, NULL, '2019-07-14 00:05:28');
  108. COMMIT;
  110. SET FOREIGN_KEY_CHECKS = 1;

访问系统

image.png

部署canal-server

下载镜像

  1. docker pull canal/canal-server:v1.1.4

启动容器

  1. # 下载脚本
  2. wget https://raw.githubusercontent.com/alibaba/canal/master/docker/run.sh
  4. #运行脚本
  5. sh run.sh -e canal.admin.manager=39.103.173.206:8089 \
  6.           -e canal.admin.port=11110 \
  7.           -e canal.admin.user=admin \
  8.           -e canal.admin.passwd=4ACFE3202A5FF5CF467898FC58AAB1D615029441

查看canal-server

image.png