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.
Product Consulting FAQs
- What Are Regions and AZs?
- What Is DRS?
- Can DRS Migrate RDS Primary/Standby Instances?
- What Constraints Does DRS Have for a Source Database?
- What Requirements Does DRS Have for a Destination Database?
- Does DRS Use Concurrency?
- Dose DRS Use Data Compression?
- Does DRS Support Migration Between the Public Cloud and the Dedicated Cloud?
- What Is the Quota?
- Does DRS Support Migration from DB2 for LUW to PostgreSQL?
- Can Microsoft SQL Server Database Synchronize Data with Local Databases in Real Time?
- Does DRS Support Data Replication in a Specified Time Period?
- Does DRS Support Resumable Uploads?
- What Is Single-Active/Dual-Active Disaster Recovery?
- What Are the Differences Between Real-Time Migration, Real-Time DR, and Real-Time Synchronization?
- How Do I Solve the Table Bloat Issue During MySQL Migration?
- How Does DRS Affect the Source and Destination Databases?
- Do I Need to Stop Services Running on the Source Database?
- What Is an SMN Topic?
- What Are the Differences Between Single-AZ and Dual-AZ DRS Tasks?
- Can DRS Migrates Table Structures Only?
- How Do I Migrate Accounts in MySQL Migration, Synchronization, and DR Tasks and Can I Change Passwords?
- What Factors Affect the DRS Task Speed and How Do I Estimate the Time Required?
- Can I Modify Objects in a DRS Task?
- Does DRS Support Data Synchronization Between Different Databases of the Same DB Instance?
- Which Operations on the Source or Destination Database Affect the DRS Task Status?
- What Are Differences Between Data Subscription and Synchronization from MySQL to Kafka?
- Why Cannot Standby Read Replicas on Some Other Clouds Be Used as the Source Database?
- Does DRS Support Migration of Users Encrypted by the Caching_sha2_password Plugin?
- Why Is the Database Disk Usage Inconsistent Before and After Data Migration?
- What Is the Serialization Mode of Messages Sent by DRS to Kafka?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore