Help Center/ Data Replication Service/ FAQs/ Product Consulting/ What Are Differences Between Data Subscription and Synchronization from MySQL to Kafka?
Updated on 2024-11-30 GMT+08:00
View PDF
Share

What Are Differences Between Data Subscription and Synchronization from MySQL to Kafka?

Item

MySQL-to-Kafka Synchronization

Data Subscription

Supported source databases
  • Huawei Cloud RDS for MySQL instances
  • On-premises MySQL databases
  • MySQL databases on ECSs
  • MySQL databases on other clouds

Huawei Cloud RDS for MySQL instances

Supported networks

Public network, VPCs, VPNs, and Direct Connect networks

Only VPCs are supported. As the entire-subnet route is not enabled, container-based networks in a VPC are not supported.

Data format

Avro, JSON, and JSON-C

SDK

Data Type

Full+incremental data

Incremental data

Synchronization object

Table data and table structure

Data update and structure update

Stability

There are task alarms and monitoring, DRS automatically retries tasks upon exceptions.

There are not task alarms and monitoring, you need to manually retry tasks upon exceptions.

Performance

Multiple specifications are supported and can be selected based on different performance requirements.

Specifications cannot be selected. Only the performance of the minimum specifications is supported.

Commercial state

In commercial use, you will be charged for using this feature.

In open beta testing (OBT), this feature is free of charge.

A subscription task has many subscription objects and operation constraints. You are advised to use the synchronization from MySQL to Kafka with higher performance and stability for data subscription.

Parent topic: Product Consulting