pgpool2.git / summary / log / commit / refs
commit 9c0055087e20464e3e5fd28084d00c877e805bd6
Author: Yugo Nagata <nagata@sraoss.co.jp>
Date: Sun May 12 22:28:57 2013 +0000
Add new watchdog parameters ot pgpool.conf.sample*
pgpool.conf.sample | 1 -
pgpool.conf.sample-master-slave | 31 +++++++++++++++++++++++++++++++
pgpool.conf.sample-replication | 31 +++++++++++++++++++++++++++++++
pgpool.conf.sample-stream | 31 +++++++++++++++++++++++++++++++
4 files changed, 93 insertions(+), 1 deletion(-)
diff --git a/pgpool.conf.sample b/pgpool.conf.sample
index b86dabdd5..7d59cdf61 100644
--- a/pgpool.conf.sample
+++ b/pgpool.conf.sample
@@ -461,7 +461,6 @@ wd_interval = 10
# (change requires restart)
wd_authkey = ''
# Authentication key for watchdog communication
-
ping_path = '/bin'
# ping command path
# (change requires restart)
diff --git a/pgpool.conf.sample-master-slave b/pgpool.conf.sample-master-slave
index f8f4ba20d..f2598b56a 100644
--- a/pgpool.conf.sample-master-slave
+++ b/pgpool.conf.sample-master-slave
@@ -428,6 +428,18 @@ client_idle_limit_in_recovery = 0
use_watchdog = off
# Activates watchdog
# (change requires restart)
+watchdog_mode='udp'
+ # Mode of watchdog lifecheck ('udp' or 'query')
+ # (change requires restart)
+clear_memqcache_on_escalation = on
+ # Clear all the query cache on shared memory
+ # when standby pgpool escalate to active pgpool
+ # (= virtual IP holder).
+ # This should be off if client connects to pgpool
+ # not using virtual IP.
+ # (change requires restart)
+wd_escalation_command = ''
+ # Executes this command at escalation on new active pgpool.
trusted_servers = ''
# trusted server list which are used
# to confirm network connection
@@ -445,6 +457,8 @@ wd_port = 9000
wd_interval = 10
# lifecheck interval (sec) > 0
# (change requires restart)
+wd_authkey = ''
+ # Authentication key for watchdog communication
ping_path = '/bin'
# ping command path
# (change requires restart)
@@ -464,6 +478,22 @@ arping_path = '/usr/sbin' # arping command path
arping_cmd = 'arping -U $_IP_$ -w 1'
# arping command
# (change requires restart)
+wd_udp_port = 9694
+ # Port number for UDP heartbeat lifecheck
+wd_udp_keepalive = 2
+ # Interval time of sending UDP heartbeat signal (sec)
+wd_udp_deadtime = 30
+ # Deadtime interval for UDP heartbeat signal (sec)
+udp_device0 = 'eth0'
+ # Name of NIC device 0 using for
+ # sending/receiving heartbeat signal
+udp_destination0 = 'host0_ip1'
+ # Destination host name or IP address
+ # for sending heartbeat signal using NIC device 0.
+
+#udp_device1 = 'eth1'
+#udp_destination1 = 'host0_ip2'
+
wd_life_point = 3
# lifecheck retry times
# (change requires restart)
@@ -476,6 +506,7 @@ wd_lifecheck_user = 'nobody'
# watchdog user monitoring pgpools in lifecheck
wd_lifecheck_password = ''
# Password for watchdog user in lifecheck
+
# Other pgpool Connection Settings
#other_pgpool_hostname0 = 'host0'
diff --git a/pgpool.conf.sample-replication b/pgpool.conf.sample-replication
index fe6988117..93b80536f 100644
--- a/pgpool.conf.sample-replication
+++ b/pgpool.conf.sample-replication
@@ -427,6 +427,18 @@ client_idle_limit_in_recovery = 0
use_watchdog = off
# Activates watchdog
# (change requires restart)
+watchdog_mode='udp'
+ # Mode of watchdog lifecheck ('udp' or 'query')
+ # (change requires restart)
+clear_memqcache_on_escalation = on
+ # Clear all the query cache on shared memory
+ # when standby pgpool escalate to active pgpool
+ # (= virtual IP holder).
+ # This should be off if client connects to pgpool
+ # not using virtual IP.
+ # (change requires restart)
+wd_escalation_command = ''
+ # Executes this command at escalation on new active pgpool.
trusted_servers = ''
# trusted server list which are used
# to confirm network connection
@@ -444,6 +456,8 @@ wd_port = 9000
wd_interval = 10
# lifecheck interval (sec) > 0
# (change requires restart)
+wd_authkey = ''
+ # Authentication key for watchdog communication
ping_path = '/bin'
# ping command path
# (change requires restart)
@@ -463,6 +477,22 @@ arping_path = '/usr/sbin' # arping command path
arping_cmd = 'arping -U $_IP_$ -w 1'
# arping command
# (change requires restart)
+wd_udp_port = 9694
+ # Port number for UDP heartbeat lifecheck
+wd_udp_keepalive = 2
+ # Interval time of sending UDP heartbeat signal (sec)
+wd_udp_deadtime = 30
+ # Deadtime interval for UDP heartbeat signal (sec)
+udp_device0 = 'eth0'
+ # Name of NIC device 0 using for
+ # sending/receiving heartbeat signal
+udp_destination0 = 'host0_ip1'
+ # Destination host name or IP address
+ # for sending heartbeat signal using NIC device 0.
+
+#udp_device1 = 'eth1'
+#udp_destination1 = 'host0_ip2'
+
wd_life_point = 3
# lifecheck retry times
# (change requires restart)
@@ -475,6 +505,7 @@ wd_lifecheck_user = 'nobody'
# watchdog user monitoring pgpools in lifecheck
wd_lifecheck_password = ''
# Password for watchdog user in lifecheck
+
# Other pgpool Connection Settings
#other_pgpool_hostname0 = 'host0'
diff --git a/pgpool.conf.sample-stream b/pgpool.conf.sample-stream
index 76c62f641..fad2fbfc9 100644
--- a/pgpool.conf.sample-stream
+++ b/pgpool.conf.sample-stream
@@ -427,6 +427,18 @@ client_idle_limit_in_recovery = 0
use_watchdog = off
# Activates watchdog
# (change requires restart)
+watchdog_mode='udp'
+ # Mode of watchdog lifecheck ('udp' or 'query')
+ # (change requires restart)
+clear_memqcache_on_escalation = on
+ # Clear all the query cache on shared memory
+ # when standby pgpool escalate to active pgpool
+ # (= virtual IP holder).
+ # This should be off if client connects to pgpool
+ # not using virtual IP.
+ # (change requires restart)
+wd_escalation_command = ''
+ # Executes this command at escalation on new active pgpool.
trusted_servers = ''
# trusted server list which are used
# to confirm network connection
@@ -444,6 +456,8 @@ wd_port = 9000
wd_interval = 10
# lifecheck interval (sec) > 0
# (change requires restart)
+wd_authkey = ''
+ # Authentication key for watchdog communication
ping_path = '/bin'
# ping command path
# (change requires restart)
@@ -463,6 +477,22 @@ arping_path = '/usr/sbin' # arping command path
arping_cmd = 'arping -U $_IP_$ -w 1'
# arping command
# (change requires restart)
+wd_udp_port = 9694
+ # Port number for UDP heartbeat lifecheck
+wd_udp_keepalive = 2
+ # Interval time of sending UDP heartbeat signal (sec)
+wd_udp_deadtime = 30
+ # Deadtime interval for UDP heartbeat signal (sec)
+udp_device0 = 'eth0'
+ # Name of NIC device 0 using for
+ # sending/receiving heartbeat signal
+udp_destination0 = 'host0_ip1'
+ # Destination host name or IP address
+ # for sending heartbeat signal using NIC device 0.
+
+#udp_device1 = 'eth1'
+#udp_destination1 = 'host0_ip2'
+
wd_life_point = 3
# lifecheck retry times
# (change requires restart)
@@ -475,6 +505,7 @@ wd_lifecheck_user = 'nobody'
# watchdog user monitoring pgpools in lifecheck
wd_lifecheck_password = ''
# Password for watchdog user in lifecheck
+
# Other pgpool Connection Settings
#other_pgpool_hostname0 = 'host0'
[parent: b71260466582]