<div dir="ltr">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. <br><div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Oct 17, 2014 at 11:11 AM, <a href="mailto:georg@riseup.net">georg@riseup.net</a> <span dir="ltr"><<a href="mailto:georg@riseup.net" target="_blank">georg@riseup.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Cal,<br>
<span class=""><br>
On 14-10-17 08:06:46, Cal Heldenbrand wrote:<br>
> What solution is there for implementing HA in such a scenario?<br>
> Threaded<br>
> requests, to threaded client connections, to a master/slave<br>
> replication<br>
> system. Would I have to use pgpool's Replication Mode and ditch the<br>
> Slony<br>
> approach?<br>
<br>
</span>Not sure if you need stuff like loadbalancing / connection pooling, etc,<br>
but in case you don't: Have a look at the corosync [1] (and pacemaker<br>
[2]) software stack, which I can highly recommend: "The Corosync Cluster<br>
Engine is a Group Communication System with additional features for<br>
implementing high availability within applications."<br>
<br>
For proofs of concept: [3], [4], and [5].<br>
<br>
Cheers,<br>
Georg<br>
<br>
<br>
[1] <a href="http://corosync.github.io/corosync/" target="_blank">http://corosync.github.io/corosync/</a><br>
[2] <a href="http://clusterlabs.org/" target="_blank">http://clusterlabs.org/</a><br>
[3] <a href="http://teamarin.net/2014/04/01/building-high-availability-postgresql-cluster-arin/" target="_blank">http://teamarin.net/2014/04/01/building-high-availability-postgresql-cluster-arin/</a><br>
[4] <a href="http://slideshare.net/TeamARIN/building-a-high-availability-postgre-sql-cluster" target="_blank">http://slideshare.net/TeamARIN/building-a-high-availability-postgre-sql-cluster</a><br>
[5] <a href="http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster" target="_blank">http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster</a><br>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div></div></div>