I need a Virtual Private IP for an failover setup of pgpool-II.

March 16, 2016 3.7k views
High Availability

I need a Virtual Private IP for an failover setup of pgpool-II.
How do I get Vitual Private IP?
I want to setup a cluster of 2 pgpool-II instance and my app should access it with common identity through private communication how do I achieve that if Virtual Private IP is not available.

1 Answer

In a cloud environment, you may not be able to use a traditional Virtual Private IP. Though on DigitalOcean, you can use a Floating IP for situations like this. With pgpool-II you can provide a script that will be executed as the failover happens. In this script, you can assign the Floating IP from one instance to the other. This simple Python script or the DigitalOcean command line client could be used in your failover script to move a Floating IP.

by Melissa Anderson
A DigitalOcean Floating IP is a publicly-accessible static IP address that can be mapped to one of your Droplets. A Floating IP can also be instantly remapped, via the DigitalOcean Control Panel or API, to one of your other Droplets in the same datacenter. This instant remapping capability grants you the ability to design and create High Availability (HA) server infrastructures by adding redundancy to the entry point, or gateway, to your servers.
Have another answer? Share your knowledge.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!