my.cnf is not equal on controllers

[Sergii Golovatiuk]

Deployment doesn't create /root/.my.cnf identical on all nodes.

fuel nodes | awk '/ready.*controller.*True/{print $9}' | xargs -n1 -i ssh 2>/dev/null {} 'hostname; grep host ~/.my.cnf'
node-2.test.domain.local
host='10.108.1.3'
host='10.108.1.3'
host='10.108.1.3'
host='10.108.1.3'
host='10.108.1.3'
node-5.test.domain.local
host='localhost'
host='localhost'
host='localhost'
host='localhost'
host='localhost'
node-4.test.domain.local
host='localhost'
host='localhost'
host='localhost'
host='localhost'
host='localhost'

Environment:
rpm -qa | egrep 'fuel|astute|network-checker|shotgun':
 fuel-release-9.0.0-1.mos6316.noarch
 rubygem-astute-9.0.0-1.mos724.noarch
 fuel-library9.0-9.0.0-1.mos8145.noarch
 fuel-agent-9.0.0-1.mos262.noarch
 fuel-ui-9.0.0-1.mos2600.noarch
 fuel-nailgun-9.0.0-1.mos8557.noarch
 fuel-migrate-9.0.0-1.mos8145.noarch
 fuel-misc-9.0.0-1.mos8145.noarch
 fuel-mirror-9.0.0-1.mos128.noarch
 fuel-bootstrap-cli-9.0.0-1.mos262.noarch
 fuel-provisioning-scripts-9.0.0-1.mos8557.noarch
 network-checker-9.0.0-1.mos72.x86_64
 shotgun-9.0.0-1.mos84.noarch
 fuel-openstack-metadata-9.0.0-1.mos8557.noarch
 fuel-notify-9.0.0-1.mos8145.noarch
 fuel-setup-9.0.0-1.mos6316.noarch
 python-fuelclient-9.0.0-1.mos292.noarch
 fuelmenu-9.0.0-1.mos262.noarch
 fuel-9.0.0-1.mos6316.noarch
 fuel-utils-9.0.0-1.mos8145.noarch
 fuel-ostf-9.0.0-1.mos919.noarch

[Matthew Mosesohn (raytrac3r)]

I'm ok with fixing .my.cnf, just ensure we don't break detach-database plugin. We need to enable remote database functionality to work.

[OpenStack Infra (hudson-openstack)]

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

[Matthew Mosesohn (raytrac3r)]

This bug really should not be high priority. It doesn't contribute to any deployment failures. Having extra entries may be a nuisance, but no one is harmed here. If anything, it should be medium and tech-debt.

[Alex Schultz (alex-schultz)]

The cause of the differences is due to the */db.pp tasks because of the need to support them not being run on the database (detached-db). The correct fix is probably to switch the */db.pp to only use the vip if not colocated with the mysql instances

[Sergii Golovatiuk (sgolovatiuk)]

It doesn't break deployment thus lowering to medium

[OpenStack Infra (hudson-openstack)]

Change abandoned by Sergii Golovatiuk (<email address hidden>) on branch: master
Review: https://review.openstack.org/295968