canal
关注
分享
扫一扫
托马斯小火车喷雾又喷烟，一直喷，喷喷喷.
这个作者很懒，什么都没留下…
展开
-
canal 记录 数据变更类型 QUERY ROWDATA INSERT xxx XXXXX
canal 记录 数据变更类型 QUERY ROWDATA INSERT xxx XXXXX10:40:11.355 [Thread-0] INFO org.canal.CanalClient - executeTime[1642473608000] delayTime[3355] serverId[9] schemaName[] tableName[] binlogName[mysql-bin.000007] position[1847108]10:40:11.356 [Thread-0] INF.原创 2022-01-18 12:57:22 · 34584 阅读 · 3 评论 -
canal 测试批量插入
canal 测试批量插入DROP PROCEDURE IF EXISTS p_insert_canal_test;CREATE PROCEDURE p_insert_canal_test()BEGIN DECLARE v INT DEFAULT 1; WHILE v <= 1000 DO INSERT INTO canal_test VALUE (v, 'a', v, NOW(), 'b'); SET v = v + 1; EN...原创 2022-01-17 09:16:16 · 34324 阅读 · 0 评论 -
canal 记录 ROWDATA TRANSACTIONBEGIN
canal 记录 ROWDATA TRANSACTIONBEGIN09:24:20.418 [Thread-0] INFO org.canal.CanalClient - 当前有[4]条数据需要同步。09:24:20.419 [Thread-0] INFO org.canal.CanalClient - 实体类型 [TRANSACTIONBEGIN]09:24:20.419 [Thread-0] INFO org.canal.util.Transaction - 开启事务...09:24:...原创 2022-01-10 09:36:13 · 34411 阅读 · 0 评论 -
canal delete
canal deleteMessage[id=3,entries=[header { version: 1 logfileName: "mysql-bin.000004" logfileOffset: 1949 serverId: 1 serverenCode: "UTF-8" executeTime: 1641372592000 sourceType: MYSQL schemaName: "" tableName: "" eventLength: 73}en...原创 2022-01-06 12:26:07 · 26005 阅读 · 0 评论 -
canal insert
canal insertinsertafterColumns { index: 0 sqlType: 4 name: "a" isKey: true updated: true isNull: false value: "1" mysqlType: "int(11)"}afterColumns { index: 1 sqlType: 1 name: "b" isKey: false updated: true isNull: false value: "bb" ...原创 2022-01-06 12:24:41 · 34121 阅读 · 0 评论 -
canal 记录
canal 记录Message[id=5,entries=[header { version: 1 logfileName: "mysql-bin.000004" logfileOffset: 1709 serverId: 1 serverenCode: "UTF-8" executeTime: 1641345376000 sourceType: MYSQL schemaName: "" tableName: "" eventLength: 27} entryType: TRANS...原创 2022-01-06 12:23:50 · 34248 阅读 · 0 评论 -
canal 服务 重启后 所有变更全部加载
canal 服务 重启后 所有变更全部加载一、canal服务和canal客户端全部停止二、删除meta.dat三、查看 show binlog events in 'mysql-bin.000003' ;最后一个Pos字段值四、修改instance.properties文件canal.instance.master.address=127.0.0.1:3306canal.instance.master.journal.name=mysql-bin.000003canal.instance.m原创 2022-01-05 09:25:00 · 35010 阅读 · 1 评论 -
canal 服务启动报错
canal 服务启动报错Listening for transport dt_socket at address: 9099Failed to instantiate [ch.qos.logback.classic.LoggerContext]Reported exception:ch.qos.logback.core.LogbackException: Unexpected filename extension of file [file:/D:/Program%20Files/canal.原创 2022-01-04 12:29:30 · 36249 阅读 · 3 评论 -
Windows 安装 两个MySQL MariaDB 两个端口 3306 3307
Windows 安装 两个MySQL MariaDB 两个端口 3306 3307一、将MariaDB 5.5复制一份，改名为MariaDB 5.5_3307。二、修改D:\Program Files\MariaDB 5.5_3307\data\my.ini文件:将第二行 datadir=D:/Program Files/MariaDB 5.5/data 修改为 datadir=D:/Program Files/MariaDB 5.5_3307/data将第三行 port=3306 修改为 po原创 2021-12-31 10:43:02 · 36464 阅读 · 1 评论