Source Database Type | Source Database Version | Subscribable Data Types |
TencentDB for MySQL | TencentDB for MySQL 5.5.x, 5.6.x, 5.7.x, and 8.0.x | Data update Structure update Full instance |
TencentDB for MariaDB | TencentDB for MariaDB 10.0.10 and 10.1.9 | Data update Structure update Full instance |
TencentDB for MariaDB (Percona) | TencentDB for MariaDB (Percona) 5.6.x and 5.7.x | Data update Structure update Full instance |
TDSQL for MySQL | TDSQL for MySQL 5.6.x, 5.7.x, and 8.0.18 | Data update Structure update Full instance |
TDSQL-C MySQL | TDSQL-C MySQL 5.7.x and 8.0.x | Data update Structure update Full instance |
TDSQL for PostgreSQL | TDSQL for PostgreSQL | Data update |
{"id":"38cecd93-a9c2-11ec-b952-******d8da53:16","type":"dts:MYSQL:INSERT","specversion":"1.0","source":"dts.cloud.tencent","subject":"cdb-xxxx","time":1648109734,"region":"ap-guangzhou","datacontenttype":"application/json;charset=utf-8","tags":null,"data":{"topic":"topic-subs-xxxx-cdb-xxxx","partition":3,"offset":16005,"partition_seq":16006,"event":{"dmlEvent":{"columns":[{"name":"string","originalType":"text"},{"name":"int","originalType":"tinyint(4)"},{"name":"time","originalType":"time"},{"name":"double","originalType":"double"},{"name":"id","originalType":"int(11)","isKey":true},{"name":"float","originalType":"float"},{"name":"longtext","originalType":"longtext"}],"rows":[{"newColumns":[{"dataType":13,"charset":"utf8","bv":"dG1w"},{},{},{"dataType":10,"sv":"1"},{"dataType":3,"sv":"3"},{},{}]}]}},"header":{"sourceType":1,"messageType":2,"timestamp":1648109734,"serverId":109741,"fileName":"mysql-bin.000005","position":2234587,"gtid":"38cecd93-a9c2-11ec-b952-******d8da53:16","schemaName":"dts","tableName":"dts_mysql","seqId":16017,"isLast":true},"eb_consumer_time":"2022-03-24 16:15:34.287359965 +0800 CST m=+1120.357657669","eb_connector":""}}
{"id":"38cecd93-a9c2-11ec-b952-******8da53:19","type":"dts:MYSQL:DDL","specversion":"1.0","source":"dts.cloud.tencent","subject":"cdb-xxxx","time":1648110060,"region":"ap-guangzhou","datacontenttype":"application/json;charset=utf-8","tags":null,"data":{"topic":"topic-subs-aniwxeewm4-cdb-xxxx","partition":0,"offset":16065,"partition_seq":16066,"event":{"ddlEvent":{"schemaName":"dts","sql":"ALTER TABLE `dts_mysql` ADD COLUMN `t` tinyint (0) NULL , ADD UNIQUE `t` USING btree (`t`)"}},"header":{"sourceType":1,"messageType":3,"timestamp":1648110060,"serverId":109741,"fileName":"mysql-bin.000005","position":2235430,"gtid":"38cecd93-a9c2-11ec-b952-******d8da53:19","seqId":16087,"isLast":true},"eb_consumer_time":"2022-03-24 16:21:01.19682088 +0800 CST m=+1447.267118604","eb_connector":""}}
Parameter | Description |
id | Event ID, which is automatically generated by EventBridge. It is the unique ID of an event in EventBridge. |
type | Event type in three-segment format. For a DTS connector, the format is dts:${Database type}:${Operation type} . |
specversion | CloudEvents version, which is 1.0 by default. The value of this parameter is automatically generated by EventBridge. |
source | Event source. For a DTS connector, the value is dts.cloud.tencent . |
subject | Instance on which an event is generated. For a DTS connector, the value of this parameter is the ID of the database instance bound to the data subscription. |
time | Time when an event is delivered to EventBridge. |
region | Region where an event is generated. |
tags | Resource tags. |
data | Binlog content of the database. |
data.topic | Information of the data subscription instance. |
data.partition | Consumer partition. |
data.offset | Consumer offset. |
data.event | There are two types: dmlEvent and ddlEvent . dmlEvent describes the data table schema format and updates. ddlEvent describes specific SQL operations. |
data.header | Operation log header information, including the database name, table name, and update timestamp. |
Was this page helpful?