This topic provides an introduction to the zero-ETL feature. This topic also describes the benefits, release date, and billing rules of the zero-ETL feature.
Introduction
ApsaraDB RDS provides the zero-ETL feature to synchronize data from an ApsaraDB RDS for MySQL instance to a data warehouse. You do not need to create or maintain data synchronization tasks, and you are not charged for data synchronization tasks. This reduces data transmission costs and O&M costs. The data warehouse can be an AnalyticDB for MySQL cluster or an ApsaraDB for ClickHouse cluster.
Benefits
Ease of use: You do not need to create or maintain complex data pipelines to perform extract, transform, and load (ETL) operations. You need to only select the source instance and destination cluster to create real-time data synchronization tasks. This reduces the challenges of building and managing data pipelines and allows you to focus on application development.
Zero cost: You can create zero-ETL tasks to synchronize data to a data warehouse free of charge for data analysis.
Multi-source aggregation: You can create a zero-ETL task to synchronize data from multiple ApsaraDB RDS for MySQL instances to an AnalyticDB for MySQL cluster or an ApsaraDB for ClickHouse cluster in real time to build a global analysis perspective.
NoteIf you synchronize data from multiple ApsaraDB RDS for MySQL instances to an ApsaraDB for ClickHouse cluster, make sure that the objects to be synchronized do not overlap within different tasks.
Prerequisites
An ApsaraDB RDS for MySQL instance is created. For more information, see Create an ApsaraDB RDS for MySQL instance.
An ApsaraDB for ClickHouse cluster or an AnalyticDB for MySQL Data Warehouse Edition cluster is created. For more information, see Create a ClickHouse instance and Create a Data Warehouse Edition cluster.
The ApsaraDB RDS for MySQL instance and the ApsaraDB for ClickHouse cluster or the AnalyticDB for MySQL cluster reside in the same region.
Database accounts are created for the ApsaraDB RDS for MySQL instance and the cluster. For more information, see Create an account for an ApsaraDB RDS for MySQL instance, Create an account for an ApsaraDB for ClickHouse cluster, and Create a database account for an AnalyticDB for MySQL cluster.
Effective date
June 30, 2024
Billing rules
You can use the zero-ETL feature to synchronize data free of charge.
Supported regions and synchronization links
Regions: China (Beijing), China (Hangzhou), China (Shanghai), and China (Shenzhen)
NoteThe feature is rolled out for RDS instances in regions in phases. The information in the ApsaraDB RDS console shall prevail.
Synchronization links:
ApsaraDB RDS for MySQL to ApsaraDB for ClickHouse
ApsaraDB RDS for MySQL to AnalyticDB for MySQL 3.0