YAIM - PostgreSQL IP Manager

IP manager for PostgreSQL clusters

The purpose of a PostgreSQL HA (High Availability) cluster is to avoid downtime and to provide a ready-to-use database service at all times. Downtime is expensive and can seriously damage the reputation of a company; a High Availability cluster addresses this issue.

CYBERTEC has the HA expertise you need and offers database clusters to customers worldwide. However, the question often arises: How can the database cluster be made transparent to the application? How can we assure that an application does not have to be aware of the inner workings of our PostgreSQL High-Availability solution?

YAIM: Managing IPs intelligently

YAIM is an intelligent IP manager for PostgreSQL and Patroni clusters. It allows you to transparently manage IP addresses and thus ensures that your applications don’t need to negotiate the topology of your cluster.

Key Benefits of YAIM

  • Automatic IP management
  • Dynamically add and remove servers
  • Load balancing of read-only requests
  • Easy DNS integration
  • Fully Open Source
  • Works with PostgreSQL, PostgreSQL TDE and PGEE

How YAIM works

YAIM manages a pool of IP addresses which can be distributed inside the cluster to allow the application to dynamically load balance. The application will see a set of IP addresses and transparently connect to a random IP.

YAIM and Patroni will take care of the rest:

  • Automatic failover
  • Automatic recovery
  • Transparent IP management
  • Automatic load balancing (with DNS)

How do you manage IPs with YAIM? Simply choose a set of IP addresses. YAIM will automatically assign those IPs to the available nodes in the cluster:

Manage IPs - YAIM

In case of a failure, yaim will automatically assign those IPs which were taken by the failed machine and distribute them among the remaining servers. That means all IPs will always be reachable.

Automatically Assign IPs - YAIM

Patroni will automatically recover a server which is available after a system failure. Once a server is back in action, yaim will automatically assign spare IP addresses to the PostgreSQL server.

DNS and load balancing for PostgreSQL

DNS is a wonderful way to scale read-only workloads. Simply assign a DNS name to your pool of IPs. Load balancing will happen automatically via DNS using Round-Robin. 

DNS and Load Balancing - YAIM

Scale out your cluster easily and transparently.

Key benefits

  • Use DNS names instead of IPs
  • Add servers without changes to the application
  • Hide the size of your cluster
  • Scale your workload

Gettin YAIM

YAIM is available as binary for RedHat Enterprise Server (RHEL), CentOS and Ubuntu

Get in touch with us to learn more and order your Patroni or PostgreSQL cluster today. We offer timely delivery, professional handling, and over 20 years of PostgreSQL experience.

CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf

+43 (0) 2622 93022-0

Get the newest PostgreSQL Info & Tools

    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    CYBERTEC PostgreSQL International GmbH
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram