PolarDB for PostgreSQL Distributed Edition cluster officially released

Architecture

The PolarDB for PostgreSQL Distributed Edition cluster provides distributed features based on distributed scaling. The cluster has the following features:

• The cluster consists of CNs and DNs. CNs manage cluster metadata and create distributed execution plans. DNs store actual data shards.

• Each DN and CN in the cluster uses a centralized architecture that decouples storage and computing. The cluster supports database proxy and one-write-multiple-read mode and provides failover mechanisms for CNs and DNs. The cluster allows the addition of read-only nodes to enhance the read capability of individual CNs or DNs.

• The cluster supports manual sharding and provides horizontal scaling capabilities, which makes the cluster suitable for business scenarios that involve data volumes below petabytes (PB).

• The cluster ensures consistency in distributed transactions.

• The cluster supports dual-zone deployment. Operations are performed on the active working cluster in the primary zone. In the event of a failure in the primary zone, the hot standby cluster in the secondary zone can seamlessly take over to ensure uninterrupted service.

• The cluster offers 24/7 non-disruptive operation during maintenance, upgrades, and configuration changes. The cluster supports the addition of heterogeneous CNs and DNs.

Benefits

• Integration of centralized and distributed architectures

  Each CN and DN can operate as part of the distributed cluster and independently as a centralized cluster. The cluster uses a centralized architecture for CNs and DNs, fully exploits the benefits of the compute and storage separated design of PolarDB, and retains the advantages of centralized clusters such as one-write-multiple-read scalability, transparent compression, and plug-in support.

• Ease of use

  The cluster provides a centralized distributed view. Cross-node O&M can be performed from a single interface.