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

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

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>