Help Docs

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.

Table of contents

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 Hamburger icon 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 Hamburger icon 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:

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

Configuration Details

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

  1. Go to Cloud > GCP > Cloud SQL.
  2. Select a resource.
  3. 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:

  1. Go to the Reports section on the left navigation pane.
  2. Select Cloud SQL from the menu on the left.
  3. 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:

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

What's next for you:

Was this document helpful?

Shortlink has been copied!