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

[Paulo P. <pj...@ub...>]

On 11/09/12 19:04, Mason Sharp wrote:
> 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.

I have hands-on experience with HAProxy and if I don't find better
tools, I'll give it a try.
Never heard about AVS. Could you please provide more info? Also, I'm not
fond of round-robin DNS.
>
> If you do try out AVS or HAProxy, I would love to hear about your
> experience with them.

If I do, I'll write about it and let you guys know.

>
>>
>> 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
>>
>
>

-- 
Paulo Pires