[pgpool-general: 2264] pgpool2 and bucardo

[Videanu Adrian]

Hi All,

I was wondering if someone ever tried to put Bucardo in async master-master setup on two pgpool servers

Let`s say i have to locations, one in Europe and one in US, on both locations I will have a Pgpool2 instance. I want to use Bucardo to replicate changes between those to pgpool clusters.


pgPool2 US  - - - - - - - - -> Bucardo Multimaster Async <- - - - - - - - - - - PgPool2 Europe




Regards,
Adrian Videanu


________________________________
 From: Stelios Limnaios <stelios.limnaios at mekon.com>
To: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net> 
Sent: Friday, November 8, 2013 12:58 PM
Subject: [pgpool-general: 2263] PGPool and backend CPU usage
 


Hi all,
 
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.
 
Regards,
Stelios
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20131108/a0db3319/attachment.html>