Menu
▾
▴
postgres-xc-general
|
From: Paulo P. <pj...@ub...> - 2012-09-11 15:00:23
|
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 |
|
From: Ashutosh B. <ash...@en...> - 2012-09-11 17:52:11
|
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. 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 |
|
From: Paulo P. <pj...@ub...> - 2012-09-11 20:30:03
|
On 11/09/12 18:52, Ashutosh Bapat 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. Hi Ashutosh, Could you please point me to a couple 3rd-party load-balancers that are OSS and you've had experience with, please? Thanks, PP > > On Tue, Sep 11, 2012 at 8:13 PM, Paulo Pires <pj...@ub... > <mailto: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... > <mailto:Pos...@li...> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > > > > > -- > Best Wishes, > Ashutosh Bapat > EntepriseDB Corporation > The Enterprise Postgres Company > -- Paulo Pires |
|
From: Mason S. <ma...@st...> - 2012-09-11 18:04:43
|
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 |
|
From: Paulo P. <pj...@ub...> - 2012-09-11 20:45:10
|
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 |
|
From: Koichi S. <koi...@gm...> - 2012-09-12 03:49:36
|
Year DNS round robin may work, although connection point will be fixed once cached. Regards; ---------- Koichi Suzuki 2012/9/12 Mason Sharp <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 > > ------------------------------------------------------------------------------ > 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 |
Thanks for helping keep SourceForge clean.
X