Can't connect to mariadb in nonha haproxy setup

[Martin André]

When deploying overcloud in nonha configuration, haproxy sees backup mysql server as down and assumes the service is down:

Sep 23 13:59:07 overcloud-controller-0 haproxy[6820]: Backup Server mysql/overcloud-controller-0 is DOWN, reason: Layer4 connection problem, info: "Connection refused", check duration: 0ms. 0 active and 0 backup s
Sep 23 13:59:07 overcloud-controller-0 haproxy[6820]: proxy mysql has no server available!

Mariadb binds to the hostname node, which resolves to 127.0.0.1.

[heat-admin@overcloud-controller-0 ~]$ sudo grep bind-address /etc/my.cnf.d/galera.cnf
bind-address = overcloud-controller-0

[heat-admin@overcloud-controller-0 ~]$ grep overcloud-controller-0 /etc/hosts
127.0.0.1 overcloud-controller-0.localdomain overcloud-controller-0
192.0.2.14 overcloud-controller-0.localdomain overcloud-controller-0
192.0.2.14 overcloud-controller-0.external.localdomain overcloud-controller-0.external
192.0.2.14 overcloud-controller-0.internalapi.localdomain overcloud-controller-0.internalapi
192.0.2.14 overcloud-controller-0.storage.localdomain overcloud-controller-0.storage
192.0.2.14 overcloud-controller-0.storagemgmt.localdomain overcloud-controller-0.storagemgmt
192.0.2.14 overcloud-controller-0.tenant.localdomain overcloud-controller-0.tenant
192.0.2.14 overcloud-controller-0.management.localdomain overcloud-controller-0.management
192.0.2.14 overcloud-controller-0.ctlplane.localdomain overcloud-controller-0.ctlplane

We should have it bind to overcloud-controller-0.internalapi.localdomain instead.

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/375523
Committed: https://git.openstack.org/cgit/openstack/tripleo-heat-templates/commit/?id=a387c110a6ffbedb1a62f218be1ce2c0636b5b38
Submitter: Jenkins
Branch: master

commit a387c110a6ffbedb1a62f218be1ce2c0636b5b38
Author: Juan Antonio Osorio Robles <email address hidden>
Date: Fri Sep 23 17:28:06 2016 +0300

    Bind MySQL address to hostname appropriate to its network

    This now takes into use the mysql_bind_host key, to set an
    appropriate fqdn for mysql to bind to.

    Closes-Bug: #1627060
    Change-Id: I50f4082ea968d93b240b6b5541d84f27afd6e2a3
    Depends-On: I316acfd514aac63b84890e20283c4ca611ccde8b

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/tripleo-heat-templates 5.0.0.0rc2 release candidate.