+ host => '%', Allow all source IPs when accessing DB. Related to multiple existing VIPs. And incorrect VIP used as SOURCE IP when accessing MySQL
root@node-4:~# ip netns exec haproxy ip r
default via 240.0.0.1 dev hapr-ns metric 10000
10.30.0.0/24 via 240.0.0.1 dev hapr-ns metric 10000
192.168.0.0/24 dev b_es_vip_mgmt proto kernel scope link src 192.168.0.248
192.168.0.0/24 dev b_influxdb proto kernel scope link src 192.168.0.247
192.168.0.0/24 dev b_database proto kernel scope link src 192.168.0.249
192.168.0.0/24 via 240.0.0.1 dev hapr-ns metric 10000
192.168.1.0/24 via 240.0.0.1 dev hapr-ns metric 10000
240.0.0.0/30 dev hapr-ns proto kernel scope link src 240.0.0.2
+ $mysql = hiera_hash('mysql') related to this override
https:/ /github. com/openstack/ fuel-plugin- detach- database/ blob/stable/ 8.0/deployment_ scripts/ database_ hiera_override. pp#L87- L88
+ host => '%', Allow all source IPs when accessing DB. Related to multiple existing VIPs. And incorrect VIP used as SOURCE IP when accessing MySQL
root@node-4:~# ip netns exec haproxy ip r
default via 240.0.0.1 dev hapr-ns metric 10000
10.30.0.0/24 via 240.0.0.1 dev hapr-ns metric 10000
192.168.0.0/24 dev b_es_vip_mgmt proto kernel scope link src 192.168.0.248
192.168.0.0/24 dev b_influxdb proto kernel scope link src 192.168.0.247
192.168.0.0/24 dev b_database proto kernel scope link src 192.168.0.249
192.168.0.0/24 via 240.0.0.1 dev hapr-ns metric 10000
192.168.1.0/24 via 240.0.0.1 dev hapr-ns metric 10000
240.0.0.0/30 dev hapr-ns proto kernel scope link src 240.0.0.2