All Products
Search
Document Center

AnalyticDB:Serverless Pro mode

Last Updated:Apr 01, 2026

AnalyticDB for PostgreSQL 7.0 introduces Serverless Pro mode: a cloud-native architecture that combines Massively Parallel Processing (MPP) database technology with Serverless technology to decouple compute from storage. You get second-level elastic scaling and one-write-multiple-reads without managing local disks or replicating data for each read cluster. Storage is pay-as-you-go, and compute scales automatically—both significantly lower your total cost of ownership (TCO) for large-scale analytics and high-concurrency read workloads.

Core advantages

Serverless Pro mode offers three improvements over the traditional Storage-Elastic Mode:

  • Lower storage costs: Data is stored in Object Storage Service (OSS), which has unlimited capacity at a fraction of the cost of local Enhanced SSDs (ESSDs). As your data grows, you no longer need to expand expensive local cloud disks.

  • Second-level elastic scaling: Because compute and storage are decoupled, compute resources scale independently on demand. Scale out in seconds to absorb peak traffic, then release resources during off-peak hours to avoid waste.

  • Stable one-write-multiple-reads: Virtual Warehouses (VWs) isolate I/O loads into independent compute clusters. The primary cluster handles writes. Read workloads—reports, dashboards, ad hoc analysis—run on separate VWs, so large queries never compete with write operations. All VWs share the same underlying storage, eliminating the need to replicate data for each read-only cluster.

Architecture design

Architecture evolution

image

Serverless Pro evolved across three architectural generations to achieve lower cost, greater elasticity, and better workload isolation.

Traditional AnalyticDB for PostgreSQL: Master and segment compute nodes are tightly coupled to local ESSDs. Data growth means continuously expanding local disks and replicas, so storage costs rise linearly. Compute nodes are stateful, making scaling slow and resource reclamation difficult. Adding read capacity requires creating a new cluster and replicating all data—a process that takes days and multiplies storage costs.

Decoupled compute and storage: Serverless Pro introduces a shared storage foundation built on Serverless Pro storage nodes and OSS. Persistent data moves to OSS; local disks serve only as a cache for hot data, making compute nodes nearly stateless. You can scale compute independently, provision resources for peak loads in seconds, and release them when no longer needed. Storage is pay-as-you-go, eliminating the cost of over-provisioning local cloud disks.

Multi-cluster shared storage: Building on shared storage, this architecture supports a primary cluster and multiple VWs. The primary cluster handles writes; VWs provide independent, read-only compute for reports, dashboards, and ad hoc analysis. Creating a VW requires no data replication—read scaling drops from day-level data replication to minute-level resource provisioning. Read and write operations are physically isolated, so mixed workloads are more stable.

Service architecture

image.png

Serverless Pro is built on the Log-as-database concept. Each layer has a single responsibility: compute nodes execute SQL, the Log Store persists write-ahead logs, the Page Store serves data pages, and OSS provides final archival storage.

Random page writes are converted into sequential writes to the Write-Ahead Logging (WAL). The storage layer asynchronously replays the WAL to generate data pages for a specific Log Sequence Number (LSN), with all data ultimately archived in OSS.

The four layers are:

  • Compute nodes: A stateless or lightweight stateful layer that executes SQL. Each node uses Local File Cache and Dadi Cache backed by local ESSDs as a high-performance cache for hot data.

  • Storage nodes (Log Store): The log service layer. It ensures WAL persistence from compute nodes and asynchronously pushes logs to the Page Store.

  • Storage nodes (Page Store): The data page service layer. It consumes and replays WAL to produce data pages for a specific LSN and exposes a GetPage service to compute nodes.

  • OSS: The final persistence layer. All data—data pages from the Page Store, Beam column-store data, manifests, and WAL logs—is archived here.

Virtual Warehouse

In traditional one-write-multiple-reads setups, adding read capacity means creating a separate cluster and replicating all data before read workloads can run in isolation. This takes days and doubles storage costs for every additional cluster.

Virtual Warehouse eliminates both constraints. It is the core feature enabling one-write-multiple-reads in Serverless Pro mode. Create multiple isolated, read-only compute clusters that all share the same underlying storage—no data replication required. Each VW handles a specific read workload independently, so large analytics queries on one VW never affect write stability on the primary cluster or queries on other VWs.

Adding a VW takes minutes, not days. Because VWs share underlying storage, you pay for compute only, not redundant copies of your data.

For details, see Virtual Warehouse.

Product mode comparison

Serverless Pro mode is compatible with most features of Storage-Elastic Mode. The following table compares instance management capabilities across both modes.

Feature classification Sub-feature Storage-Elastic Mode Serverless mode
Instance management Basic instance information Supported Supported
Log on to database (DMS) Supported Supported
Create instance Supported Supported
Release instance Supported Supported
Restart instance Supported Supported
Upgrade or downgrade instance Supported Supported
Scale Master nodes Supported Supported
Scale out instance Supported Supported
Scale in instance Supported Supported
Minor version upgrade Supported Supported
Account management Create account Supported Supported
Reset password Supported Supported
Database connection Basic connection information Supported Supported
Apply for public endpoint Supported Supported
Monitoring and alerts Monitoring Supported Supported
Alert rules Supported Supported
Data security Whitelist Supported Supported
SQL audit Supported Supported
SSL Supported Supported
Backup and recovery Supported Supported
Configuration management Parameter settings Supported Supported

Feature compatibility and constraints

Serverless Pro mode is compatible with over 95% of Storage-Elastic Mode features. Existing SQL syntax, JDBC/ODBC interfaces, and client tools such as psql work identically to Storage-Elastic Mode.

The following table lists features with constraints or limited support.

Category Feature Support status Constraints and notes
Basic features ALTER TABLE Supported
Indexes Supported Supports B-tree, Hash, GiST, GIN, and more
PRIMARY KEY Supported
UNIQUE CONSTRAINT Supported
INSERT ON CONFLICT (overwrite) Supported Heap tables only. Not supported for AO/AOCS tables.
Unlogged tables Supported Suitable for temporary data.
Triggers Supported Heap tables only.
Heap/Beam tables Supported Default row-oriented table type.
AO/AOCS tables Not supported Column-oriented tables have limitations in some scenarios (for example, they do not support triggers or ON CONFLICT).
User-defined types Supported Includes composite types, enumerations, and range types.
Explicit cursors Supported
Compute engine ORCA optimizer Supported Enabled by default. Suitable for complex queries.
Laser engine Supported High-performance vectorized execution engine.
Transaction capabilities Sub-transactions Supported Supports SAVEPOINT and ROLLBACK TO.
Transaction isolation level Supported Read Committed and Repeatable Read only.
Advanced features Backup and recovery Supported Supports point-in-time recovery (PITR).
Materialized views Supported Supports automatic and manual refresh.
AUTO VACUUM Supported Automatically cleans dead tuples. Keep this feature enabled.
AUTO ANALYZE Supported Automatically collects statistics.
Online scale-out Supported Dynamically add nodes without service interruption.
Online scale-in Supported Dynamically remove nodes (minimum node count applies).
GIS / Ganos Supported Built-in spatio-temporal data processing.
Data sharing Not supported Cross-instance or cross-cluster data sharing is not currently supported.

Data migration

To migrate from Storage-Elastic Mode or Storage-Reserved Mode to Serverless Pro mode, see Data migration between AnalyticDB for PostgreSQL instances.

The following table summarizes migration method support.

Migration type Method Serverless Pro mode support
Data writing Overwrite data using INSERT ON CONFLICT Supported
Overwrite data using COPY ON CONFLICT Supported
Write data using a client SDK Supported
Table-level migration DataWorks data integration Supported
Migrate and synchronize data from Alibaba Cloud databases Supported
Migrate and synchronize data from self-managed databases Supported
Import local data using the \COPY command Supported
Use OSS external tables to import data from OSS Supported
Federated analytics using Hadoop ecosystem external tables Not supported

Time Travel and Branching (planned)

Note

The features described in this section are in the planning stage. For release dates and usage details, see product announcements and official documentation updates.

Building on the shared storage and one-write-multiple-reads architecture, Serverless Pro plans to introduce Time Travel and Branching. These features provide historical data access, isolated validation environments, and low-cost data branching—all without replicating your full dataset.

In addition to the primary cluster and VWs, you will be able to create the following on demand from the same shared storage:

image.png

Time Travel (Data Backtracking)

Create a read-only replica frozen at any historical LSN, attach an independent VW for querying, and start analyzing without restoring from a backup or replicating the full dataset.

Typical use cases: tracing operational errors, audit checks, reproducing historical issues, data reconciliation, and report backtracking.

Branching

Create an isolated, writable environment (a branch) from a specific point in time of your production data. Validate schema changes, run data repair drills, or test algorithms in the branch. If validation succeeds, merge the changes in a controlled manner. If it fails, discard the branch. The entire workflow does not affect the primary database or other services.

Typical use cases: drills for high-risk changes (DDL, indexes, parameters), code regression testing, data repair sandboxes, AI algorithm feature engineering, and parallel comparison of multiple solutions.

What's next