Re: [Postgres-xc-general] Multi master configuration with Postgre-XC

[Abbas B. <abb...@en...>]

Dear Juned,
A Postgres-XC cluster needs one GTM. You do not need a GTM at each state.
If you need to have data replicated across all the nodes all you need to do
is to distribute all tables of the schema by replication using the syntax
create table tab(a int, b int) distribute by replication;
Having said that, you need to consider the following points
a) It seems that the nodes of the cluster would be geographically apart, if
yes, please keep in mind that Postgres-XC does not cater for network
failures. If the link to one of the cluster nodes is down while inserting
data, the insert would fail. A select would however pass depending on which
coordinator the application is connected to.
b) Normally you would not replicate all the data to all the nodes, you
should use a mix of replicated and distributed tables. We can guide better
if you can explain a little bit what application you are trying to build
with Postgres-XC as backend.
Regards



On Sat, Feb 22, 2014 at 6:15 PM, Juned Khan <jkh...@gm...> wrote:

> Hi All,
>
> PFA
>
> Let me explain you my exact requirement. I have attached one image for
> that.
>
> As per that image i have multiple states which has GTM, datanodes and
> coordinators.
> In future i will add more states. so how data will be replicated with the
> datanodes of different stat.
>
> can i configure central GTM server which can handle all this stuff., or
> how do i configure each
> GTM to communicate with other GTMs so all DBs can be replicated
>
> I just want to know is that possible using postgre-xc or not ? if yes then
> please provide me relevant link and documentation for that.
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>
>
> ------------------------------------------------------------------------------
> Managing the Performance of Cloud-Based Applications
> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
> Read the Whitepaper.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
> _______________________________________________
> 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>