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

Cloud SQL offers high performance, high availability, scalability, and convenience. Built on future-proof infrastructure that has Google’s private global network and world-class security, Cloud SQL takes care of the mundane tasks of managing databases so that you can focus on building great applications.

Setup

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

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 instance has been running.
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