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

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

Hi Mason,

What alternatives i have for my requirements ?


On Mon, Feb 24, 2014 at 8:53 PM, Mason Sharp <ms...@tr...>wrote:

>
>>>>>
>>>>> On Sat, Feb 22, 2014 at 6:15 PM, Juned Khan <jkh...@gm...>wrote:
>>>>>
>>>>>> ,
>>>>>> 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.
>>>>>>
>>>>>
>>>
> Hi Juned,
>
> Your architecture seems to be a geographically distributed one, correct? I
> am not sure Postgres-XC is the best solution, but it depends on your
> requirements.  Is it acceptable if there is a network failure that some
> write transactions fail?  What about even reads if GTM is inaccessible? Are
> only some of your tables replicated? For those, is the write latency over a
> WAN acceptable? Again, it might all be fine, it just depends on your
> particular requirements.
>
>
> --
> Mason Sharp
>
> TransLattice - http://www.translattice.com
> Distributed and Clustered Database Solutions
>
>
>


-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com