Ow Mun Heng Ow.Mun.Heng at wdc.com
Wed Aug 27 19:19:19 PDT 2008
On Mon, 2008-08-25 at 10:09 -0400, Brad Nicholson wrote:
> On Mon, 2008-08-25 at 12:25 +0800, Ow Mun Heng wrote:
> > Just wondering if it's possible to do a cluster on a slony replicated DB
> > in either master/slave??
> 
> You can, with a couple of caveats.
> 
> 1: Cluster will take an access exclusive lock the table in question and
> replication will fall behind for the duration of the cluster if anything
> tries to write to the table be being clustered.

That's understandable.
> 
> 2: Prior to 8.3, cluster is not MVCC safe, so it is very possible to
> break things by clustering.

Break as in break the replication or break PG?

Hmm..

But, all in all, I can still do the cluster individually right? And not
through slonik


More information about the Slony1-general mailing list