DB connection: prevent src address from binding to a VIP
authorDamien Ciabrini <dciabrin@redhat.com>
Fri, 23 Dec 2016 16:57:48 +0000 (17:57 +0100)
committerDamien Ciabrini <dciabrin@redhat.com>
Tue, 3 Jan 2017 09:56:02 +0000 (10:56 +0100)
commit56ebc7e58d117743363c4a251395d710bf511a2c
tree7efbb81cb993b072b3029d6a1a32d3bdeeaa4bed
parent4c25c57c497430c5b4fd740669c8e51bbe81092a
DB connection: prevent src address from binding to a VIP

When a service connects to the database VIP from the node hosting this
VIP, the resulting TCP socket has a src address which is by default
bound to the VIP as well. If the VIP is failed over to another node
while the socket's Send-Q is not empty, TCP keepalive won't engage and
the service will become unavailable for a very long time (by default
more than 10m).

To prevent failover issues, DB connections should have the src address
of their TCP socket bound to the IP of the network interface used for
MySQL traffic. This is achieved by passing a new option to the
database connection URIs. This option is available starting from
PyMySQL 0.7.9-2.

We use a new intermediate variable in hiera to hold the IP to be used
as a source address for all DB connections. All services adapt their
database URI accordingly.

Moreover, a new YAML validation check is added to guarantee that new
services will construct their database URI appropriately.

Change-Id: Ic69de63acbfb992314ea30a3a9b17c0b5341c035
Closes-Bug: #1643487
19 files changed:
puppet/services/aodh-base.yaml
puppet/services/barbican-api.yaml
puppet/services/ceilometer-base.yaml
puppet/services/cinder-base.yaml
puppet/services/database/mysql.yaml
puppet/services/glance-api.yaml
puppet/services/glance-registry.yaml
puppet/services/gnocchi-base.yaml
puppet/services/heat-engine.yaml
puppet/services/ironic-base.yaml
puppet/services/keystone.yaml
puppet/services/manila-base.yaml
puppet/services/mistral-base.yaml
puppet/services/neutron-api.yaml
puppet/services/neutron-plugin-plumgrid.yaml
puppet/services/nova-base.yaml
puppet/services/panko-base.yaml
puppet/services/sahara-base.yaml
tools/yaml-validate.py