Menu
▾
▴
postgres-xc-general
|
From: Gilberto N. <gil...@gm...> - 2014-10-14 19:26:11
|
Hi... I already deploy 3 VM's with PostgresXC 1.0.4, follow the steps here: http://postgresxc.wikia.com/wiki/Real_Server_configuration But I need to know how start to work?? Where my application connect to?? Thanks for any kind of help........ -- -- Gilberto Ferreira |
|
From: Abbas B. <abb...@en...> - 2014-10-15 02:20:42
|
On Wed, Oct 15, 2014 at 12:25 AM, Gilberto Nunes <gil...@gm... > wrote: > Hi... > > I already deploy 3 VM's with PostgresXC 1.0.4, follow the steps here: > > http://postgresxc.wikia.com/wiki/Real_Server_configuration > > But I need to know how start to work?? > Where my application connect to?? > Your application can connect to any of the coordinators. > > Thanks for any kind of help........ > > -- > -- > > Gilberto Ferreira > > > > ------------------------------------------------------------------------------ > Comprehensive Server Monitoring with Site24x7. > Monitor 10 servers for $9/Month. > Get alerted through email, SMS, voice calls or mobile push notifications. > Take corrective actions from your mobile device. > http://p.sf.net/sfu/Zoho > _______________________________________________ > Postgres-xc-general mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > > -- -- *Abbas* Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co <http://www.enterprisedb.com/>m <http://www.enterprisedb.com/> *Follow us on Twitter* @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers <http://www.enterprisedb.com/resources-community> and more <http://www.enterprisedb.com/resources-community> |
|
From: 鈴木 幸市 <ko...@in...> - 2014-10-15 03:01:25
|
Hell; Abbas, thanks for the quick response. To start with, pgxc_ctl primer will be a good starting point. Pgxc_ctl is postgres-xc cluster configuration/operation utility. Tutorial is available at https://sourceforge.net/projects/postgres-xc/files/Pgxc_ctl_primer/ I’m afraid 1.0.x is a bit old. Why don’t you start with 1.1 or 1.2? 1.1 and 1.2 are almost identical from XC-specific features point of view. 1.2 comes with new PG 9.3 features. Postgres-XC document is available online. You can find links at https://sourceforge.net/p/postgres-xc/xc-wiki/Documentation/ Pgxc_ctl reference is included in it. Cheers; --- Koichi Suzuki 2014/10/15 10:56、Abbas Butt <abb...@en...<mailto:abb...@en...>> のメール： On Wed, Oct 15, 2014 at 12:25 AM, Gilberto Nunes <gil...@gm...<mailto:gil...@gm...>> wrote: Hi... I already deploy 3 VM's with PostgresXC 1.0.4, follow the steps here: http://postgresxc.wikia.com/wiki/Real_Server_configuration But I need to know how start to work?? Where my application connect to?? Your application can connect to any of the coordinators. Thanks for any kind of help........ -- -- Gilberto Ferreira ------------------------------------------------------------------------------ Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://p.sf.net/sfu/Zoho _______________________________________________ Postgres-xc-general mailing list Pos...@li...<mailto:Pos...@li...> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general -- -- Abbas Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co<http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> Follow us on Twitter @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and more<http://www.enterprisedb.com/resources-community> ------------------------------------------------------------------------------ Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://p.sf.net/sfu/Zoho_______________________________________________ Postgres-xc-general mailing list Pos...@li... https://lists.sourceforge.net/lists/listinfo/postgres-xc-general |
|
From: Gilberto N. <gil...@gm...> - 2014-10-15 10:48:03
|
Yep I'll work with 1.2 version... 1.0.4 was just for test purpose and to understand the concept... BTW, can work with ADSL as Internet Link, like 30 MBPS or dedicate link is recommend? I know there's some others specs that I need to take in mind, like processors, memory, and so on... But my doubt is if I work with normal ADSL the DB will be work properly... Thanks 2014-10-15 0:01 GMT-03:00 鈴木 幸市 <ko...@in...>: > Hell; > > Abbas, thanks for the quick response. > > To start with, pgxc_ctl primer will be a good starting point. Pgxc_ctl > is postgres-xc cluster configuration/operation utility. > > Tutorial is available at > https://sourceforge.net/projects/postgres-xc/files/Pgxc_ctl_primer/ > > I’m afraid 1.0.x is a bit old. Why don’t you start with 1.1 or 1.2? > 1.1 and 1.2 are almost identical from XC-specific features point of view. > 1.2 comes with new PG 9.3 features. > > Postgres-XC document is available online. You can find links at > https://sourceforge.net/p/postgres-xc/xc-wiki/Documentation/ > > Pgxc_ctl reference is included in it. > > Cheers; > --- > Koichi Suzuki > > 2014/10/15 10:56、Abbas Butt <abb...@en...> のメール： > > > > On Wed, Oct 15, 2014 at 12:25 AM, Gilberto Nunes < > gil...@gm...> wrote: > >> Hi... >> >> I already deploy 3 VM's with PostgresXC 1.0.4, follow the steps here: >> >> http://postgresxc.wikia.com/wiki/Real_Server_configuration >> >> But I need to know how start to work?? >> Where my application connect to?? >> > > Your application can connect to any of the coordinators. > > >> >> Thanks for any kind of help........ >> >> -- >> -- >> >> Gilberto Ferreira >> >> >> >> ------------------------------------------------------------------------------ >> Comprehensive Server Monitoring with Site24x7. >> Monitor 10 servers for $9/Month. >> Get alerted through email, SMS, voice calls or mobile push notifications. >> Take corrective actions from your mobile device. >> http://p.sf.net/sfu/Zoho >> _______________________________________________ >> Postgres-xc-general mailing list >> Pos...@li... >> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >> >> > > > -- > -- > *Abbas* > Architect > > Ph: 92.334.5100153 > Skype ID: gabbasb > www.enterprisedb.co <http://www.enterprisedb.com/>m > <http://www.enterprisedb.com/> > > * Follow us on Twitter* > @EnterpriseDB > > Visit EnterpriseDB for tutorials, webinars, whitepapers > <http://www.enterprisedb.com/resources-community> and more > <http://www.enterprisedb.com/resources-community> > > ------------------------------------------------------------------------------ > Comprehensive Server Monitoring with Site24x7. > Monitor 10 servers for $9/Month. > Get alerted through email, SMS, voice calls or mobile push notifications. > Take corrective actions from your mobile device. > http://p.sf.net/sfu/Zoho_______________________________________________ > Postgres-xc-general mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > > > -- -- Gilberto Ferreira |
|
From: Abbas B. <abb...@en...> - 2014-10-15 11:20:50
|
On Wed, Oct 15, 2014 at 3:47 PM, Gilberto Nunes <gil...@gm...> wrote: > Yep > > I'll work with 1.2 version... 1.0.4 was just for test purpose and to > understand the concept... > BTW, can work with ADSL as Internet Link, like 30 MBPS or dedicate link is > recommend? > Do you mean the link between application and the cluster OR the link between the nodes of the cluster? If you mean the link between application and the cluster you should be OK. I know there's some others specs that I need to take in mind, like > processors, memory, and so on... > But my doubt is if I work with normal ADSL the DB will be work properly... > > Thanks > > 2014-10-15 0:01 GMT-03:00 鈴木 幸市 <ko...@in...>: > > Hell; >> >> Abbas, thanks for the quick response. >> >> To start with, pgxc_ctl primer will be a good starting point. Pgxc_ctl >> is postgres-xc cluster configuration/operation utility. >> >> Tutorial is available at >> https://sourceforge.net/projects/postgres-xc/files/Pgxc_ctl_primer/ >> >> I’m afraid 1.0.x is a bit old. Why don’t you start with 1.1 or 1.2? >> 1.1 and 1.2 are almost identical from XC-specific features point of view. >> 1.2 comes with new PG 9.3 features. >> >> Postgres-XC document is available online. You can find links at >> https://sourceforge.net/p/postgres-xc/xc-wiki/Documentation/ >> >> Pgxc_ctl reference is included in it. >> >> Cheers; >> --- >> Koichi Suzuki >> >> 2014/10/15 10:56、Abbas Butt <abb...@en...> のメール： >> >> >> >> On Wed, Oct 15, 2014 at 12:25 AM, Gilberto Nunes < >> gil...@gm...> wrote: >> >>> Hi... >>> >>> I already deploy 3 VM's with PostgresXC 1.0.4, follow the steps here: >>> >>> http://postgresxc.wikia.com/wiki/Real_Server_configuration >>> >>> But I need to know how start to work?? >>> Where my application connect to?? >>> >> >> Your application can connect to any of the coordinators. >> >> >>> >>> Thanks for any kind of help........ >>> >>> -- >>> -- >>> >>> Gilberto Ferreira >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Comprehensive Server Monitoring with Site24x7. >>> Monitor 10 servers for $9/Month. >>> Get alerted through email, SMS, voice calls or mobile push notifications. >>> Take corrective actions from your mobile device. >>> http://p.sf.net/sfu/Zoho >>> _______________________________________________ >>> Postgres-xc-general mailing list >>> Pos...@li... >>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>> >>> >> >> >> -- >> -- >> *Abbas* >> Architect >> >> Ph: 92.334.5100153 >> Skype ID: gabbasb >> www.enterprisedb.co <http://www.enterprisedb.com/>m >> <http://www.enterprisedb.com/> >> >> * Follow us on Twitter* >> @EnterpriseDB >> >> Visit EnterpriseDB for tutorials, webinars, whitepapers >> <http://www.enterprisedb.com/resources-community> and more >> <http://www.enterprisedb.com/resources-community> >> >> ------------------------------------------------------------------------------ >> Comprehensive Server Monitoring with Site24x7. >> Monitor 10 servers for $9/Month. >> Get alerted through email, SMS, voice calls or mobile push notifications. >> Take corrective actions from your mobile device. >> http://p.sf.net/sfu/Zoho_______________________________________________ >> Postgres-xc-general mailing list >> Pos...@li... >> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >> >> >> > > > -- > -- > > Gilberto Ferreira > > -- -- *Abbas* Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co <http://www.enterprisedb.com/>m <http://www.enterprisedb.com/> *Follow us on Twitter* @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers <http://www.enterprisedb.com/resources-community> and more <http://www.enterprisedb.com/resources-community> |
|
From: Gilberto N. <gil...@gm...> - 2014-10-15 11:17:00
|
Let me explatin What I looking for is using Potsgre-XC on distribuited sites... Once this site get off line for any reason, link Local Link failure or Cluster Link failuer, local application can continue works and once the link get back on line, the Postgres-XC sync the local difference with others nodes/databases on the others site... I need to know if this will be nice, if I use normal adsl... Thanks 2014-10-15 7:52 GMT-03:00 Abbas Butt <abb...@en...>: > > > On Wed, Oct 15, 2014 at 3:47 PM, Gilberto Nunes < > gil...@gm...> wrote: > >> Yep >> >> I'll work with 1.2 version... 1.0.4 was just for test purpose and to >> understand the concept... >> BTW, can work with ADSL as Internet Link, like 30 MBPS or dedicate link >> is recommend? >> > > Do you mean the link between application and the cluster OR the link > between the nodes of the cluster? > If you mean the link between application and the cluster you should be OK. > > I know there's some others specs that I need to take in mind, like >> processors, memory, and so on... >> But my doubt is if I work with normal ADSL the DB will be work >> properly... >> >> Thanks >> >> 2014-10-15 0:01 GMT-03:00 鈴木 幸市 <ko...@in...>: >> >> Hell; >>> >>> Abbas, thanks for the quick response. >>> >>> To start with, pgxc_ctl primer will be a good starting point. >>> Pgxc_ctl is postgres-xc cluster configuration/operation utility. >>> >>> Tutorial is available at >>> https://sourceforge.net/projects/postgres-xc/files/Pgxc_ctl_primer/ >>> >>> I’m afraid 1.0.x is a bit old. Why don’t you start with 1.1 or 1.2? >>> 1.1 and 1.2 are almost identical from XC-specific features point of view. >>> 1.2 comes with new PG 9.3 features. >>> >>> Postgres-XC document is available online. You can find links at >>> https://sourceforge.net/p/postgres-xc/xc-wiki/Documentation/ >>> >>> Pgxc_ctl reference is included in it. >>> >>> Cheers; >>> --- >>> Koichi Suzuki >>> >>> 2014/10/15 10:56、Abbas Butt <abb...@en...> のメール： >>> >>> >>> >>> On Wed, Oct 15, 2014 at 12:25 AM, Gilberto Nunes < >>> gil...@gm...> wrote: >>> >>>> Hi... >>>> >>>> I already deploy 3 VM's with PostgresXC 1.0.4, follow the steps here: >>>> >>>> http://postgresxc.wikia.com/wiki/Real_Server_configuration >>>> >>>> But I need to know how start to work?? >>>> Where my application connect to?? >>>> >>> >>> Your application can connect to any of the coordinators. >>> >>> >>>> >>>> Thanks for any kind of help........ >>>> >>>> -- >>>> -- >>>> >>>> Gilberto Ferreira >>>> >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Comprehensive Server Monitoring with Site24x7. >>>> Monitor 10 servers for $9/Month. >>>> Get alerted through email, SMS, voice calls or mobile push >>>> notifications. >>>> Take corrective actions from your mobile device. >>>> http://p.sf.net/sfu/Zoho >>>> _______________________________________________ >>>> Postgres-xc-general mailing list >>>> Pos...@li... >>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>>> >>>> >>> >>> >>> -- >>> -- >>> *Abbas* >>> Architect >>> >>> Ph: 92.334.5100153 >>> Skype ID: gabbasb >>> www.enterprisedb.co <http://www.enterprisedb.com/>m >>> <http://www.enterprisedb.com/> >>> >>> * Follow us on Twitter* >>> @EnterpriseDB >>> >>> Visit EnterpriseDB for tutorials, webinars, whitepapers >>> <http://www.enterprisedb.com/resources-community> and more >>> <http://www.enterprisedb.com/resources-community> >>> >>> ------------------------------------------------------------------------------ >>> Comprehensive Server Monitoring with Site24x7. >>> Monitor 10 servers for $9/Month. >>> Get alerted through email, SMS, voice calls or mobile push notifications. >>> Take corrective actions from your mobile device. >>> http://p.sf.net/sfu/Zoho_______________________________________________ >>> Postgres-xc-general mailing list >>> Pos...@li... >>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>> >>> >>> >> >> >> -- >> -- >> >> Gilberto Ferreira >> >> > > > -- > -- > *Abbas* > Architect > > Ph: 92.334.5100153 > Skype ID: gabbasb > www.enterprisedb.co <http://www.enterprisedb.com/>m > <http://www.enterprisedb.com/> > > *Follow us on Twitter* > @EnterpriseDB > > Visit EnterpriseDB for tutorials, webinars, whitepapers > <http://www.enterprisedb.com/resources-community> and more > <http://www.enterprisedb.com/resources-community> > -- -- Gilberto Ferreira |
|
From: 鈴木 幸市 <ko...@in...> - 2014-10-16 03:30:16
|
Postgres-XC is based upon tightly coupled distributed database mode, which means it generally assumes all the nodes are up and available. In reality, if failed node is not involved in a transaction, it will be successful. If you try to update a shard at failed node, or you try to update replicated table which the failed node is involved, or if you try to issue DDL which is supposed to propagate to all the nodes, such transaction will fail. It is quite hard for XC to allow only partial DDL propagation because this will very easily make whole cluster inconsistent when the failed node is up and back. Hope your application meets this behavior. Regards; --- Koichi Suzuki 2014/10/15 20:16、Gilberto Nunes <gil...@gm...<mailto:gil...@gm...>> のメール： Let me explatin What I looking for is using Potsgre-XC on distribuited sites... Once this site get off line for any reason, link Local Link failure or Cluster Link failuer, local application can continue works and once the link get back on line, the Postgres-XC sync the local difference with others nodes/databases on the others site... I need to know if this will be nice, if I use normal adsl... Thanks 2014-10-15 7:52 GMT-03:00 Abbas Butt <abb...@en...<mailto:abb...@en...>>: On Wed, Oct 15, 2014 at 3:47 PM, Gilberto Nunes <gil...@gm...<mailto:gil...@gm...>> wrote: Yep I'll work with 1.2 version... 1.0.4 was just for test purpose and to understand the concept... BTW, can work with ADSL as Internet Link, like 30 MBPS or dedicate link is recommend? Do you mean the link between application and the cluster OR the link between the nodes of the cluster? If you mean the link between application and the cluster you should be OK. I know there's some others specs that I need to take in mind, like processors, memory, and so on... But my doubt is if I work with normal ADSL the DB will be work properly... Thanks 2014-10-15 0:01 GMT-03:00 鈴木 幸市 <koichi@intellilink..co.jp<mailto:ko...@in...>>: Hell; Abbas, thanks for the quick response. To start with, pgxc_ctl primer will be a good starting point. Pgxc_ctl is postgres-xc cluster configuration/operation utility. Tutorial is available at https://sourceforge.net/projects/postgres-xc/files/Pgxc_ctl_primer/ I’m afraid 1.0.x is a bit old. Why don’t you start with 1.1 or 1.2? 1.1 and 1.2 are almost identical from XC-specific features point of view. 1.2 comes with new PG 9.3 features. Postgres-XC document is available online. You can find links at https://sourceforge.net/p/postgres-xc/xc-wiki/Documentation/ Pgxc_ctl reference is included in it. Cheers; --- Koichi Suzuki 2014/10/15 10:56、Abbas Butt <abb...@en...<mailto:abb...@en...>> のメール： On Wed, Oct 15, 2014 at 12:25 AM, Gilberto Nunes <gil...@gm...<mailto:gil...@gm...>> wrote: Hi... I already deploy 3 VM's with PostgresXC 1.0.4, follow the steps here: http://postgresxc.wikia.com/wiki/Real_Server_configuration But I need to know how start to work?? Where my application connect to?? Your application can connect to any of the coordinators. Thanks for any kind of help........ -- -- Gilberto Ferreira ------------------------------------------------------------------------------ Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://p.sf.net/sfu/Zoho _______________________________________________ Postgres-xc-general mailing list Pos...@li...<mailto:Pos...@li...> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general -- -- Abbas Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co<http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> Follow us on Twitter @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and more<http://www.enterprisedb.com/resources-community> ------------------------------------------------------------------------------ Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://p.sf.net/sfu/Zoho_______________________________________________ Postgres-xc-general mailing list Pos...@li...<mailto:Pos...@li...> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general -- -- Gilberto Ferreira -- -- Abbas Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co<http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> Follow us on Twitter @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and more<http://www.enterprisedb.com/resources-community> -- -- Gilberto Ferreira |
|
From: Gilberto N. <gil...@gm...> - 2014-10-16 12:24:15
|
I see... But, let's suppose if I have XC Cluster on site "A", and that Cluster also connect with other site "B", which has it own Cluster. Then, when Site "A" goes off line, I suppose that when connection back on line, there's some updates spread to cluster. Or am I wrong thinking like that? I'm just trying to understand... Thank you 2014-10-16 0:30 GMT-03:00 鈴木 幸市 <ko...@in...>: > Postgres-XC is based upon tightly coupled distributed database mode, > which means it generally assumes all the nodes are up and available. > > In reality, if failed node is not involved in a transaction, it will be > successful. If you try to update a shard at failed node, or you try to > update replicated table which the failed node is involved, or if you try to > issue DDL which is supposed to propagate to all the nodes, such transaction > will fail. It is quite hard for XC to allow only partial DDL propagation > because this will very easily make whole cluster inconsistent when the > failed node is up and back. > > Hope your application meets this behavior. > > Regards; > --- > Koichi Suzuki > > 2014/10/15 20:16、Gilberto Nunes <gil...@gm...> のメール： > > Let me explatin > > What I looking for is using Potsgre-XC on distribuited sites... Once this > site get off line for any reason, link Local Link failure or Cluster Link > failuer, local application can continue works and once the link get back on > line, the Postgres-XC sync the local difference with others nodes/databases > on the others site... > > I need to know if this will be nice, if I use normal adsl... > > Thanks > > 2014-10-15 7:52 GMT-03:00 Abbas Butt <abb...@en...>: > >> >> >> On Wed, Oct 15, 2014 at 3:47 PM, Gilberto Nunes < >> gil...@gm...> wrote: >> >>> Yep >>> >>> I'll work with 1.2 version... 1.0.4 was just for test purpose and to >>> understand the concept... >>> BTW, can work with ADSL as Internet Link, like 30 MBPS or dedicate link >>> is recommend? >>> >> >> Do you mean the link between application and the cluster OR the link >> between the nodes of the cluster? >> If you mean the link between application and the cluster you should be OK. >> >> I know there's some others specs that I need to take in mind, like >>> processors, memory, and so on... >>> But my doubt is if I work with normal ADSL the DB will be work >>> properly... >>> >>> Thanks >>> >>> 2014-10-15 0:01 GMT-03:00 鈴木 幸市 <ko...@in...>: >>> >>> Hell; >>>> >>>> Abbas, thanks for the quick response. >>>> >>>> To start with, pgxc_ctl primer will be a good starting point. >>>> Pgxc_ctl is postgres-xc cluster configuration/operation utility. >>>> >>>> Tutorial is available at >>>> https://sourceforge.net/projects/postgres-xc/files/Pgxc_ctl_primer/ >>>> >>>> I’m afraid 1.0.x is a bit old. Why don’t you start with 1.1 or 1.2? >>>> 1.1 and 1.2 are almost identical from XC-specific features point of view. >>>> 1.2 comes with new PG 9.3 features. >>>> >>>> Postgres-XC document is available online. You can find links at >>>> https://sourceforge.net/p/postgres-xc/xc-wiki/Documentation/ >>>> >>>> Pgxc_ctl reference is included in it. >>>> >>>> Cheers; >>>> --- >>>> Koichi Suzuki >>>> >>>> 2014/10/15 10:56、Abbas Butt <abb...@en...> のメール： >>>> >>>> >>>> >>>> On Wed, Oct 15, 2014 at 12:25 AM, Gilberto Nunes < >>>> gil...@gm...> wrote: >>>> >>>>> Hi... >>>>> >>>>> I already deploy 3 VM's with PostgresXC 1.0.4, follow the steps here: >>>>> >>>>> http://postgresxc.wikia.com/wiki/Real_Server_configuration >>>>> >>>>> But I need to know how start to work?? >>>>> Where my application connect to?? >>>>> >>>> >>>> Your application can connect to any of the coordinators. >>>> >>>> >>>>> >>>>> Thanks for any kind of help........ >>>>> >>>>> -- >>>>> -- >>>>> >>>>> Gilberto Ferreira >>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Comprehensive Server Monitoring with Site24x7. >>>>> Monitor 10 servers for $9/Month. >>>>> Get alerted through email, SMS, voice calls or mobile push >>>>> notifications. >>>>> Take corrective actions from your mobile device. >>>>> http://p.sf.net/sfu/Zoho >>>>> _______________________________________________ >>>>> Postgres-xc-general mailing list >>>>> Pos...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>>>> >>>>> >>>> >>>> >>>> -- >>>> -- >>>> *Abbas* >>>> Architect >>>> >>>> Ph: 92.334.5100153 >>>> Skype ID: gabbasb >>>> www.enterprisedb.co <http://www.enterprisedb.com/>m >>>> <http://www.enterprisedb.com/> >>>> >>>> * Follow us on Twitter* >>>> @EnterpriseDB >>>> >>>> Visit EnterpriseDB for tutorials, webinars, whitepapers >>>> <http://www.enterprisedb.com/resources-community> and more >>>> <http://www.enterprisedb.com/resources-community> >>>> >>>> ------------------------------------------------------------------------------ >>>> Comprehensive Server Monitoring with Site24x7. >>>> Monitor 10 servers for $9/Month. >>>> Get alerted through email, SMS, voice calls or mobile push >>>> notifications. >>>> Take corrective actions from your mobile device. >>>> http://p.sf.net/sfu/Zoho_______________________________________________ >>>> Postgres-xc-general mailing list >>>> Pos...@li... >>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>>> >>>> >>>> >>> >>> >>> -- >>> -- >>> >>> Gilberto Ferreira >>> >>> >> >> >> -- >> -- >> *Abbas* >> Architect >> >> Ph: 92.334.5100153 >> Skype ID: gabbasb >> www.enterprisedb.co <http://www.enterprisedb.com/>m >> <http://www.enterprisedb.com/> >> >> * Follow us on Twitter* >> @EnterpriseDB >> >> Visit EnterpriseDB for tutorials, webinars, whitepapers >> <http://www.enterprisedb.com/resources-community> and more >> <http://www.enterprisedb.com/resources-community> >> > > > > -- > -- > > Gilberto Ferreira > > > -- -- Gilberto Ferreira |
|
From: Koichi S. <koi...@gm...> - 2014-10-20 01:01:12
|
Do you mean interaction between different XC clusters? If so, it is outside XC scope at present. You may need FDW or blink, which are not enabled in XC yet. Regards; --- Koichi Suzuki 2014-10-16 21:23 GMT+09:00 Gilberto Nunes <gil...@gm...>: > I see... > But, let's suppose if I have XC Cluster on site "A", and that Cluster also > connect with other site "B", which has it own Cluster. > > Then, when Site "A" goes off line, I suppose that when connection back on > line, there's some updates spread to cluster. Or am I wrong thinking like > that? > I'm just trying to understand... > > Thank you > > 2014-10-16 0:30 GMT-03:00 鈴木 幸市 <ko...@in...>: > >> Postgres-XC is based upon tightly coupled distributed database mode, which >> means it generally assumes all the nodes are up and available. >> >> In reality, if failed node is not involved in a transaction, it will be >> successful. If you try to update a shard at failed node, or you try to >> update replicated table which the failed node is involved, or if you try to >> issue DDL which is supposed to propagate to all the nodes, such transaction >> will fail. It is quite hard for XC to allow only partial DDL propagation >> because this will very easily make whole cluster inconsistent when the >> failed node is up and back. >> >> Hope your application meets this behavior. >> >> Regards; >> --- >> Koichi Suzuki >> >> 2014/10/15 20:16、Gilberto Nunes <gil...@gm...> のメール： >> >> Let me explatin >> >> What I looking for is using Potsgre-XC on distribuited sites... Once this >> site get off line for any reason, link Local Link failure or Cluster Link >> failuer, local application can continue works and once the link get back on >> line, the Postgres-XC sync the local difference with others nodes/databases >> on the others site... >> >> I need to know if this will be nice, if I use normal adsl... >> >> Thanks >> >> 2014-10-15 7:52 GMT-03:00 Abbas Butt <abb...@en...>: >>> >>> >>> >>> On Wed, Oct 15, 2014 at 3:47 PM, Gilberto Nunes >>> <gil...@gm...> wrote: >>>> >>>> Yep >>>> >>>> I'll work with 1.2 version... 1.0.4 was just for test purpose and to >>>> understand the concept... >>>> BTW, can work with ADSL as Internet Link, like 30 MBPS or dedicate link >>>> is recommend? >>> >>> >>> Do you mean the link between application and the cluster OR the link >>> between the nodes of the cluster? >>> If you mean the link between application and the cluster you should be >>> OK. >>> >>>> I know there's some others specs that I need to take in mind, like >>>> processors, memory, and so on... >>>> But my doubt is if I work with normal ADSL the DB will be work >>>> properly... >>>> >>>> Thanks >>>> >>>> 2014-10-15 0:01 GMT-03:00 鈴木 幸市 <ko...@in...>: >>>> >>>>> Hell; >>>>> >>>>> Abbas, thanks for the quick response. >>>>> >>>>> To start with, pgxc_ctl primer will be a good starting point. >>>>> Pgxc_ctl is postgres-xc cluster configuration/operation utility. >>>>> >>>>> Tutorial is available at >>>>> https://sourceforge.net/projects/postgres-xc/files/Pgxc_ctl_primer/ >>>>> >>>>> I’m afraid 1.0.x is a bit old. Why don’t you start with 1.1 or 1.2? >>>>> 1.1 and 1.2 are almost identical from XC-specific features point of view. >>>>> 1.2 comes with new PG 9.3 features. >>>>> >>>>> Postgres-XC document is available online. You can find links at >>>>> https://sourceforge.net/p/postgres-xc/xc-wiki/Documentation/ >>>>> >>>>> Pgxc_ctl reference is included in it. >>>>> >>>>> Cheers; >>>>> --- >>>>> Koichi Suzuki >>>>> >>>>> 2014/10/15 10:56、Abbas Butt <abb...@en...> のメール： >>>>> >>>>> >>>>> >>>>> On Wed, Oct 15, 2014 at 12:25 AM, Gilberto Nunes >>>>> <gil...@gm...> wrote: >>>>>> >>>>>> Hi... >>>>>> >>>>>> I already deploy 3 VM's with PostgresXC 1.0.4, follow the steps here: >>>>>> >>>>>> http://postgresxc.wikia.com/wiki/Real_Server_configuration >>>>>> >>>>>> But I need to know how start to work?? >>>>>> Where my application connect to?? >>>>> >>>>> >>>>> Your application can connect to any of the coordinators. >>>>> >>>>>> >>>>>> >>>>>> Thanks for any kind of help........ >>>>>> >>>>>> -- >>>>>> -- >>>>>> >>>>>> Gilberto Ferreira >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> Comprehensive Server Monitoring with Site24x7. >>>>>> Monitor 10 servers for $9/Month. >>>>>> Get alerted through email, SMS, voice calls or mobile push >>>>>> notifications. >>>>>> Take corrective actions from your mobile device. >>>>>> http://p.sf.net/sfu/Zoho >>>>>> _______________________________________________ >>>>>> Postgres-xc-general mailing list >>>>>> Pos...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> -- >>>>> Abbas >>>>> Architect >>>>> >>>>> Ph: 92.334.5100153 >>>>> Skype ID: gabbasb >>>>> www.enterprisedb.com >>>>> >>>>> Follow us on Twitter >>>>> @EnterpriseDB >>>>> >>>>> Visit EnterpriseDB for tutorials, webinars, whitepapers and more >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Comprehensive Server Monitoring with Site24x7. >>>>> Monitor 10 servers for $9/Month. >>>>> Get alerted through email, SMS, voice calls or mobile push >>>>> notifications. >>>>> Take corrective actions from your mobile device. >>>>> http://p.sf.net/sfu/Zoho_______________________________________________ >>>>> Postgres-xc-general mailing list >>>>> Pos...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> -- >>>> >>>> Gilberto Ferreira >>>> >>> >>> >>> >>> -- >>> -- >>> Abbas >>> Architect >>> >>> Ph: 92.334.5100153 >>> Skype ID: gabbasb >>> www.enterprisedb.com >>> >>> Follow us on Twitter >>> @EnterpriseDB >>> >>> Visit EnterpriseDB for tutorials, webinars, whitepapers and more >> >> >> >> >> -- >> -- >> >> Gilberto Ferreira >> >> > > > > -- > -- > > Gilberto Ferreira > > > ------------------------------------------------------------------------------ > Comprehensive Server Monitoring with Site24x7. > Monitor 10 servers for $9/Month. > Get alerted through email, SMS, voice calls or mobile push notifications. > Take corrective actions from your mobile device. > http://p.sf.net/sfu/Zoho > _______________________________________________ > Postgres-xc-general mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X