Management in High Availability Guide (under Configuration tips->Deployment Strategies -> Configuring HaProxy)

[codbla]

Hi,

It seems there is lacking information on this section, regarding with as per mentioned "you can use the clustercheck utility to improve health checks" but seems you can't using this guides.
I am using CentOS 7.3.

As per solution:
You need to download the clustercheck in https://github.com/olafz/percona-clustercheck
and save it to /usr/bin/ then change the permission to 755.

cd /usr/bin/
wget https://raw.githubusercontent.com/olafz/percona-clustercheck/master/clustercheck
chmod 755 clustercheck

modify the
MYSQL_USERNAME="${1-clustercheckuser}"
MYSQL_PASSWORD="${2-clustercheckpassword!}"

to as per reference to step1:
MYSQL_USERNAME="${1-clustercheck_user}"
MYSQL_PASSWORD="${2-my_clustercheck_password}"

Under Step 2:
   user = root
   group = root
   groups = yes

can be
   user = nobody

For Step 3:
You need to modify the service to match with the service name of step 2, search 9200
vi /etc/services
#wap-wsp 9200/tcp # WAP connectionless session service
#wap-wsp 9200/udp # WAP connectionless session service
galera-monitor 9200/tcp # Galera Cluster Monitoring Check

before you can run the current steps provided.
systemctl daemon-reload
systemctl enable xinetd
systemctl start xinetd

You can now check using by using..
/usr/bin/clustercheck
(output)
HTTP/1.1 200 OK
Content-Type: text/plain
Connection: close
Content-Length: 40

Percona XtraDB Cluster Node is synced.

if you stop the cluster (systemctl stop mariadb) for example
/usr/bin/clustercheck
(output)
HTTP/1.1 503 Service Unavailable
Content-Type: text/plain
Connection: close
Content-Length: 44

Percona XtraDB Cluster Node is not synced.

Note: Disregard "Percona XtraDB" which can be modified, pls do alter in clustercheck.

I don't know if my solution is right or the current manual (based on this section) doesn't work on mine.

By the way the reference:
https://mariadb.com/resources/blog/setup-mariadb-enterprise-cluster-part-3-setup-ha-proxy-load-balancer-read-and-write-pools

Regards,
Mario

This bug tracker is for errors with the documentation, use the following as a template and remove or add fields as you see fit. Convert [ ] into [x] to check boxes:

- [X] This doc is inaccurate in this way: ______
- [ ] This is a doc addition request.
- [X] I have a fix to the document that I can paste below including example: input and output.

If you have a troubleshooting or support issue, use the following resources:

 - Ask OpenStack: http://ask.openstack.org
 - The mailing list: http://lists.openstack.org
 - IRC: 'openstack' channel on Freenode

-----------------------------------
Release: 15.0.0 on 2017-05-31 14:00
SHA: 6596db50bfdd11b6fd835488ba13c92e836d7208
Source: https://git.openstack.org/cgit/openstack/openstack-manuals/tree/doc/ha-guide/source/shared-database-manage.rst
URL: https://docs.openstack.org/ha-guide/shared-database-manage.html

[Adam Spiers (adam.spiers)]

Hi @tersian, thanks for the triage. Unfortunately I've never touched MySQL / Percona in an OpenStack context (we use PostgreSQL here), so there's no easy way I can help with this one :-( Andrew, can you help?

[Frank Kloeker (f-kloeker)]

couldn't found the page in the current version. It seems there are now common references: https://docs.openstack.org/ha-guide/control-plane-stateful.html#database-for-high-availability
The ha-guide isn't part of openstack-manuals anymore. Feel free to open a new bug on https://storyboard.openstack.org/#!/project/openstack/ha-guide