Book Image

MariaDB High Performance

By : Pierre Mavro
Book Image

MariaDB High Performance

By: Pierre Mavro

Overview of this book

Table of Contents (18 chapters)
MariaDB High Performance
About the Author
About the Reviewers

Galera Cluster

On Galera, you know that there are a lot of options and things to check to ensure that the nodes are working fine.

Percona made a script for Nagios to manage all essentials parameters and to ensure that Galera Cluster is working fine. In fact, it was able to parse the result of the Galera SHOW STATUS LIKE 'wsrep_%' and look at if it finds a matched string or not.

To install the script, you need to have the Percona repository set correctly and then you can install the package:

> apt-key adv --keyserver --recv-keys 1C4CBDCDCD2EFD2A
> add-apt-repository 'deb wheezy main'
> echo 'Package: *
Pin: release o=Percona Development Team
Pin-Priority: 100' > /etc/apt/preferences.d/00percona.pref
> aptitude update
> aptitude install percona-nagios-plugins

The plugins will be installed under /usr/lib64/nagios/plugins.

First of all, what you generally want to do is to check the cluster size, to be sure all your nodes are here. Let...