canal 记录

最新推荐文章于 2024-04-30 09:38:47 发布

原创

最新推荐文章于 2024-04-30 09:38:47 发布 · 3.4w 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#p2p #mysql #sql

这篇博客主要介绍了Canal记录的数据库变更事件，包括TRANSACTIONBEGIN、INSERT和TRANSACTIONEND等类型，展示了如何解析日志中包含的服务器ID、执行时间、事件长度等信息，以及对数据表'canal_test'的INSERT操作详情。

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: TRANSACTIONEND storeValue: "\022\003314",
header { version: 1 logfileName: "mysql-bin.000004" logfileOffset: 1736 serverId: 1 serverenCode: "UTF-8" executeTime: 1641346186000 sourceType: MYSQL schemaName: "" tableName: "" eventLength: 73} entryType: TRANSACTIONBEGIN storeValue: " \n",
header { version: 1 logfileName: "mysql-bin.000004" logfileOffset: 1871 serverId: 1 serverenCode: "UTF-8" executeTime: 1641346186000 sourceType: MYSQL schemaName: "canaldb_a" tableName: "canal_test" eventLength: 51 eventType: INSERT