Re: [Postgres-xc-general] Coordinator proxy?

[Mason S. <ma...@st...>]

On Tue, Sep 11, 2012 at 1:52 PM, Ashutosh Bapat
<ash...@en...> wrote:
> Hi Paulo,
> Although Postgres-XC provides facility to run many coordinators and thus
> provide multiple access points, it does not have load balancer in built. You
> can use third party load balancers with multiple coordinators.

In addition to load balancers like AVS and HAProxy, you could also
consider using round-robin DNS with a short TTL value.

If you do try out AVS or HAProxy, I would love to hear about your
experience with them.

>
>
> On Tue, Sep 11, 2012 at 8:13 PM, Paulo Pires <pj...@ub...> wrote:
>>
>> Hi all,
>>
>> First of all I'd like to congratulate postgres-xc team for the amazing
>> effort into getting version 1.0 released. Thanks guys!
>>
>> Now, I'd like to know if there's something like GTM-Proxy, but for
>> Coordinators, of course.
>> The thing is that I'm using Java JPA for accessing my database, and even
>> that I can configure one persistence-unit per database I need to access,
>> I'd have to implement something on my side that would select which
>> Coordinator to connect to. That would be counterproductive!
>>
>> If postgres is or were to have a proxy facility that would select
>> Coordinator based on its availability and load, it would be awesome.
>>
>> Can anyone clarify me?
>>
>> Cheers,
>>
>> --
>> Paulo Pires
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> Postgres-xc-general mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>
>
>
> --
> Best Wishes,
> Ashutosh Bapat
> EntepriseDB Corporation
> The Enterprise Postgres Company
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>



-- 
Mason Sharp

StormDB - http://www.stormdb.com
The Database Cloud
Postgres-XC Support and Services