You are here

GCP - MySQL Monitoring

Requires Opsview Monitor 6.2

This Host Template is part of the Google Cloud Platform Opspack

check_circle
Opsview Supported

404: Not Found

Included in the Cloud - GCP Opspack

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:100,80:100 %
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.

GCP SQL API menu



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 - if you are only using one set of credentials, we recommend not setting it, and instead placing your credentials file in the default path /opt/opsview/monitoringscripts/etc/plugins/cloud-gcp/credentials.json. Ensure this file is readable by the opsview user.

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



Step 3: Apply changes and the system will now be monitored

View Output

v1.0-opsview-6

ODI-2965 Cloud-GCP Opspack

Initial release for Cloud-GCP Opspack