[pgpool-general: 2263] PGPool and backend CPU usage
stelios.limnaios at mekon.com
Fri Nov 8 19:58:42 JST 2013
We're facing a situation that would like some expertise to be solved.
First of all, our setup consists of 3 databases Postgres 9.1, PGPool 3.2 STABLE checked out from the repository (rev 6dde744) and PGPoolAdmin 3.2.0.
We have setup replication and load balancing, along with scripts for online recovery.
The cluster works fine in terms of replicating and load balancing data.
But, the servers host other applications expect of the databases.
Some applications require a lot of CPU when running.
We found recently that when CPU is high in a backend, PGPool fails to update the data on this server and that causes a 'kind mismatch among backends' situation.
I know that there is a replication_stop_on_mismatch parameter in pgpool conf, but that will disconnect the database from the cluster and we will have to re-attach it (this could happen several times).
So I was wondering, if there is a more permanent workaround for this.
Is it something we can configure in PGPool?
Are there any minimum memory requirements that we could set to avoid this problem?
Would that be in Postgres?
Maybe the best option is to dedicate the server to run the database only (?).
Thanks in advance for your help and your time.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general