[pgpool-hackers: 172] Improvement of watchdog monitoring method

Yugo Nagata nagata at sraoss.co.jp
Fri Mar 1 16:39:45 JST 2013


Hi pgpool-hackers,

I'm thinking to fix pgpool watchdog to use heartbeat signal instead of
SQL query.

In current version, watchdog monitors other pgpools by using SQL query
such as 'SELECT 1'. However, this requires a connection to backend DB.
Therefore if there are connections larger than max_connections, watchdog
fails to establish connection and treats pgpool-II as down. In addition,
if all backend DB are down, watchdog treats pgpool-II as down.

The idea for an improvement is that watchdog monitors other pgpool by
using  heartbeat signal. Watchdog sends hearbeat to others periodically.
If there are no signal for a certain interval, watchdog treats the pgpool
as down. I think of using UDP for low overhead.

-- 
Yugo Nagata <nagata at sraoss.co.jp>


More information about the pgpool-hackers mailing list