Zero-ETL lets you replicate data from ApsaraDB RDS for PostgreSQL directly into AnalyticDB for PostgreSQL for real-time analysis—no data pipelines to build, no synchronization tasks to manage, and no charge for the data transfer. This reduces both data transmission costs and O&M costs.
Benefits
No pipeline overhead — Select a source and destination instance to create a real-time synchronization task. No ETL pipeline code to write or maintain.
Free data replication — Replicate data to AnalyticDB for PostgreSQL at no charge, so you pay only for the compute and storage you use for analysis.
Multi-source aggregation — Consolidate data from multiple ApsaraDB RDS for PostgreSQL instances into a single AnalyticDB for PostgreSQL instance for a unified analytical view.
Prerequisites
Before you begin, make sure you have:
An AnalyticDB for PostgreSQL instance. For more information, see Create an instance.
Both the ApsaraDB RDS for PostgreSQL instance and the AnalyticDB for PostgreSQL instance in the same region.
A database in the AnalyticDB for PostgreSQL instance to receive the replicated data. For more information, see Manage databases.
The privileged account of the ApsaraDB RDS for PostgreSQL instance set as the owner of the destination database. The owner is an authorized account. For more information, see Create an account.
A database account for the AnalyticDB for PostgreSQL instance (the initial account or an account with the SUPERUSER permission also works). For more information, see Create a database account.
The
wal_levelparameter of the ApsaraDB RDS for PostgreSQL instance set tological. For more information, see Modify the parameters of an ApsaraDB RDS for PostgreSQL instance.The logical replication failover slot feature enabled on the ApsaraDB RDS for PostgreSQL instance. This feature is enabled by default and prevents logical subscriptions from being interrupted during a primary/secondary switchover, ensuring that the synchronization task runs as expected. For more information, see Logical Replication Slot Failover.
Effective date
June 30, 2024
Billing
Using zero-ETL to synchronize data is free of charge.
Supported regions and synchronization links
Supported regions: China (Beijing), China (Hangzhou), China (Shanghai), and China (Shenzhen).
Zero-ETL is rolled out to regions in phases. The information in the ApsaraDB RDS console shall prevail.
Supported synchronization link: ApsaraDB RDS for PostgreSQL → AnalyticDB for PostgreSQL