mariadb+galera doesn't work multinode
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
kolla |
Fix Released
|
Critical
|
Steven Dake |
Bug Description
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.
Changed in kolla: | |
status: | New → Confirmed |
importance: | Undecided → Critical |
assignee: | nobody → Steven Dake (sdake) |
milestone: | none → liberty-3 |
Changed in kolla: | |
status: | Confirmed → In Progress |
Changed in kolla: | |
status: | Fix Committed → Fix Released |
Reviewed: https:/ /review. openstack. org/218982 /git.openstack. org/cgit/ stackforge/ kolla/commit/ ?id=3f1a3c386a6 ad10fb196558315 9f1a15f19200e4
Committed: https:/
Submitter: Jenkins
Branch: master
commit 3f1a3c386a6ad10 fb1965583159f1a 15f19200e4
Author: Sam Yaple <email address hidden>
Date: Mon Aug 31 18:39:00 2015 +0000
Fix mysql permissions
Closes-Bug: #1489537 a0d1bec6db2a75a 9f8651f5d6f
Change-Id: I6544398f8cebe2