Can't connect to mariadb in nonha haproxy setup

Bug #1627060 reported by Martin André
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Fix Released
Juan Antonio Osorio Robles

Bug Description

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

[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 overcloud-controller-0.localdomain overcloud-controller-0 overcloud-controller-0.localdomain overcloud-controller-0 overcloud-controller-0.external.localdomain overcloud-controller-0.external overcloud-controller-0.internalapi.localdomain overcloud-controller-0.internalapi overcloud-controller-0.storagemgmt.localdomain overcloud-controller-0.storagemgmt overcloud-controller-0.tenant.localdomain overcloud-controller-0.tenant overcloud-controller-0.ctlplane.localdomain overcloud-controller-0.ctlplane

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

Changed in tripleo:
assignee: nobody → Juan Antonio Osorio Robles (juan-osorio-robles)
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to tripleo-heat-templates (master)

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

Changed in tripleo:
status: In Progress → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/tripleo-heat-templates

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers