Mon Aug 25 07:09:31 PDT 2008
- Previous message: [Slony1-general] Can I perform CLUSTER on a slony DB?
- Next message: [Slony1-general] Can I perform CLUSTER on a slony DB?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] Can I perform CLUSTER on a slony DB?
- Next message: [Slony1-general] Can I perform CLUSTER on a slony DB?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list