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