Configuration in High Availability Guide

[Stephan Schultchen]

in the mysql/galera section:

is:
SHOW VARIABLES LIKE 'wsrep_%';

should be:
SHOW status LIKE 'wsrep_%';

to have the pretty output printed

-----------------------------------
Release: 0.0.1 on 2016-12-12 10:43
SHA: dc1bb79dac7d50dfd5f3ba8c9ef32d04356f6677
Source: http://git.openstack.org/cgit/openstack/openstack-manuals/tree/doc/ha-guide/source/shared-database-configure.rst
URL: http://docs.openstack.org/ha-guide/shared-database-configure.html

[Damien Ciabrini (dciabrin)]

Note that "SHOW status ..." is incorrect because it only returns the information related to the _current state_ of the cluster, like "is the local node in sync, how may nodes are connected to the cluster"...

The documentation show how to get information about the _available_ galera configuration flags. In that regard, the "SHOW VARIABLES " command is what we want.

the output seem to be "ugly" because of the value of variable "wsrep_provider_options", which is usually way bigger than the terminal's width. If you want to have a "cleaner" output, you should configure your pager accordingly, e.g.:

mysql -te "show variables like 'wsrep_%';" | less -S

[Alexandra Settle (alexandra-settle)]

Marking as Won't Fix - post Damien's comments.

Thank you :)