[pgpool-general: 3230] Re: pgpool with Slony replication delay

[Cal Heldenbrand]

I would need load balancing and connection pooling, which I think is one of
the main reasons I started looking into pgpool.  There aren't too many
options out there that provide both in one package.

On Fri, Oct 17, 2014 at 11:11 AM, georg at riseup.net <georg at riseup.net> wrote:

> Hi Cal,
>
> On 14-10-17 08:06:46, Cal Heldenbrand wrote:
> > What solution is there for implementing HA in such a scenario?
> > Threaded
> > requests, to threaded client connections, to a master/slave
> > replication
> > system.  Would I have to use pgpool's Replication Mode and ditch the
> > Slony
> > approach?
>
> Not sure if you need stuff like loadbalancing / connection pooling, etc,
> but in case you don't: Have a look at the corosync [1] (and pacemaker
> [2]) software stack, which I can highly recommend: "The Corosync Cluster
> Engine is a Group Communication System with additional features for
> implementing high availability within applications."
>
> For proofs of concept: [3], [4], and [5].
>
> Cheers,
> Georg
>
>
> [1] http://corosync.github.io/corosync/
> [2] http://clusterlabs.org/
> [3]
> http://teamarin.net/2014/04/01/building-high-availability-postgresql-cluster-arin/
> [4]
> http://slideshare.net/TeamARIN/building-a-high-availability-postgre-sql-cluster
> [5] http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141017/249e23cb/attachment.html>