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

[georg at riseup.net]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141017/09138b4c/attachment.sig>