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

[Koichi S. <koi...@gm...>]

GTM is separate entity so if environment for GTM itself is okay, it stay
running.   Coordinators/GTM proxies can reconnect to this GTM.   Of course,
you can setup GTM slave for failover.

Regards;

---
Koichi Suzuki


2014-02-24 14:52 GMT+09:00 Juned Khan <jkh...@gm...>:

> Hi Abbas,
>
> Thanks for your response.
>
> The problem with using single GTM is if GTM itself will go down then we
> will loose everything.
>
> The application in which we want to use postgre-xc is billing kind of
> application.
> We setup this appllication in multiple states which will use same database
> cluster.
>
>
>
>
> On Sun, Feb 23, 2014 at 11:24 PM, Abbas Butt <abb...@en...>wrote:
>
>> 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>
>>
>
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>