[pgpool-general: 5296] Re: pgPool nodes keep disconnecting

[Simon Windsor]

Hi

I an very sorry for the late reply, but the issue has cleared itself when we increased the number of vCPU cores assigned to the pgPool node.

The data replication application my colleague is writing, while I manage the DB, appears to become stable at two vCPU and optimum performance at four vCPU, adding more nodes appears to make no difference to data loading on the clients, although we are still testing with 

one pgPool node, 4vCPU and 4G memory
two Postgres nodes, 2 vCPU and 12G memory.

I wonder if the pgPool disconnected if the server was too busy? Anyway, all seems fine and as we scale up to 10-12 Postgres DBs we will keep an eye on pgPool.

Thanks for the offer of help,

Simon

> On 25 Jan 2017, at 09:15, Muhammad Usama <m.usama at gmail.com> wrote:
> 
> Hi
> 
> Please share the pgpool.conf and log files., Pgpool-II log should have the information why Pgpool is detaching the backend node. 
> 
> Thanks
> Best regards
> Muhammad Usama
> 
> 
> On Wed, Jan 25, 2017 at 1:47 PM, Simon Windsor <simon.windsor at cornfield.me.uk <mailto:simon.windsor at cornfield.me.uk>> wrote:
> Hi
> 
> We are testing pgPool with two Postgres 9.5 nodes, and using pgPool to manage the replication of data to the two databases.
> 
> Every few days, one of the nodes goes from status 2 to 3, until we re-atach the node. There doesn't appear to be anything that triggers this. Is this a known issue that we can handle automatically, if so how, or is there some logging I must enable to track the root casue?
> 
> Thank you
> 
> Simon
> 
> -- 
> Simon Windsor
> 
> Eml: simon.windsor at cornfield.me.uk <mailto:simon.windsor at cornfield.me.uk>
> Tel: 01454 617689
> Mob: 0755 197 9733
> 
> 
> “There is nothing in the world that some man cannot make a little worse and sell a little cheaper, and he who considers price only is that man's lawful prey.”
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net <mailto:pgpool-general at pgpool.net>
> http://www.pgpool.net/mailman/listinfo/pgpool-general <http://www.pgpool.net/mailman/listinfo/pgpool-general>
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170204/4250f16c/attachment-0001.html>