Cloud SQL is a fully managed database service that makes it easy to set up, maintain, manage, and administer relational PostgreSQL, MySQL, and SQL Server databases in the cloud.ass security.

Setup

To set up the Google integration and discover the Google service, go to Google Integration Discovery Profile and select Cloud SQL.

Supported metrics

OpsRamp MetricMetric Display NameUnitAggregation Type
google_cloudsql_database_up

Indicates if the server is up or not. On-demand instances are spun down if no connections are made for a sufficient amount of time.
Server upCountAverage
google_cloudsql_database_uptime

Delta count of the time in seconds the instanceran.
UptimeSecondsAverage
google_cloudsql_database_network_connections

Number of connections to the Cloud SQL instance.
ConnectionsCountAverage
google_cloudsql_database_network_sent_bytes_count

Delta count of bytes sent through the network.
Sent bytesBytesAverage
google_cloudsql_database_disk_bytes_used

Data utilization in bytes.
Bytes usedBytesAverage
google_cloudsql_database_disk_write_ops_count

Delta count of disk write IO operations.
Write operationsCountAverage
google_cloudsql_database_mysql_innodb_data_fsyncs

Delta count of InnoDB fsync() calls.
InnoDB fsync callsCountAverage
google_cloudsql_database_mysql_innodb_os_log_fsyncs

Delta count of InnoDB fsync() calls to the log file.
InnoDB log fsync callsCountAverage
google_cloudsql_database_mysql_innodb_pages_read

Delta count of InnoDB pages read.
InnoDB pages readCountAverage
google_cloudsql_database_mysql_innodb_pages_written

Delta count of InnoDB pages written.
InnoDB pages writtenCountAverage
google_cloudsql_database_mysql_queries

Delta count of statements executed by the server.
QueriesCountAverage
google_cloudsql_database_mysql_questions

Delta count of statements executed by the server sent by the client.
QuestionsCountAverage
google_cloudsql_database_cpu_reserved_cores

Number of cores reserved for the database.
Cpu Reserved CoresCountAverage
google_cloudsql_database_cpu_usage_time

Cumulative CPU usage time in seconds.
Cpu Usage TimeCountAverage
google_cloudsql_database_cpu_utilization

The fraction of the reserved CPU that is currently in use.
Cpu UtilizationCountAverage
google_cloudsql_database_disk_quota

Maximum data disk size in bytes.
Disk QuotaCountAverage
google_cloudsql_database_auto_failover_request_count

Delta of number of instance auto-failover requests.
Auto Failover Request CountCountAverage
google_cloudsql_database_available_for_failover

Delta of number of instance auto-failover requests.
Available FailoverCountAverage
google_cloudsql_database_disk_read_ops_count

Delta count of data disk read IO operations.
Disk Read Ops CountCountAverage
google_cloudsql_database_disk_utilization

The fraction of the disk quota that is currently in use.
Disk UtilizationCountAverage
google_cloudsql_database_memory_quota

Maximum RAM size in bytes.
Memory QuotaBytesMaximum
google_cloudsql_database_memory_usage

RAM usage in bytes. Sampled every 60 seconds.
Memory UsageBytesAverage
google_cloudsql_database_memory_utilization

The fraction of the memory quota that is currently in use.
Memory UtilizationCountAverage
google_cloudsql_database_mysql_received_bytes_count

Delta count of bytes received by MySQL process.
Mysql Received Bytes CountCountAverage
google_cloudsql_database_mysql_sent_bytes_count

Delta count of bytes sent by MySQL process.
Mysql Sent Bytes CountCountAverage
google_cloudsql_database_postgresql_num_backends

Number of connections to the Cloud SQL PostgreSQL instance. Sampled every 60 seconds.
Postgresql Num BackendsCountAverage
google_cloudsql_database_postgresql_transaction_count

Delta count of number of transactions. Sampled every 60 seconds.
Postgresql Transaction CountCountAverage
google_cloudsql_database_state

The current serving state of the Cloud SQL instance.
StateCountAverage
google_cloudsql_database_mysql_innodb_buffer_pool_pages_dirty

Number of unflushed pages in the InnoDB buffer pool.
Mysql Innodb Buffer Pool Pages DirtyCountAverage
google_cloudsql_database_mysql_innodb_buffer_pool_pages_free

Number of unused pages in the InnoDB buffer pool.
Mysql Innodb Buffer Pool Pages FreeCountAverage
google_cloudsql_database_mysql_innodb_buffer_pool_pages_total

Total number of pages in the InnoDB buffer pool.
Mysql Innodb Buffer Pool Pages TotalCountAverage
google_cloudsql_database_mysql_replication_seconds_behind_master

Number of seconds the read replica is behind its master.
Mysql Replication Seconds Behind MasterCountAverage
google_cloudsql_database_mysql_replication_slave_io_running

Indicates whether the I/O thread for reading the masters binary log is running.
Mysql Replication Slave IO RunningCountAverage
google_cloudsql_database_mysql_replication_slave_sql_running

Indicates whether the SQL thread for executing events in the relay log is running.
Mysql Replication Slave SQL RunningCountAverage
google_cloudsql_database_network_received_bytes_count

Delta count of bytes received through the network.
Network Received bytes CountBytesAverage
google_cloudsql_database_postgresql_replication_replica_byte_lag

Delta count of bytes received through the network.
Postgresql Replication Replica byte LagBytesAverage

Event support

  • Supported
  • Configurable in OpsRamp Google Integration Discovery Profile.

External reference

Google Cloud SQL

MSSQL Advance Monitoring - Google Cloud

OpsRamp now supports the MSSQL Advance database monitoring for Google using the Gateway Collector.

Whitelisting Gateway IP in Google Cloud

In order to perform advance monitoring for Google cloud resources, we need to whitelist the IP of the host of the Gateway machine.

To whitelist the IP:

  1. Log in to the Google Cloud.
  2. In the Google Cloud console, go to the Cloud SQL page.
  3. To open the Overview page of an instance, click the instance name.
  4. Select Connections from the SQL navigation menu.
  5. Select the Public IP checkbox.
  6. Click Add network.
  7. In the Network field, enter the IP address or address range you want to allow connections from.
  8. Click Done.
  9. Click Save to update the instance.

Advance Monitoring configuration

Once you whitelist the gateway in Google Cloud, you can now configure for advance monitoring in OpsRamp portal.

  1. Log in to the OpsRamp portal.
  2. Go to Infrastructure > Resources > Google Cloud.
  3. Select Cloud SQL Database.
  4. From the Cloud SQL database details page, select a resource.
  5. In the resource details page, click settings.
  6. From the settings drop-down, click Assign Gateway Profile.
  7. Select a management profile from the drop-down menu.
  8. Click Assign.
  9. Select Credentials from the left hand navigation pane and click Add.
  10. Enter the below mentioned credential information:
FieldDescription
NameName for new credential.
DescriptionAdd a description of the credential.
TypeSelect as Database.
UsernameEnter the username of the resource created in Google Cloud.
PasswordEnter the password of the resource created in Google Cloud.
Confirm PasswordEnter the password again.
PortPort should be 1433.
Connection Time out (ms)Specify the timeout duration.
  1. Click Save.
  2. Select Monitors from the left hand navigation pane and click Assign Templates.
  3. In the Apply Templates page, select Collector Type as Gateway.
  4. Under Assign Templates, search for MSSQL templates and assign required templates.
  5. Select Metrics from the left hand navigation pane and you can see the monitoring data.