[pgpool-general: 6461] Re: Question regarding PG Pool high availability setup on Microsoft Azure

Shereef Sakr shereef.sakr at gmail.com
Fri Mar 15 10:26:01 JST 2019


Just a kind reminder, if someone can help me in this regard.

On Wed, Mar 13, 2019 at 4:42 PM Shereef Sakr <shereef.sakr at gmail.com> wrote:

> Dears
> I'm having a problem regarding a high availability setup on
> Microsoft Azure since PG Pool high availability depends on the existence of
> Virtual IP, which simply doesn't work on Microsoft Azure and is not visible
> except on the same virtual machine.
> I found the example for Amazon AWS below, but I don't like the solution
> that it's a public IP visible to the internet, and we can't accept that for
> security reasons, also I didn't find a comparable example on Microsoft
> Azure too.
> https://www.pgpool.net/docs/latest/en/html/example-aws.html
> Also in addition to that I tried to disregard the virtual IP and configure
> my application using both internal IPs of both pg pool servers, but as per
> my observation I found the following:
> 1- Double the needed connections are opened to both backend application
> servers, which shouldn't be good to Postgres servers performance according
> to "PostgreSQL High Availability Cookbook" ( that Postgres performance is
> acceptable when the number of open connection is ~ triple the number of
> cores)
> 2- Also I find that both pg pool servers behave as Active/Active and can
> be used at the same time.
> So what is the recommended solution in this case?
> --
> Shereef Sakr
> ------------------------------------------------------------------

Shereef Sakr
Software Development Manager
Esri Northeast Africa
Personal Blog: shereefsakr.blogspot.com
Technical Blog: fci-h.blogspot.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190315/b452db79/attachment-0001.html>

More information about the pgpool-general mailing list