Essential How-To v6.0.1

This section provides essential how-to guides for deploying and managing your PGD cluster. It includes information on architectures, deployment, durability, autopartition, production best practices, and standard operating procedures (SOPs).

Overview

PGD Essential offers a simplified approach to deploying and managing your PGD cluster. It is designed to help you get started quickly and easily, while also providing a pathway to using advanced features as your use case becomes more complex.

At the core of PGD are data nodes, Postgres databases that are part of a PGD cluster. PGD enables these databases to replicate data efficiently between nodes, ensuring that your data is always available and up-to-date. PGD Essential simplifies this process by providing a standard architecture that is easy to set up and manage.

The standard architecture is built around a single data group, which is the basic architectural element for EDB Postgres Distributed systems. Within a group, nodes cooperate to select which nodes handle incoming write or read traffic, and identify when nodes are available or out of sync with the rest of the group. Groups are most commonly used on a single location where the nodes are in the same data center and where you have just the one group in the cluster, we also call it the one-location architecture.

Essential features

  • Standard Architecture: Learn about the standard architecture for PGD Essential,which consists of a single data group with three nodes in the same data center or region.

  • Near/Far Architecture: Understand the near/far architecture, which consists of two data groups in different locations, with one group handling writes and the other group handling reads.

  • Connection Management: Learn how to connect to your PGD cluster using the Connection Manager ports, which automatically route read and write transactions to the appropriate nodes.

  • PGD CLI: Discover how to use the PGD CLI to manage your PGD cluster, including creating and managing data groups, nodes, and connections.

  • Durability: Understand the durability features of PGD Essential, which ensure that your data is always available and up-to-date.

  • Autopartition: Learn about the autopartition feature, which automatically partitions your data across nodes in the cluster for improved performance and scalability.

Essential How-To Guides