Menu
▾
▴
Re: [Postgres-xc-general] How to start work
|
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 |
