Re: Automatic Client routing - Mailing list pgsql-general

From Bill Moran
Subject Re: Automatic Client routing
Date
Msg-id 20150604220251.920d6b5f2a44658e6f6df045@potentialtech.com
Whole thread Raw
In response to Automatic Client routing  (Ravi Krishna <sravikrishna3@gmail.com>)
List pgsql-general
On Thu, 4 Jun 2015 08:53:15 -0400
Ravi Krishna <sravikrishna3@gmail.com> wrote:

> Are there any plans to introduce the concept of automatic client
> routing to the principal server in a cluster of N machines. For
> example, if there is a four node replication cluster N1 .. N4, at any
> time only one can be principal (the one which does the writing). In
> Oracle and DB2, client side libraries provide a way for the clients to
> connect to the principal writer regardless of where it is running on
> N1 .. N4. This way client need to be aware of only one connection
> string.
>
> EnterpriseDb is a failover manager which relies on virtual IP
> management, not the one I described above.

pgpool has this capacity.

--
Bill Moran <wmoran@potentialtech.com>


pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: 9.4.1 -> 9.4.2 problem: could not access status of transaction 1
Next
From: Sergey Konoplev
Date:
Subject: Re: replicating many to one