[pgpool-general: 4496] Re: follow_master in case the old master does not have network connectivity.
tkirstine at firstbasesolutions.com
Fri Feb 26 00:27:57 JST 2016
I'm somewhat new to pgpool myself so this may be wrong but my understanding is that when a node (master or standby) fails pgpool marks that node as offline. When the issue with the failed node is resolved you must re-attach the node to bring it back into the cluster using the pcp_attach_node command
pcp_attach_node 10 localhost 9898 user password node_id
There may be a method to handle this automatically but I don't know it.
From: pgpool-general-bounces at pgpool.net <pgpool-general-bounces at pgpool.net> on behalf of Avi Weinberg <AviW at gilat.com>
Sent: Thursday, February 25, 2016 10:20 AM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 4495] follow_master in case the old master does not have network connectivity.
If I understood correctly follow_master is called immediately after old master fails and new master is promoted. However, what if there is no connection to old master and the connection resumes after few minutes. Will follow_master will be executed then?. Is there an automatic way to make the old master into a slave if the old master machine is reconnected only after an extended period of time? Who should monitor the old master connectivity?
Thanks for all the assistance
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general