Ruk-Com PaaS Documentation

Build, deploy and operate applications on the platform.

RUK-COM PAAS / DATABASES

Multi-Region Cluster

This guide is maintained for Ruk-Com PaaS. Screens and options may vary by platform version and account permissions.

Confirm the environment, region and account permissions, and back up current settings before changing a production system.

PostgreSQL Multi-Region Cluster is a pre-packaged solution that automatically creates an advanced, highly available database cluster on top of platform-managed stack templates.

Database Cluster Topology

Image 34: PostgreSQL multi-region cluster Additionally, the package includes a highly available Pgpool-II Load Balancer layer to distribute requests and manage PostgreSQL replication topology.

The sum of these implementations ensures out-of-box high availability and failover for the database cluster. It is ensured on the data center level – the database is accessible even if one of the regions becomes unavailable.

Cluster Installation

  1. Find the PostgreSQL Multi-Region Cluster application (the Clusters section or use the Search field) in the platform Marketplace.

Image 36: PostgreSQL multi-region marketplace 2. In the opened installation window, specify the following data:

  • Version - select the preferred PostgreSQL version
  • Environment - provide a name for grouping your database cluster environments
  • Create separate environment group – tick to isolate the environment group
  • PostgreSQL Regions - choose platform regions where the cluster environments will be deployed. Note that regions order matters, as the first one will be the Primary server and the others will be Secondary
  • Pgpool-II enabled – enable to add load-balancing, monitoring, and management node (Pgpool-II) in front of database nodes in each region
  • Pgpool regions - choose platform regions where the load balancing nodes will be deployed

Image 37: install PostgreSQL multi-region cluster Click Install when ready.

  1. The installation process can take several minutes. After the completion, you’ll see the success window and receive emails with all the appropriate data, like entry point details and access credentials.

To easily view all the related environments, you can switch to the group specified in the previous step (pgcluster in our case).

Image 38: PostgreSQL cluster group 4. The default entry point for your multi-region cluster is a leader Pgpool-II node (the one deployed into the first region). If it fails, you can use any other Pgpool-II node using either hostname or IP address.

Image 39: PostgreSQL multi-region cluster environments In case your client software supports multiple entry points, you can set up all of them in a connection string to ensure automatic failover.