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

Posted March 16, 2016 4.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.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
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 Marko Mudrinić
DigitalOcean's web based control panel provides a convenient, point-and-click interface for managing Droplets. There are many times, however, when a command-line tool may be a preferable alternative. doctl, the official DigitalOcean command-line client, leverages the DigitalOcean API to provide access to most account and Droplet features.