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

[Bo Peng]

Hi,

On Fri, 15 Mar 2019 03:26:01 +0200
Shereef Sakr <shereef.sakr at gmail.com> wrote:

> Dears,
> 
> 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 don't have so much experience with AWS.
Below is a slide about setup Pgpool-II on AWS, but it is in Japanese.
I hope you can find the solution to setting Virtual IP from page 38 to 46.

  https://www.sraoss.co.jp/event_seminar/2017/jpug_20171103_pgpool_aws.pdf

> > 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


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan