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 keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
> add-apt-repository 'deb http://repo.percona.com/apt wheezy main'
> echo 'Package: *
Pin: release o=Percona Development Team
Pin-Priority: 100' > /etc/apt/preferences.d/00percona.pref
> aptitude ...

Get MariaDB High Performance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.