11ee1ef563
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
72 lines
2.8 KiB
YAML
72 lines
2.8 KiB
YAML
pause:
|
|
description: Pause the MySQL service.
|
|
resume:
|
|
description: Resume the MySQL service.
|
|
backup:
|
|
description: Full database backup
|
|
params:
|
|
basedir:
|
|
type: string
|
|
default: "/opt/backups/mysql"
|
|
description: The base directory for backups
|
|
compress:
|
|
type: boolean
|
|
default: false
|
|
description: Whether or not to compress the backup
|
|
incremental:
|
|
type: boolean
|
|
default: false
|
|
description: Make an incremental database backup
|
|
complete-cluster-series-upgrade:
|
|
description: |
|
|
Perform final operations post series upgrade. Inform all nodes in the
|
|
cluster the upgrade is complete cluster wide. Update configuration with all
|
|
peers for wsrep replication.
|
|
This action should be performed on the current leader. Note the leader may
|
|
have changed during the series upgrade process.
|
|
bootstrap-pxc:
|
|
description: |
|
|
Bootstrap this unit of Percona.
|
|
*WARNING* This action will bootstrap this unit of Percona cluster. This
|
|
should only occur in a recovery scenario. Make sure this unit has the
|
|
highest sequence number in grastate.dat or data loss may occur.
|
|
See upstream Percona documentation for context
|
|
https://www.percona.com/blog/2014/09/01/galera-replication-how-to-recover-a-pxc-cluster/
|
|
notify-bootstrapped:
|
|
descripttion: Notify the cluster of the new bootstrap uuid.
|
|
set-pxc-strict-mode:
|
|
description: |
|
|
Set PXC strict mode.
|
|
params:
|
|
mode:
|
|
type: string
|
|
default: "ENFORCING"
|
|
description: |
|
|
PXC strict mode. Valid options are DISALBED, PERMISSIVE, ENFORCING or MASTER
|
|
See https://www.percona.com/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html
|
|
for more detail.
|
|
mysqldump:
|
|
description: |
|
|
MySQL dump of databases. Action will return mysqldump-file location of the
|
|
requested backup in the results. If the databases parameter is unset all
|
|
databases will be dumped. If the databases parameter is set only the
|
|
databases specified will be dumped. Note it may be necessary to use the
|
|
set-pxc-strict-mode action first to set either PERMISSIVE or MASTER to
|
|
allow locking of tables for mysqldump to complete successfully.
|
|
See https://www.percona.com/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html
|
|
for more detail.
|
|
params:
|
|
basedir:
|
|
type: string
|
|
default: "/var/backups/mysql"
|
|
description: The base directory for backups
|
|
databases:
|
|
description: |
|
|
Comma delimited database names to dump. If left unset, all databases
|
|
will be dumped.
|
|
generate-nagios-password:
|
|
description: |
|
|
Re-generate the password for the nagios user. This action can only be run on the leader unit,
|
|
which sets a new password and then the `leader-settings-changed` hook will be activate.
|
|
|