mariadb+galera doesn't work multinode

[Steven Dake]

mariadb container fails on multinode because the bootstrapping node creates databases owned by root which the mariadb process cannot access since it drops its own privileges to run as the mysql user. The databases on the bootstrap node need to be created as the mysql user.

Further the directory /var/lib/mysql is imported into the data container as owned by root. It should be owned by mariadb instead. We have a chmod in there to set the empty directory /var/lib/mysql to mysql, but it only runs on the bootstrap nodes, not the the nodes in the cluster so /var/lib/mysql isnt writeable on the slave nodes.

Note ubuntu mariadb may not drop the process owner to mysql resulting in a difference in behavior on ubuntu vs centos.

Full analysis coming in an update to this bug.

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/218982
Committed: https://git.openstack.org/cgit/stackforge/kolla/commit/?id=3f1a3c386a6ad10fb1965583159f1a15f19200e4
Submitter: Jenkins
Branch: master

commit 3f1a3c386a6ad10fb1965583159f1a15f19200e4
Author: Sam Yaple <email address hidden>
Date: Mon Aug 31 18:39:00 2015 +0000

    Fix mysql permissions

    Closes-Bug: #1489537
    Change-Id: I6544398f8cebe2a0d1bec6db2a75a9f8651f5d6f