[pgpool-hackers: 3208] Implement new feature auto-recovery
Asaf Ohayon
asaf at sysbind.co.il
Fri Jan 4 06:59:41 JST 2019
Hello
I've started to implement auto-recovery here:
https://github.com/SysBind/pgpool2/commit/bc5c1b4029c569470917b72386623146fdf19415
Seeking for a little advice, done so far:
In health_check main loop, if the node is in degenerated state,
try to ping it, when it repsonses, (like coming up after reboot),
execute online-recovery on it.
Issues:
1. Altough degenerated backend seems down (e.g: in pcp_node_info),
in recovery() I get:
node recovery failed, node id: %d is alive,
2. Still need some code to mark the node as candidate for auto-recovery,
and not try to
establish_persistent_connection to it
Any remarks are welcome
Thanks
--
Asaf Ohayon
SRE | SysBind
M: +972 547920828
P: + 972 3 5096219
E: asaf at sysbind.co.il
Rothschild 60, Bat Yam
www.sysbind.co.il
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20190103/b3f16ff9/attachment.html>
More information about the pgpool-hackers
mailing list