<div dir="ltr">Hi<div><br></div><div>Thanks for pointing that out. This is an infect the documentation mistake. The <span style="font-family:arial,sans-serif">failover_require_consensus has nothing to do with VIP and it only configures the behaviour of backend node failover.</span></div><div><span style="font-family:arial,sans-serif">The acquisition VIP by master(active) Pgpool-II only depends upon the existence of a quorum.</span></div><div><span style="font-family:arial,sans-serif">I will update the documentation to rectify this mistake</span></div><div><span style="font-family:arial,sans-serif"><br></span></div><div><span style="font-family:arial,sans-serif">Thanks</span></div><div><span style="font-family:arial,sans-serif">Best regards</span></div><div><span style="font-family:arial,sans-serif">Muhammad Usama</span></div><div><span style="font-family:arial,sans-serif"><br></span></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Nov 19, 2019 at 7:08 AM Rafael Thofehrn Castro <<a href="mailto:rafaelthca@gmail.com">rafaelthca@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><font face="arial, sans-serif">Hi all,</font></div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">I am testing pgpool 4.1.0 and ended up in something I found inconsistent. This is the description of the delegate_IP parameter in 4.1:</font></div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">> <span style="color:rgb(0,0,0)">Specifies the virtual IP address (VIP) of </span><span style="color:rgb(68,0,0)">Pgpool-II</span><span style="color:rgb(0,0,0)"> that is connected from client servers (application servers etc.). When a </span><span style="color:rgb(68,0,0)">Pgpool-II</span><span style="color:rgb(0,0,0)"> is switched from standby to active, the </span><span style="color:rgb(68,0,0)">Pgpool-II</span><span style="color:rgb(0,0,0)"> takes over this VIP. If </span><a href="https://www.pgpool.net/docs/latest/en/html/runtime-watchdog-config.html#GUC-FAILOVER-REQUIRE-CONSENSUS" style="color:rgb(0,78,102)" target="_blank">failover_require_consensus</a><span style="color:rgb(0,0,0)"> is on (the default), VIP will not be brought up in case the quorum does not exist. Default is </span><tt style="color:rgb(68,0,0)">''</tt><span style="color:rgb(0,0,0)">(empty): which means virtual IP will never be brought up.</span></font></div><div><span style="color:rgb(0,0,0)"><font face="arial, sans-serif"><br></font></span></div><div><font face="arial, sans-serif">The part that explains about failover_require_consensus says that if this parameter is enabled then VIP will not be claimed if quorum does NOT exist. I assume that if I DISABLE this parameter then VIP will be claimed even there is no quorum.<span style="color:rgb(0,0,0)"><br></span></font></div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">However, when testing with a 3 nodes cluster and failover_require_consensus disabled, when I shutdown two nodes the third one doesn't claim the VIP. This is what the log states:</font></div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">> LOG: I am the cluster leader node but we do not have enough nodes in cluster</font></div><div><font face="arial, sans-serif">> DETAIL: waiting for the quorum to start escalation process</font></div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">In fact, I checked the source code and found no relationship between </font>failover_require_consensus and escalation.</div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">I'm not complaining about the behavior, just that it seems inconsistent with what the doc states. Or perhaps I misunderstood it.</font></div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">Regards,</font></div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">Rafael Castro.</font></div><div><br></div></div>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote></div>