[pgpool-hackers: 3673] Re: Proposal: Simplify WATCHDOG host configurations.

[Tatsuo Ishii]

> Ishii-san, Usama,
> 
> Thank you for your advice.
> I have some questions about heartbeat related parameters.
> 
> I would like to change the watchdog related parameters as follow:
> 
> ----------------------
> wd_hostname0 =                  
> pgpool_port0 = 
> wd_port0 = 
> 
> wd_hostname1 =                  
> pgpool_port1 = 
> wd_port1 =
> .
> .
> .
> 
> heartbeat_hostname0 =
> heartbeat_port0 =
> heartbeat_device0 =
> 
> heartbeat_hostname1 =
> heartbeat_port1 =
> heartbeat_device1 =
> ----------------------
> 
> However, during the implementation, I noticed more than one network interface
> can be specified to send/receive heartbeat signal in Pgpool-II.
> 
> Because only one "wd_heartbeat_port" can be specified,
> "heartbeat_destination_portX" should be specified with the same port number?
> 
> 
> For example: 3 pgpool node, heartbeat with 2 NIC
> 
> Should we configure heartbeat paramaters as below?
> 
> ---------------
> wd_heartbeat_port = 9694
> 
> heartbeat_destination0 = "192.168.37.102"
> heartbeat_destination1 = '192.168.54.102'
> heartbeat_destination_port0 = 9694 
> heartbeat_destination_port1 = 9694 
> heartbeat_device0 = 'eth0'
> heartbeat_device1 = 'eth1'
> 
> heartbeat_destination2 = '192.168.37.103'
> heartbeat_destination3 = '192.168.54.103'
> heartbeat_destination_port2 = 9694 
> heartbeat_destination_port3 = 9694 
> heartbeat_device2 = 'eth0'
> heartbeat_device3 = 'eth1'
> ---------------
> 
> 
> If above is correct, I would like to design the heartbeat paramaters as below:
> If it is the own node settings, "heartbeat_hostname" and "heartbeat_device" will be ignored.
> 
> ---------------
> heartbeat_hostname0 = '192.168.37.101:192.168.54.101'
> heartbeat_port0 = 9694
> heartbeat_device0 = 'eth0:eth1'
> 
> heartbeat_hostname1 = '192.168.37.102:192.168.54.102'
> heartbeat_port1 = 9694
> heartbeat_device1 = 'eth0:eth1'
> 
> heartbeat_hostname2 = '192.168.37.103:192.168.54.103'
> heartbeat_port2 = 9694
> heartbeat_device2 = 'eth0:eth1'
> ---------------
> 
> What do you think?

Above looks good to me.

BTW, if the IP addresses are on the same subnet, it is not enough to
specify heartbeat_device. You also need to tweak Linux kernel
parameters
(/proc/sys/net/ipv4/conf/***/{arp_announce,arp_ignore). Maybe we
should note this in the manual.

I have learned this from following blog (in Japanese).

http://www.nminoru.jp/~nminoru/diary/2014/02.html#20140203p1

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp