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

[Juned K. <jkh...@gm...>]

Hi Abbas,

I should try this solution in my local system first.
If it does as you explain then it would be the perfect solution for me.

Thank you very much ;)


On Mon, Feb 24, 2014 at 1:20 PM, Abbas Butt <abb...@en...>wrote:

>
>
>
> On Mon, Feb 24, 2014 at 10:52 AM, Juned Khan <jkh...@gm...> wrote:
>
>> Hi Abbas,
>>
>> Thanks for your response.
>>
>> The problem with using single GTM is if GTM itself will go down then we
>> will loose everything.
>>
>
> GTM Slave can be used for this purpose.
>
>
>>
>> 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.
>>
>
> Please consider distributing customers based on hash or modulo of
> customer_id. This will make sure that the customers get distributed evenly
> in the cluster. Ideally you should distribute customers based on the state
> where they live, but due to current foreign key limitations of XC you might
> not be able to do it.
>
>
>
>>
>>
>>
>> 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
>>
>
>
>
> --
> --
> *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