Add a NRPE check to monitor the number of threads connected
to the MySQL database, in proportion to the maximum number of connections.
For this check, a nagios user will be created. This user does not have any
permissions set, does not have access to any database and can only connect
from localhost.
Warning and Critical thresholds (in percentage) can be configured.
Add an action to reset nagios's password. This action could only be run
on the leader unit.
Closes-Bug: #1816759
Change-Id: Id35b0331322c2744a9f839b3eb153eed1bc53aac
It turns out a subsequent required step after a cold boot bootstrap is
notifying the cluster of the new bootstrap UUID.
The notify-bootstrapped action should be run on a different node than
the one which ran the bootstrap-pxc action.
This action will ensure the cluster converges on the correct bootstrap
UUID.
A subsequent patch stacked on this one will include tests for the new
cold boot actions.
Change-Id: Idee12d5f7e28498c5ab6ccb9605f751c6427ac30
Partial-Bug: #1744393
After a cold boot, percona-cluster will require administrative
intervention. One node will need to bootstrap per upstream
Percona Cluster documentation:
https://www.percona.com/blog/2014/09/01/galera-replication-how-to-recover-a-pxc-cluster/
This change adds an action to bootstrap a single node. On the other
nodes systemd will be attempting to start percona. Once the bootstrapped
node is up the others will join automatically.
Change-Id: Id9a860edc343ee5dbd7fc8c5ce3b4420ec6e134e
Partial-Bug: #1744393
Add a new action to backup the pxc database on a unit.
Backups by default are stored in /opt/backups/mysql and can
optionally be compressed and done as incremental backups.
Change-Id: I5c6ab9fd8be7cb6cdb2a26e849ec0b22d8d4f9a6