Commit Graph

8 Commits

Author SHA1 Message Date
Robert Gildein 11ee1ef563 NRPE: Monitor threads connected to MySQL.
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
2020-11-27 14:50:02 +00:00
David Ames b73f5c4880 Mysqldump Action
Add the mysqldump and set-pxc-strict-mode actions to allow for dumping
databases in text form.

Change-Id: Ibb9c5e17d01c7bb1335d8a7c9087216af8d00b09
2020-02-28 22:57:19 +00:00
David Ames b8c2213dfb Notify bootstrapped action
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
2019-07-17 07:58:15 -07:00
David Ames b97a0971c2 Bootstrap action after a cold boot
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
2019-07-10 14:51:25 -07:00
David Ames fe131a0aa6 Series Upgrade
Implement the series-upgrade feature allowing to move between Ubuntu
series.

Change-Id: If38bf1767c8e0c9242071140535b44e12c9f9759
2018-09-17 15:38:00 +02:00
Jill Rouleau 2bc5d6e2f9 Add backup action
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
2016-03-04 10:13:53 +00:00
Geoffrey J. Teale 444c891d9b Refer to the MySQL service rather than the Percona service. 2015-08-06 15:45:33 +02:00
Geoffrey J. Teale 1074ceab47 Add acton definition yaml. 2015-08-03 15:22:30 +02:00