Google Cloud SQL monitoring integration

Site24x7 helps ensure the availability and performance of your cloud databases hosted in Google Cloud SQL by providing real-time insights into key metrics such as memory utilization and query performance. Site24x7 Google Cloud SQL monitor allows you to proactively detect and address issues, minimizing downtime and optimizing the overall database performance. Additionally, it also enhances reliability, performance, scalability, and security of your database infrastructure.

Setup and configuration
Polling frequency
Supported metrics
Threshold configuration
IT Automation
Configuration Rules
Summary
Configuration Details
Reports

Setup and configuration

Adding Google Cloud SQL while configuring a new Google Cloud monitor

If you have not configured a Google Cloud monitor yet, add one by following the steps below:
1. Log in to your Site24x7 account.
2. Go to Cloud > GCP > Add GCP Monitor or Admin > Cloud Monitoring > Google Cloud Platform(GCP).
3. Provide a unique display name for identification purposes.
4. Upload the JSON file that contains the private key of the service account to authenticate Site24x7 for performing resource discovery.
5. Select Cloud SQL from the Select the Resources for Monitoring list.
6. Select existing Notification Profiles, User Alerts Groups, Tags, and IT Automation Templates or add new ones. You can also integrate Site24x7's alarms with your preferred third-party service.
7. Click Start GCP Monitoring.
Adding Google Cloud SQL to an existing Google Cloud monitor

If you already have a Google Cloud monitor configured for the service account, you can add Google Cloud SQL by following the steps below:
1. Log in to your Site24x7 account.
2. Go to Cloud > GCP and select your GCP monitor.
3. Click the hamburger icon next to Service View and select Edit, which brings you to the Edit GCP Monitor page.
4. On the Edit GCP Monitor page, select Cloud SQL from the Select the Resources for Monitoring list and click Save.
5. After successful configuration, go to Cloud > GCP > Cloud SQL. Now you can view the discovered Google Cloud SQL resources.

It will take approximately five minutes to discover new GCP resources.

Polling frequency

Site24x7's Google Cloud SQL monitor collects minute-wise metric data, and the statuses of your Google Cloud SQL are reported every five minutes.

Supported metrics

Metric name	Description	Statistic	Unit
Memory Utilization	The amount of the memory quota currently in use	Average	Bytes
Network Bytes Received By MySQL	The size of data received by MySQL process	Average	Bytes
Network Bytes Sent By MySQL	The size of data sent by MySQL process	Average	Bytes
Auto-failover Requests	The total number of instance auto-failover requests	Total	Count
Bytes Used	Data utilized by Cloud SQL service	Average	Bytes
CPU Reserved Cores	The total number of cores reserved for database	Total	Count
CPU Utilization	CPU utilization by the databases	Average	Percentage
CPU Usage	The amount of time the CPU was utilized by the databases	Average	Seconds
Disk Quota	The maximum size of disk allocated for the databases	Maximum	Bytes
Disk Read IO	The average count of disk input output read operations performed	Average	Count
Disk Utilization	The amount of disk space used by the databases	Total	Bytes
InnoDB Dirty Pages	The total number of unflushed pages in the InnoDB buffer pool	Total	Count
InnoDB Free Pages	The total number of unused pages in the InnoDB buffer pool	Total	Count
InnoDB Fsync Calls	The total number of InnoDB fsync calls	Total	Count
InnoDB Log Fsync Calls	The total number of InnoDB fsync calls to the log file	Total	Count
InnoDB Pages Read	The total number of InnoDB pages read	Total	Count
InnoDB Pages Written	The total number of InnoDB pages written	Total	Count
InnoDB Total Pages	The total number of InnoDB pages	Total	Count
Memory Quota	The maximum RAM size of the database instance	Maximum	Bytes
Memory Usage	The average RAM usage by the database instance	Average	Bytes
MySQL InnoDB Dictionary Cache	The total memory allocated for InnoDB dictionary cache	Total	Bytes
InnoDB Dirty Pages	The total number of unflushed pages in the InnoDB buffer pool	Total	Count
MySQL Open Table Definitions	The total number of table definitions that are actively cached at the time of data collection	Total	Count
MySQL Open Tables	The total number of MySQL tables that are open at the time of data collection	Total	Count
MySQL Opened Table Count	The total number of tables that have been opened after the last data collection	Total	Count
MySQL Opened Table Definitions Count	The total number of definitions that are cached	Total	Count
Last I/O Thread Error Number	The error number of the latest error that resulted in stoppage of the input output (I/O) thread	Text	Text
Last SQL Thread Error Number	The error number of the latest error that resulted in stoppage of the SQL thread	Text	Text
Slave SQL Thread Running State	The status of the SQL thread for executing events in the relay log	Boolean	1- running 0 - stopped

Threshold configuration

Global configuration
1. In the Site24x7 web client, go to the Admin section on the left navigation pane.
2. Select Configuration Profiles from the left pane and select Threshold and Availability from the drop-down menu.
3. Click Add Threshold Profile in the top-right corner.
4. For Monitor Type, select Cloud SQL.
5. Now you can set the threshold values for the metrics listed above.
Monitor-level configuration
1. In the Site24x7 web client, go to Cloud > GCP > Cloud SQL.
2. Select a resource you would like to set a threshold for, then click the hamburger icon.
3. Select Edit, which directs you to the Edit Cloud SQL Monitor page.
4. You can set the threshold values for the metrics with the Threshold and Availability option.
5. You can also configure IT Automation at the attribute level.

IT Automation

Site24x7 offers a set of exclusive IT Automation tools that automatically resolve performance degradation issues. These tools react to events proactively rather than waiting for manual intervention. The IT Automation tools automate repetitive tasks and automatically remediate threshold breaches. The alarm engine continually evaluates system events for which thresholds are set and executes the mapped automation when there is a breach.

How to configure IT Automation for a monitor

Configuration Rules

Editing multiple monitors to associate different monitor groups or add a different tag can be a tedious process. With Site24x7's Configuration Rules, you can automate the configuration settings of your monitoring resources. Also, Site24x7 allows you to create custom rules to track configuration changes continuously and achieve the ideal configuration settings.

How to add Configuration Rules

Summary

The Summary tab will give you the performance data organized by time for the metrics listed above. To view the summary:

Go to Cloud > GCP > Cloud SQL.
Select a resource.
Click the Summary tab.

Configuration Details

The Configuration Details tab provides details on the configurations of application instances. To get the configuration details:

Go to Cloud > GCP > Cloud SQL.
Select a resource.
Click the Configuration Details tab.

Reports

Gain in-depth data about the various parameters of your monitored resources and accentuate your service performance using our insightful reports.

To view reports for a Google Cloud SQL resource:

Go to the Reports section on the left navigation pane.
Select Cloud SQL from the menu on the left.
You can find the Availability Summary Report, Performance Report, and Inventory Report for one selected monitor. Or you can get the Summary Report, Availability Summary Report, Health Trend Report, and Performance Report for all the Google Cloud SQL monitors.

You can also get reports from the Summary tab of the Google Cloud SQL monitor:

Click the Summary tab.
Get the Availability Summary Report of the monitor by clicking Availability.
You can also find the Performance Report of the monitor by clicking any chart title.