File: //usr/share/lwdbadmin/mysql/mysql.yaml
application-name: shared-mysql
provides: shared-mysql
sla-metric: 99.6
monitoring:
- service: tcp_port_3306
interval: 1
attempts: 2
port: 3306
check: active
item: tcp
sla: true
sla-group: shared-mysql
priority: 2
- service: MySQL_Check
doc: Check if MySQL is responding internally
check: local
item: mysql
host: {serviceip}
port: 3306
# number of connections thresholds
thresholds: "{{'warning': 80, 'critical': 100}}"
sla: true
sla-group: shared-mysql
priority: 2
- service: MyBackup_Check
doc: Check mysql backup
check: local
item: mybackup
host: {serviceip}
port: 3306
# Until this hour, do not check backup
gracetime: 9
sla: false
sla-group: shared-mysql
- service: MySQL_Check_Password
doc: Check if user whitout password
check: local
item: mysql_check_password
host: {serviceip}
port: 3306
sla: false
- service: MySQL_Check_Installation
doc: Count databases
check: local
item: mysql_check_installation
host: {serviceip}
port: 3306
warning: 1500
critical: 1700
# space separated databases
ignore: mysql teste administration_schema performance_schema information_schema sys
sla: false
sla-group: shared-mysql
priority: 3
- service: tcp_port_80
interval: 1
attempts: 2
port: 80
check: active
item: tcp
sla: false
doc: Apache for provisioning