Google Cloud Platform MySQL Monitoring

Host Template: Cloud - GCP - MySQL

Monitor your GCP Cloud MySQL resources, with Service Checks including CPU, Disk and Memory Usage, Network Bytes, Connections, Queries and Sent and Received Bytes.

This Host Template includes the following Service Checks:

Service Check Name	Description	Default Thresholds (Warning, Critical)	UOM
GCP - MySQL - Network Bytes	Network received and sent bytes for the MySQL instance.	N/A	B
GCP - MySQL - Disk Operations	Disk read and write operations for the MySQL instance.	N/A	N/A
GCP - MySQL - Database Availability	Database uptime percentage over the period checked for the MySQL instance.	availability=100:,80:	%
GCP - MySQL - Status	Current serving state of the MySQL instance.	N/A	N/A
GCP - MySQL - Memory Usage	Memory used by the MySQL instance.	memory_usage=70,90	%
GCP - MySQL - Disk Usage	Disk used by the MySQL instance.	disk_usage=70,90	%
GCP - MySQL - CPU Usage	CPU used by the MySQL instance.	cpu_usage=70,90	%
GCP - MySQL - Queries	Number of received and executed MySQL queries on the MySQL instance.	N/A	N/A
GCP - MySQL - Bytes	Number of bytes received and sent by the MySQL instance.	N/A	B
GCP - MySQL - Network Connections	Number of network connections to the MySQL instance.	N/A	N/A

Usage Instructions

The SQL API Library must be enabled to use this host template. To do this, log into your SQL Admin API Library at Google Console - APIs, and click the Enable button. It may take some time until the API is fully active.

Step 1: Add this Host Template

Add the Cloud - GCP - MySQL Host Template to your Opsview Monitor host. If the resource you're monitoring has no hostname or public IP, then open the Advanced settings pane and change Host Check Command to Always assumed to be UP.

For more information, refer to Opsview Knowledge Center - Adding Host Templates to Hosts.

Step 2: Add and configure variables required for this Host Template

The Service Checks in this Host Template use the following variables, and they will be added to your Opsview Monitor instance when you import the Opspack:

GCP_PROJECT_ID

Parameter	Position in Variable	Name	Description
--project-id	Arg1	Monitored Project ID	ID of the project to monitor

GCP_MYSQL_DATABASE_ID

Parameter	Position in Variable	Name	Description
--mysql-database-id	Arg1	MySQL Database ID	ID of the MySQL database

GCP_CREDENTIALS_FILE

This argument is optional, to be used if you have a credentials file in a custom location. We recommend not setting it, and relying on the default location as follows: Create your credentials.json file and run as opsview user /opt/opsview/orchestrator/bin/orchestratorimportscripts etc-plugins cloud-gcp /path/to/credentials.json followed by an Apply Changes to set it up with the correct permissions in the default location (/opt/opsview/monitoringscripts/etc/plugins/cloud-gcp/credentials.json) on all Opsview collectors.

For more information on the credentials file, refer to Create access credentials

Parameter	Position in Variable	Name	Description
--credentials-file	Arg1	Credentials File	Path of the JSON file with GCP Service Account Credentials

For more information, refer to Opsview Knowledge Center - Adding Variables to Hosts.

For mode-specific help, run the plugin with the -h -m <mode> flags. This will list the required and optional Variable Arguments for that mode. The appropriate mode for each Service Check is listed here:

Service Check Name	Mode
GCP - MySQL - Network Bytes	`GCP.MySQL.Net.Bytes`
GCP - MySQL - Disk Operations	`GCP.MySQL.Disk.Ops`
GCP - MySQL - Database Availability	`GCP.MySQL.Availability`
GCP - MySQL - Status	`GCP.MySQL.Status`
GCP - MySQL - Memory Usage	`GCP.MySQL.Mem.Usage`
GCP - MySQL - Disk Usage	`GCP.MySQL.Disk.Usage`
GCP - MySQL - CPU Usage	`GCP.MySQL.CPU.Usage`
GCP - MySQL - Queries	`GCP.MySQL.Queries`
GCP - MySQL - Bytes	`GCP.MySQL.Bytes`
GCP - MySQL - Network Connections	`GCP.MySQL.Net.Connections`