[Pgcluster-general] PGCluster Features and Use Cases

Mark Plutowski mark at vlnks.com
Fri Feb 29 21:31:52 UTC 2008


I've perused the mailing list archive, the old and new site, and
various online articles and still have some questions about features
and use cases that are supported by PGCluster.  If anyone can either
provide or point me to an answer for one or more of the following
questions I surely appreciate it.


Q1. Could a selected DB participate in replication as a read-only
slave but be excluded from load balancing? This would give DB that is
intended purely for hot failover.


Q2. Can PGCluster be configured to operate in Reliable Mode for one
slave, and Normal Mode for a different slave?


Q3. Can PGCluster be configured to treat one subset of tables in a
cluster as multi-master mode, and a different subset within that same
cluster as read-only slaves?  This would allow multiple clusters to
operate in multi-master mode on the first subset of tables, but
restrict the second (mutually distinct) subset of tables to have a
single master.


Q4. Does PBCluster automatically propagate schema changes?


Q5. What is the impact of Normal and Reliable Mode on write
performance? I'm looking for some anecdotal or testimonial evidence
here.


Thanks in advance!


More information about the Pgcluster-general mailing list