On 2/21/11 6:24 PM, Lazaro Ruben Garcia Martinez wrote:
> The number of server that can take place in the cluster, all of then
> replicated with pgpool-II without lost performance?
That's not really a meaningful question.
pgPool2 replication is statement-based replication. If you have even a
second server, you're going to pay 5-20% overhead on writes, depending
on workload. With more servers, the penalty on writes goes up.
The general idea of pgPool2 replication is that some workloads are 90%
reads, so the benefit from load-balancing the reads can outweigh the
penalty from replicating the writes.
So what % reads is your workload?
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
