CREATE TABLE IF NOT EXISTS `meta_snapshot` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '修改时间',
`destination` varchar(128) DEFAULT NULL COMMENT '通道名称',
`binlog_file` varchar(64) DEFAULT NULL COMMENT 'binlog文件名',
`binlog_offest` bigint(20) DEFAULT NULL COMMENT 'binlog偏移量',
`binlog_master_id` varchar(64) DEFAULT NULL COMMENT 'binlog节点id',
`binlog_timestamp` bigint(20) DEFAULT NULL COMMENT 'binlog应用的时间戳',
`data` longtext DEFAULT NULL COMMENT '表结构数据',
`extra` text DEFAULT NULL COMMENT '额外的扩展信息',
PRIMARY KEY (`id`),
UNIQUE KEY binlog_file_offest(`destination`,`binlog_master_id`,`binlog_file`,`binlog_offest`),
KEY `destination` (`destination`),
KEY `destination_timestamp` (`destination`,`binlog_timestamp`),
KEY `gmt_modified` (`gmt_modified`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='表结构记录表快照表';
CREATE TABLE IF NOT EXISTS `meta_history` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '修改时间',
`destination` varchar(128) DEFAULT NULL COMMENT '通道名称',
`binlog_file` varchar(64) DEFAULT NULL COMMENT 'binlog文件名',
`binlog_offest` bigint(20) DEFAULT NULL COMMENT 'binlog偏移量',
`binlog_master_id` varchar(64) DEFAULT NULL COMMENT 'binlog节点id',
`binlog_timestamp` bigint(20) DEFAULT NULL COMMENT 'binlog应用的时间戳',
`use_schema` varchar(1024) DEFAULT NULL COMMENT '执行sql时对应的schema',
`sql_schema` varchar(1024) DEFAULT NULL COMMENT '对应的schema',
`sql_table` varchar(1024) DEFAULT NULL COMMENT '对应的table',
`sql_text` longtext DEFAULT NULL COMMENT '执行的sql',
`sql_type` varchar(256) DEFAULT NULL COMMENT 'sql类型',
`extra` text DEFAULT NULL COMMENT '额外的扩展信息',
PRIMARY KEY (`id`),
UNIQUE KEY binlog_file_offest(`destination`,`binlog_master_id`,`binlog_file`,`binlog_offest`),
KEY `destination` (`destination`),
KEY `destination_timestamp` (`destination`,`binlog_timestamp`),
KEY `gmt_modified` (`gmt_modified`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='表结构变化明细表';
阿里canal组件:canal.deployer-1.1.7-SNAPSHOT.tar.gz
需积分: 0 143 浏览量
2023-01-06
09:27:47
上传
评论
收藏 102.43MB GZ 举报
canal.deployer-1.1.7-SNAPSHOT.tar.gz （89个子文件） 
lib 
canal.filter-1.1.7-SNAPSHOT.jar 11KB commons-io-2.4.jar 181KB canal.sink-1.1.7-SNAPSHOT.jar 17KB j2objc-annotations-1.1.jar 9KB mybatis-spring-2.0.4.jar 67KB canal.common-1.1.7-SNAPSHOT.jar 44KB fastjson2-2.0.15.jar 1.52MB httpclient-4.5.1.jar 716KB spring-jdbc-5.0.5.RELEASE.jar 392KB spring-expression-5.0.5.RELEASE.jar 271KB canal.instance.core-1.1.7-SNAPSHOT.jar 7KB joda-time-2.9.4.jar 615KB canal.server-1.1.7-SNAPSHOT.jar 65KB zookeeper-3.4.5.jar 762KB spring-aop-5.0.5.RELEASE.jar 357KB aviator-2.2.1.jar 433KB protobuf-java-3.6.1.jar 1.36MB spring-jcl-5.0.5.RELEASE.jar 21KB jctools-core-2.1.2.jar 246KB spring-beans-5.0.5.RELEASE.jar 645KB spring-orm-5.0.5.RELEASE.jar 187KB commons-lang3-3.7.jar 488KB logback-core-1.1.3.jar 444KB h2-1.4.196.jar 1.74MB netty-all-4.1.6.Final.jar 3.37MB simpleclient_common-0.4.0.jar 6KB canal.parse.dbsync-1.1.7-SNAPSHOT.jar 113KB canal.parse-1.1.7-SNAPSHOT.jar 218KB oro-2.0.8.jar 64KB zkclient-0.10.jar 73KB simpleclient_hotspot-0.4.0.jar 17KB canal.deployer-1.1.7-SNAPSHOT.jar 46KB jsr305-3.0.2.jar 19KB commons-lang-2.6.jar 278KB logback-classic-1.1.3.jar 274KB commons-compress-1.9.jar 369KB mybatis-3.5.4.jar 1.65MB jcl-over-slf4j-1.7.12.jar 16KB commons-codec-1.9.jar 258KB canal.meta-1.1.7-SNAPSHOT.jar 28KB canal.store-1.1.7-SNAPSHOT.jar 24KB spring-core-5.0.5.RELEASE.jar 1.17MB slf4j-api-1.7.12.jar 31KB canal.parse.driver-1.1.7-SNAPSHOT.jar 74KB connector.core-1.1.7-SNAPSHOT.jar 56KB mysql-connector-java-5.1.48.jar 983KB simpleclient_pushgateway-0.4.0.jar 6KB disruptor-3.4.2.jar 81KB javax.annotation-api-1.3.2.jar 26KB canal.protocol-1.1.7-SNAPSHOT.jar 393KB simpleclient_httpserver-0.4.0.jar 9KB druid-1.2.15.jar 3.65MB canal.instance.spring-1.1.7-SNAPSHOT.jar 10KB commons-logging-1.2.jar 60KB commons-beanutils-1.8.2.jar 226KB spring-context-5.0.5.RELEASE.jar 1.04MB canal.prometheus-1.1.7-SNAPSHOT.jar 43KB canal.instance.manager-1.1.7-SNAPSHOT.jar 45KB guava-22.0.jar 2.46MB httpcore-4.4.3.jar 319KB error_prone_annotations-2.0.18.jar 12KB simpleclient-0.4.0.jar 58KB netty-3.2.2.Final.jar 767KB animal-sniffer-annotations-1.14.jar 3KB spring-tx-5.0.5.RELEASE.jar 249KB bin 
startup.sh 4KB restart.sh 226B stop.sh 1KB startup.bat 1KB plugin connector.kafka-1.1.7-SNAPSHOT-jar-with-dependencies.jar 24.37MB connector.rocketmq-1.1.7-SNAPSHOT-jar-with-dependencies.jar 9.42MB connector.rabbitmq-1.1.7-SNAPSHOT-jar-with-dependencies.jar 625KB connector.pulsarmq-1.1.7-SNAPSHOT-jar-with-dependencies.jar 50.32MB logs conf metrics Canal_instances_tmpl.json 31KB logback.xml 4KB spring tsdb sql-map sqlmap_history.xml 2KB sqlmap-config.xml 636B sqlmap_snapshot.xml 2KB sql create_table.sql 2KB h2-tsdb.xml 3KB mysql-tsdb.xml 4KB base-instance.xml 2KB group-instance.xml 15KB default-instance.xml 11KB memory-instance.xml 10KB file-instance.xml 10KB canal.properties 7KB canal_local.properties 319B example instance.properties 2KB资源评论
