Re: [GENERAL] replicate or multi-master for 9.1 or 9.2

2012-09-28 Thread a...@hsk.hk
correction: because the single master was too BUSY On 28 Sep 2012, at 7:48 PM, a...@hsk.hk wrote: > Hi Jon, > > I have had a similar case as yours, I have one data center in Hong Kong > another one in Tokyo, we have line between them, here are my feedback: > > 1) we used multiple masters at fi

Re: [GENERAL] replicate or multi-master for 9.1 or 9.2

2012-09-28 Thread a...@hsk.hk
Hi Jon, I have had a similar case as yours, I have one data center in Hong Kong another one in Tokyo, we have line between them, here are my feedback: 1) we used multiple masters at first, from time to time, some issues like that it took time to sync between master servers which caused obvious

Re: [GENERAL] replicate or multi-master for 9.1 or 9.2

2012-09-27 Thread Chris Travers
On Thu, Sep 27, 2012 at 9:37 PM, Jon Hancock wrote: > We have a new pg system on 9.1, just launched inside China. We now know > we may need to run a replicate, with some writes to it outside China. > Would like some advice. Here are parameters: > > 1 - Our data center is in Beijing. If we hav

Re: [GENERAL] replicate or multi-master for 9.1 or 9.2

2012-09-27 Thread John R Pierce
On 09/27/12 9:37 PM, Jon Hancock wrote: We have a new pg system on 9.1, just launched inside China. We now know we may need to run a replicate, with some writes to it outside China. Would like some advice. Here are parameters: 1 - Our data center is in Beijing. If we have a replicate in a