<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">In our control plane cluster which HA setup by</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>- Pacemaker/Corosync</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>- HAProxy</div><div class="">When I’m moving virtual IP (VIP) to another node services</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>- nova[api-scheduler-conductor]</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>- cinder</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>- etc…</div><div class=""><br class=""></div><div class="">In all logs show</div><div class=""><br class=""></div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";" class="">ERROR nova.servicegroup.drivers.db DBConnectionError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on '10.60.1.220' ([Errno 111] ECONNREFUSED)") [SQL: u'SELECT 1’]</div></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";" class="">And here is haproxy.cfg</div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";" class="">##########</div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";" class=""><div style="margin: 0px; font-stretch: normal; line-height: normal;" class="">global</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> chroot /var/lib/haproxy</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> daemon</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> group haproxy</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> maxconn 16000</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> pidfile /var/run/haproxy.pid</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> user haproxy</div><div style="margin: 0px; font-stretch: normal; line-height: normal; min-height: 14px;" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class="">defaults</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> log 127.0.0.1 local0</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> maxconn 16000</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> option redispatch</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> retries 3</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> timeout http-request 10s</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> timeout queue 1m</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> timeout connect 10s</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> timeout client 3600s</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> timeout server 3600s</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> timeout check 10s</div><div style="margin: 0px; font-stretch: normal; line-height: normal; min-height: 14px;" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class="">listen galera_cluster</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> bind 10.60.1.220:3306</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> balance source</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> server controller5 10.60.1.15:3306 check inter 2000 rise 2 fall 5</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> server controller6 10.60.1.16:3306 backup check inter 2000 rise 2 fall 5</div><div style="margin: 0px; font-stretch: normal; line-height: normal;" class=""> server controller7 10.60.1.17:3306 backup check inter 2000 rise 2 fall 5</div><div class=""><br class=""></div><div class="">###########</div><div class=""><br class=""></div></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";" class="">I know it’s not service level problem or bug and causing by haproxy and mysql connection.</div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";" class="">I’m wondering if any experience or idea how to deal with it will be great</div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";" class=""><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";" class=""><br class=""></div></body></html>