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.deployer-1.1.6
5星 · 超过95%的资源 需积分: 3 176 浏览量
2022-06-22
23:53:20
上传
评论
收藏 102.19MB GZ 举报 
canal.deployer-1.1.6.tar.gz （89个子文件） 
bin 
stop.sh 1KB restart.sh 226B startup.bat 1KB startup.sh 4KB conf metrics Canal_instances_tmpl.json 31KB canal.properties 6KB logback.xml 4KB spring memory-instance.xml 10KB group-instance.xml 15KB tsdb sql-map sqlmap_history.xml 2KB sqlmap_snapshot.xml 2KB sqlmap-config.xml 636B sql create_table.sql 2KB mysql-tsdb.xml 4KB h2-tsdb.xml 3KB default-instance.xml 11KB file-instance.xml 10KB base-instance.xml 2KB canal_local.properties 319B example instance.properties 2KB lib 
j2objc-annotations-1.1.jar 9KB canal.server-1.1.6.jar 65KB druid-1.2.11.jar 3.54MB simpleclient_httpserver-0.4.0.jar 9KB canal.common-1.1.6.jar 44KB protobuf-java-3.6.1.jar 1.36MB fastjson2-2.0.7.jar 1.38MB netty-3.2.2.Final.jar 767KB canal.parse-1.1.6.jar 218KB canal.store-1.1.6.jar 24KB error_prone_annotations-2.0.18.jar 12KB spring-tx-5.0.5.RELEASE.jar 249KB animal-sniffer-annotations-1.14.jar 3KB mysql-connector-java-5.1.48.jar 983KB spring-core-5.0.5.RELEASE.jar 1.17MB commons-lang-2.6.jar 278KB disruptor-3.4.2.jar 81KB spring-jdbc-5.0.5.RELEASE.jar 392KB canal.instance.spring-1.1.6.jar 10KB spring-aop-5.0.5.RELEASE.jar 357KB jcl-over-slf4j-1.7.12.jar 16KB canal.instance.manager-1.1.6.jar 45KB commons-logging-1.2.jar 60KB logback-core-1.1.3.jar 444KB joda-time-2.9.4.jar 615KB spring-expression-5.0.5.RELEASE.jar 271KB h2-1.4.196.jar 1.74MB commons-beanutils-1.8.2.jar 226KB simpleclient_common-0.4.0.jar 6KB canal.meta-1.1.6.jar 28KB canal.instance.core-1.1.6.jar 7KB oro-2.0.8.jar 64KB simpleclient-0.4.0.jar 58KB canal.deployer-1.1.6.jar 46KB spring-jcl-5.0.5.RELEASE.jar 21KB aviator-2.2.1.jar 433KB spring-orm-5.0.5.RELEASE.jar 187KB guava-22.0.jar 2.46MB simpleclient_pushgateway-0.4.0.jar 6KB httpclient-4.5.1.jar 716KB spring-beans-5.0.5.RELEASE.jar 645KB logback-classic-1.1.3.jar 274KB jctools-core-2.1.2.jar 246KB canal.filter-1.1.6.jar 11KB simpleclient_hotspot-0.4.0.jar 17KB mybatis-3.5.4.jar 1.65MB canal.sink-1.1.6.jar 17KB commons-codec-1.9.jar 258KB mybatis-spring-2.0.4.jar 67KB javax.annotation-api-1.3.2.jar 26KB zkclient-0.10.jar 73KB spring-context-5.0.5.RELEASE.jar 1.04MB netty-all-4.1.6.Final.jar 3.37MB canal.parse.dbsync-1.1.6.jar 107KB commons-io-2.4.jar 181KB zookeeper-3.4.5.jar 762KB canal.protocol-1.1.6.jar 392KB slf4j-api-1.7.12.jar 31KB connector.core-1.1.6.jar 53KB commons-compress-1.9.jar 369KB httpcore-4.4.3.jar 319KB canal.prometheus-1.1.6.jar 43KB canal.parse.driver-1.1.6.jar 74KB jsr305-3.0.2.jar 19KB commons-lang3-3.7.jar 488KB plugin connector.kafka-1.1.6-jar-with-dependencies.jar 24.37MB connector.pulsarmq-1.1.6-jar-with-dependencies.jar 50.32MB connector.rabbitmq-1.1.6-jar-with-dependencies.jar 625KB connector.rocketmq-1.1.6-jar-with-dependencies.jar 9.42MB logs 
评论5