Re: dual active 2-node cluster?

From: "Amit S(dot)" <comeonamit(at)gmail(dot)com>
To: Ron Watkins <rwatki(at)gmail(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: dual active 2-node cluster?
Date: 2018-04-13 13:51:32
Message-ID: CAC-OOAvjZ91k9n1=k_yMPTVJJkYHp80-AtjJZeA==nEVYWTxvA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

You can look for hot-standby solution which would best suite your
requirements. Club it along with Pgbouncer and you will be able to get good
performance out of the setup.

Thanks, Amit

On Fri, Apr 13, 2018 at 3:31 PM, Ron Watkins <rwatki(at)gmail(dot)com> wrote:

> We are working to setup a production environment and as such one
> requirement is to have as few single points of failure as possible. To that
> end, I have been searching the web for how to setup a 2-node cluster where
> both nodes are active. The goal is to allow both nodes to service SQL
> requests (load/query) and have a load balancer in front of the database to
> allow for transparent outage and node recovery.
>
> Well, im not finding much in the way of details and would appreciate if
> someone could point me to the appropriate instructions. Thanks
>
> --
> Ron Watkins
> 602.743.5272
>

--

Amit Sharma

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stephen Froehlich 2018-04-13 17:09:58 Indexes for inequalities
Previous Message Laurenz Albe 2018-04-13 13:41:14 Re: dual active 2-node cluster?