ADPG Control overview

Arenadata Postgres Control (ADPG Control) — ADPG cluster management solution that simplifies administration, backups, and optimization of ADPG databases.

Features

ADPG Control has the following key features:

  • visual representation of a cluster topology, host statuses, and their roles (leader/replica) in the high availability architecture;

  • cluster backup and recovery management;

  • the calculation of optimal values for cluster configuration parameters based on the application profile, hardware, and maximum number of connections.

Architecture

The ADPG Control architecture is shown in the diagram below. Blue arrows indicate interaction within the ADPG Control cluster, green arrows show interaction within ADPG clusters and inter-cluster interaction.

ADPG Control architecture
ADPG Control architecture
ADPG Control architecture
ADPG Control architecture

Basic components:

  • ADPG Control — the main service that implements the ADPG Control functionality.

  • ADBM — a fault-tolerant backup management system that is built on the base of pgbackrest and provides the following capabilities:

    • Configure backup policies including separate schedules for different backup types.

    • Create database backups according to the configured schedule and manually.

    • Maintain a list of backups with the ability to search for them and view details.

    • Clean up backups according to existing policies on a schedule and manually.

    • Log backup operations.

    • Work with multiple ADPG clusters.

    • Support S3-, CIFS-, and Posix-compatible backup storages.

  • AD Eureka is responsible for service discovery in ADPG Control. It discovers available agents and finds required services to send responses. When you add an ADPG cluster, new agents are also registered via AD Eureka. It is implemented based on Spring Eureka Server.

  • Arenadata PostgreSQL stores metadata of the ADBM and ADPG Control services.

  • ADBM Agent provides the interaction between the ADBM service and ADPG clusters. ADBM agents are installed on each cluster host with the ADPG service. They are responsible for managing the configuration and running the necessary pgbackrest commands. The ADBM agents use the gRPC protocol to transmit data to the ADBM service.

  • ADPG Control Agent receives host metrics from Prometheus and interacts with Patroni using the REST API.

The ADBM and ADPG Control Agents are deployed on the side of an ADPG cluster.

Found a mistake? Seleсt text and press Ctrl+Enter to report it