Containerized MySQLClient

[Damien Ciabrini]

Create the template for generating the MySQL client configuration for containerized services. The documentation for the architecture can be found here[0] and some examples in the source tree[1]

[0] https://docs.openstack.org/developer/tripleo-docs/containers_deployment/
[1] http://git.openstack.org/cgit/openstack/tripleo-heat-templates/tree/docker/services

[Dan Prince (dan-prince)]

What did you have in mind here? Is this for debugging or for initializing the various services?

[Damien Ciabrini (dciabrin)]

There is a dedicated puppet module [1] to be called for generating a
specific client MySQL configuration which controls client bind address
and SSL connection. It is not being used yet in containers.

We could update all the services to include this puppet module during
the puppet config step, but in this case, if one needs to change this
file during minor updates, all services need to regenerate their
config, which I believe will cause outage.

The other solution I see is to generate the configuration file in its
dedicated location /var/log/config-data/mysql_client, and let all
services bind mount it. This way, config file change during minor
update will be taken into account at next service restart.

Any thought on that approach?

[1] /var/lib/config-data/mysql_client/etc/my.cnf.d/tripleo.cnf

[Dan Prince (dan-prince)]

Damien: we just spoke but I'm wondering if perhaps this is something we could add into docker/services/containers-common.yaml. It might end up getting bind mounted into containers where we don't always need it but so long as there isn't a security concern there I think it would be fine to add it this way.

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/466531
Committed: https://git.openstack.org/cgit/openstack/tripleo-heat-templates/commit/?id=80f6907054f4e2683de5e54a1635ab56d8b3aa4e
Submitter: Jenkins
Branch: master

commit 80f6907054f4e2683de5e54a1635ab56d8b3aa4e
Author: Damien Ciabrini <email address hidden>
Date: Tue Jun 6 08:50:54 2017 -0400

    Configuration for containerized MySQL clients

    This service generates the /etc/my.cnf.d/tripleo.cnf file which is
    being used to configured MySQL clients (e.g. client bind address,
    client SSL configuration...)

    We generate the config file in this service and let containerized MySQL clients
    mount /var/lib/config-data/mysql_client/etc/my.cnf.d/tripleo.cnf it in their
    own container. This way, when this MySQLClient service is updated, the other
    containers will automatically pick the updated configuration at next restart.

    Partial-Bug: #1692317
    Change-Id: Idc56d27fb9645ad3b07df8ef08b7e2ce29e6d499

[OpenStack Infra (hudson-openstack)]

Change abandoned by Damien Ciabrini (<email address hidden>) on branch: master
Review: https://review.openstack.org/469372
Reason: Superseded by I0dab1dc9caef1e749f1c42cfefeba179caebc8d7

[Damien Ciabrini (dciabrin)]

Review https://review.openstack.org/#/c/481965/ got merged and fixes it.