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