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 |
| 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.