[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