tencent cloud

Feedback

Databases Supported by Data Subscription

Last updated: 2023-09-05 14:35:03
Data subscription refers to the process where DTS gets the data change information of a key business in the database, converts it into message objects, and pushes them to Kafka for the downstream businesses to subscribe to, obtain, and consume. DTS allows you to directly consume data through a Kafka/Flink client, so that you can implement data sync between TencentDB databases and heterogeneous systems, such as cache update, real-time ETL (a data warehousing technology) sync, and async business decoupling.
Subscribed data in Protobuf, Avro, or JSON formats can be consumed. ProtoBuf and Avro adopt the binary format with higher consumption efficiency, while JSON adopts the easier-to-use lightweight text format.
DTS supports data subscription for the following types of databases.
Source Database Type
Source Database Version
Subscribable Data Type
Format of Subscribed Data
Format of Data Subscribed by Flink (DataStream API)
MySQL
Self-built MySQL 5.5, 5.6, 5.7, 8.0
TencentDB for MySQL 5.5, 5.6, 5.7, 8.0
Data update
Structure update
Full instance
Protobuf/Avro/JSON
Avro
MariaDB
Self-built MariaDB 5.5, 10.0, 10.1
TencentDB for MariaDB (kernel version: Percona 5.7, MySQL 8.0, and MariaDB 10.1)
Data update
Structure update
Full instance
Protobuf
Not supported
Percona
Self-built Percona 5.5, 5.6, 5.7, 8.0
Data update
Structure update
Full instance
Protobuf
Not supported
TDSQL for MySQL
TDSQL for MySQL (kernel version :MySQL 8.0 and Percona 5.7)
Data update
Structure update
Full instance
Protobuf
Protobuf
TDSQL-C for MySQL
TDSQL-C for MySQL 5.7, 8.0
Data update
Structure update
Full instance
Protobuf/Avro/JSON
Avro
TDSQL for PostgreSQL
TDSQL for PostgreSQL
Data update
Protobuf
Not supported
MongoDB
TencentDB for MongoDB 3.6, 4.0, 4.2, 4.4
Data update
JSON
Not supported

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support