Management in High Availability Guide

[fzhylaunchpad]

the command is error
# systemctl start mariadb --wsrep-new-cluster

is:
# /usr/libexec/mysqld --wsrep-new-cluster --user=root &

-----------------------------------
Release: 0.0.1 on 2016-11-20 23:55
SHA: 9eff97205f6c5a66419b69a56ac8890c47632e70
Source: http://git.openstack.org/cgit/openstack/openstack-manuals/tree/doc/ha-guide/source/shared-database-manage.rst
URL: http://docs.openstack.org/ha-guide/shared-database-manage.html

[OpenStack Infra (hudson-openstack)]

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

[Adam Spiers (adam.spiers)]

No, I think this change to the /usr/libexec/mysqld is wrong for several reasons:

- There is no guarantee that mysqld lives in /usr/libexec on all systems
- There is no guarantee that the startup command is the same on all systems
- It is not OK to bypass systemd or any other init system, since they do a lot more than simply execute the start command (e.g. handling of dependencies and pid files)

Having said that, whilst the proposed fix is wrong, it is probably still correct to report that "systemctl start mariadb --wsrep-new-cluster" fails. So we should not simply close this bug. But it would have been more helpful if the bug report gave the exact error. I expect the problem is that systemctl tries to handle the --wsrep-new-cluster option which should not be there, but I don't have a system to test on right now, so I can't be sure.

Another related question is whether all Linux distributions commonly used for OpenStack now use systemd. I think they do, but I'm not sure. This would determine whether it's OK to use systemctl in OpenStack documentation or whether something more generic like service(8) should be used.

[KATO Tomoyuki (kato-tomoyuki)]

Should be: # service mysql start --wsrep-new-cluster

[OpenStack Infra (hudson-openstack)]

Change abandoned by chen.xing (<email address hidden>) on branch: master
Review: https://review.openstack.org/404851

[Alexandra Settle (alexandra-settle)]

Chen - are you able to update a new patch with the above information?

[Chason Chan (chen-xing)]

Yes, I find this page https://mariadb.com/kb/en/mariadb/getting-started-with-mariadb-galera-cluster/#_note-0
It works in my side.

[OpenStack Infra (hudson-openstack)]

Change abandoned by Alexandra Settle (<email address hidden>) on branch: master
Review: https://review.openstack.org/404851
Reason: Abandoning due to inactivity and indecision. All discussion for this change should happen in the bug report.

[Frank Kloeker (f-kloeker)]

the doc page don't exists anymore and ha guide is out of openstack-manuals. please refer https://storyboard.openstack.org/#!/project/openstack/ha-guide for new bugs