Open Stack

Hi,

In our control plane cluster which HA setup by
	- Pacemaker/Corosync
	- HAProxy
When I’m moving virtual IP (VIP) to another node services
	- nova[api-scheduler-conductor]
	- cinder
	- etc…

In all logs show

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’]

And here is haproxy.cfg

##########
global
  chroot  /var/lib/haproxy
  daemon
  group  haproxy
  maxconn  16000
  pidfile  /var/run/haproxy.pid
  user  haproxy

defaults
  log  127.0.0.1 local0
  maxconn  16000
  option  redispatch
  retries  3
  timeout  http-request 10s
  timeout  queue 1m
  timeout  connect 10s
  timeout  client 3600s
  timeout  server 3600s
  timeout  check 10s

listen galera_cluster
 bind 10.60.1.220:3306
 balance source
 server controller5 10.60.1.15:3306 check inter 2000 rise 2 fall 5
 server controller6 10.60.1.16:3306 backup check inter 2000 rise 2 fall 5
 server controller7 10.60.1.17:3306 backup check inter 2000 rise 2 fall 5

###########

I know it’s not service level problem or bug and causing by haproxy and mysql connection.

I’m wondering if any experience or idea how to deal with it will be great


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200623/ddf0ae34/attachment.html>