Brad Nicholson bnichols at ca.afilias.info
Mon Aug 25 07:09:31 PDT 2008
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.

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

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.



More information about the Slony1-general mailing list