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

[Mason S. <ms...@tr...>]

>
>
>>>>
>>>> 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