canal

1. canal admin 连接mysql 8.0 后 启动报 Unknown system variable ‘query_cache_size’
   原因是mysql连接包的版本太低了。将lib下的 mysql连接包，替换成 mysql-connector-java-8.0.22.jar

2. canal 针对 分库分表正则表达式
   canal.mq.dynamicTopic=vip_center_dev:ssc_vip_center(\d+)?\.vip_member(\d+);vip_center_dev:ssc_vip_center(\d+)?\.vip_member_info(\d+);vip_center_dev:ssc_vip_center(\d+)?\.vip_member_wxmp(\d+);vip_center_dev:ssc_vip_center.vip_member_brand;vip_center_dev:ssc_vip_center(\d+)?\.vip_member_point(\d+);vip_center_dev:ssc_vip_center(\d+)?\.vip_member_level(\d+);vip_center_dev:ssc_vip_center(\d+)?\.vip_member_tag(\d+);vip_center_dev:ssc_vip_center(\d+)?\.vip_member_last_position(\d+);vip_center_dev:ssc_vip_center(\d+)?\.vip_member_platform(\d+);vip_center_dev:ssc_vip_center(\d+)?\.vip_member_point_record(\d+);vip_center_dev:ssc_vip_center(\d+)?\.vip_member_growth_record(\d+);vip_center_dev:ssc_vip_center(\d+)?\.vip_member_scan_analysis(\d+);

3. canal admin控制台修改密码
   最新版本不用配置文件中的密码，在canal_manager.canal_user.password 设置密码 密码生成方式: String password = com.alibaba.otter.canal.protocol.SecurityUtil.scrambleGenPass(“admin123”.getBytes());