Introduction
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 Metric | Metric Display Name | Unit | Aggregation Type | Description |
|---|---|---|---|---|
| google_cloudsql_database_up | Server up | Count | Average | 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. |
| google_cloudsql_database_uptime | Uptime | Seconds | Average | Delta count of the time in seconds the instance has been running. |
| google_cloudsql_database_network_connections | Connections | Count | Average | Number of connections to the Cloud SQL instance. |
| google_cloudsql_database_network_sent_bytes_count | Sent bytes | Bytes | Average | Delta count of bytes sent through the network. |
| google_cloudsql_database_disk_bytes_used | Bytes used | Bytes | Average | Data utilization in bytes. |
| google_cloudsql_database_disk_write_ops_count | Write operations | Count | Average | Delta count of disk write IO operations. |
| google_cloudsql_database_mysql_innodb_data_fsyncs | InnoDB fsync calls | Count | Average | Delta count of InnoDB fsync() calls. |
| google_cloudsql_database_mysql_innodb_os_log_fsyncs | InnoDB log fsync calls | Count | Average | Delta count of InnoDB fsync() calls to the log file. |
| google_cloudsql_database_mysql_innodb_pages_read | InnoDB pages read | Count | Average | Delta count of InnoDB pages read. |
| google_cloudsql_database_mysql_innodb_pages_written | InnoDB pages written | Count | Average | Delta count of InnoDB pages written. |
| google_cloudsql_database_mysql_queries | Queries | Count | Average | Delta count of statements executed by the server. |
| google_cloudsql_database_mysql_questions | Questions | Count | Average | Delta count of statements executed by the server sent by the client. |
| google_cloudsql_database_cpu_reserved_cores | Cpu Reserved Cores | Count | Average | Number of cores reserved for the database. |
| google_cloudsql_database_cpu_usage_time | Cpu Usage Time | Count | Average | Cumulative CPU usage time in seconds. |
| google_cloudsql_database_cpu_utilization | Cpu Utilization | Count | Average | The fraction of the reserved CPU that is currently in use. |
| google_cloudsql_database_disk_quota | Disk Quota | Count | Average | Maximum data disk size in bytes. |
| google_cloudsql_database_auto_failover_request_count | Auto Failover Request Count | Count | Average | Delta of number of instance auto-failover requests. |
| google_cloudsql_database_available_for_failover | Available Failover | Count | Average | Delta of number of instance auto-failover requests. |
| google_cloudsql_database_disk_read_ops_count | Disk Read Ops Count | Count | Average | Delta count of data disk read IO operations. |
| google_cloudsql_database_disk_utilization | Disk Utilization | Count | Average | The fraction of the disk quota that is currently in use. |
| google_cloudsql_database_memory_quota | Memory Quota | Bytes | Maximum | Maximum RAM size in bytes. |
| google_cloudsql_database_memory_usage | Memory Usage | Bytes | Average | RAM usage in bytes. Sampled every 60 seconds. |
| google_cloudsql_database_memory_utilization | Memory Utilization | Count | Average | The fraction of the memory quota that is currently in use. |
| google_cloudsql_database_mysql_received_bytes_count | Mysql Received Bytes Count | Count | Average | Delta count of bytes received by MySQL process. |
| google_cloudsql_database_mysql_sent_bytes_count | Mysql Sent Bytes Count | Count | Average | Delta count of bytes sent by MySQL process. |
| google_cloudsql_database_postgresql_num_backends | Postgresql Num Backends | Count | Average | Number of connections to the Cloud SQL PostgreSQL instance. Sampled every 60 seconds. |
| google_cloudsql_database_postgresql_transaction_count | Postgresql Transaction Count | Count | Average | Delta count of number of transactions. Sampled every 60 seconds. |
| google_cloudsql_database_state | State | Count | Average | The current serving state of the Cloud SQL instance. |
| google_cloudsql_database_mysql_innodb_buffer_pool_pages_dirty | Mysql Innodb Buffer Pool Pages Dirty | Count | Average | Number of unflushed pages in the InnoDB buffer pool. |
| google_cloudsql_database_mysql_innodb_buffer_pool_pages_free | Mysql Innodb Buffer Pool Pages Free | Count | Average | Number of unused pages in the InnoDB buffer pool. |
| google_cloudsql_database_mysql_innodb_buffer_pool_pages_total | Mysql Innodb Buffer Pool Pages Total | Count | Average | Total number of pages in the InnoDB buffer pool. |
| google_cloudsql_database_mysql_replication_seconds_behind_master | Mysql Replication Seconds Behind Master | Count | Average | Number of seconds the read replica is behind its master. |
| google_cloudsql_database_mysql_replication_slave_io_running | Mysql Replication Slave IO Running | Count | Average | Indicates whether the I/O thread for reading the masters binary log is running. |
| google_cloudsql_database_mysql_replication_slave_sql_running | Mysql Replication Slave SQL Running | Count | Average | Indicates whether the SQL thread for executing events in the relay log is running. |
| google_cloudsql_database_network_received_bytes_count | Network Received bytes Count | Bytes | Average | Delta count of bytes received through the network. |
| google_cloudsql_database_postgresql_replication_replica_byte_lag | Postgresql Replication Replica byte Lag | Bytes | Average | Delta count of bytes received through the network. |
Event support
- Supported
- Configurable in OpsRamp Google Integration Discovery Profile.