Can't connect to mariadb in nonha haproxy setup

Bug #1627060 reported by Martin André
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
tripleo
Fix Released
Undecided
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 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.

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)

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

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 5.0.0.0rc2

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

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

Other bug subscribers