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.
External reference
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:
- Log in to the Google Cloud.
- In the Google Cloud console, go to the Cloud SQL page.
- To open the Overview page of an instance, click the instance name.
- Select Connections from the SQL navigation menu.
- Select the Public IP checkbox.
- Click Add network.
- In the Network field, enter the IP address or address range you want to allow connections from.
- Click Done.
- 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.
- Log in to the OpsRamp portal.
- Go to Infrastructure > Resources > Google Cloud.
- Select Cloud SQL Database.
- From the Cloud SQL database details page, select a resource.
- In the resource details page, click settings.
- From the settings drop-down, click Assign Gateway Profile.
- Select a management profile from the drop-down menu.
- Click Assign.
- Select Credentials from the left hand navigation pane and click Add.
- Enter the below mentioned credential information:
| Field | Description |
|---|---|
| Name | Name for new credential. |
| Description | Add a description of the credential. |
| Type | Select as Database. |
| Username | Enter the username of the resource created in Google Cloud. |
| Password | Enter the password of the resource created in Google Cloud. |
| Confirm Password | Enter the password again. |
| Port | Port should be 1433. |
| Connection Time out (ms) | Specify the timeout duration. |
- Click Save.
- Select Monitors from the left hand navigation pane and click Assign Templates.
- In the Apply Templates page, select Collector Type as Gateway.
- Under Assign Templates, search for MSSQL templates and assign required templates.
- Select Metrics from the left hand navigation pane and you can see the monitoring data.
