(HA) mysql bind_address param is not compatible with nova cell_v2

[Oliver Walsh]

Nova cell_v2 stores the mysql db connection string for each cell database in a table in the api db.

In a HA deployment this connection string includes the IP address for the client to bind to (different on each node).

The default behavior of the cell_v2 setup is to take the connection string from nova.conf, but this will result in DB connect failing on every node except the node where cell_v2 setup was run.

However I assume it's not simply a case of stripping this param from the connection string as we would have regression of https://launchpad.net/tripleo/+bug/1643487.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/430049

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/430183

[Oliver Walsh (owalsh)]

I'm working on a different solution to https://launchpad.net/tripleo/+bug/1643487. In the meantime revert the change for all nova services.

[OpenStack Infra (hudson-openstack)]

Change abandoned by Emilien Macchi (<email address hidden>) on branch: master
Review: https://review.openstack.org/430049

[OpenStack Infra (hudson-openstack)]

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

commit 6d27319b7c23dccb3005e6cbbc21ff2b44929fd8
Author: Oliver Walsh <email address hidden>
Date: Tue Feb 7 10:18:36 2017 +0000

    Stop setting bind_address on nova db uri.

    This reverts the changes in https://review.openstack.org/414629 for nova as
    they are incompatible with cell_v2.

    This is a temporary fix for HA while a long-term solution is developed.

    Change-Id: I79d30a2d76a354999152c0c997ea77f104c51027
    Related-bug: #1643487
    Closes-bug: #1662344

[OpenStack Infra (hudson-openstack)]

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

commit 5353f1c7c9cd4408d10745206165aa4950ad76c6
Author: Steven Hardy <email address hidden>
Date: Thu Dec 1 10:02:56 2016 +0000

    Add nova service support for composable upgrades

    Co-Authored-By: Mathieu Bultel <email address hidden>
    Co-Authored-By: Oliver Walsh <email address hidden>

    Change-Id: Iafad800a6819d7e75fdaab60d328999d3d3c037f
    Partially-Implements: blueprint overcloud-upgrades-per-service
    Related-Bug: #1662344

[OpenStack Infra (hudson-openstack)]

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