Google CloudSQL
Rapport de recherche Datadog : Bilan sur l'adoption de l'informatique sans serveur Rapport : Bilan sur l'adoption de l'informatique sans serveur

Google CloudSQL

Crawler Crawler

Présentation

Google Cloud SQL est un service de base de données entièrement géré qui vous permet de configurer, maintenir, gérer et administrer facilement vos bases de données MySQL dans le cloud.

Recueillez des métriques de Google Cloud SQL pour :

  • Visualiser les performances de vos bases de données CloudSQL
  • Corréler les performances de vos bases de données CloudSQL avec vos applications

Implémentation

Installation

Collecte de métriques

Si vous ne l’avez pas déjà fait, configurez d’abord l’intégration Google Cloud Platform. Aucune autre procédure d’installation n’est requise.

Configuration

Pour recueillir des étiquettes CloudSQL personnalisées sous forme de tags, activez l’autorisation Cloud Asset Inventory.

Collecte de logs

Les logs Google Cloud SQL sont recueillis avec Stackdriver et envoyés à un Cloud Pub/Sub via un redirecteur Push HTTP. Si vous ne l’avez pas déjà fait, configurez le Cloud Pub/Sub à l’aide d’un redirecteur Push HTTP.

Une fois cette opération effectuée, exportez vos logs Google Cloud SQL depuis Stackdriver vers le Pub/Sub :

  1. Accédez à la page Stackdriver et filtrez les logs Google Cloud SQL.
  2. Cliquez sur Create Sink et nommez le récepteur.
  3. Choisissez Cloud Pub/Sub comme destination et sélectionnez le Pub/Sub créé à cette fin. Remarque : le Pub/Sub peut se situer dans un autre projet.

  4. Cliquez sur Create et attendez que le message de confirmation s’affiche.

Données collectées

Métriques

gcp.cloudsql.database.auto_failover_request_count
(count)
Delta of number of instance auto-failover requests.
Shown as request
gcp.cloudsql.database.available_for_failover
(gauge)
This is > 0 if the failover operation is available on the instance.
gcp.cloudsql.database.cpu.reserved_cores
(gauge)
Number of cores reserved for the database.
Shown as core
gcp.cloudsql.database.cpu.usage_time
(gauge)
Cumulative CPU usage time
Shown as second
gcp.cloudsql.database.cpu.utilization
(gauge)
Fraction of the reserved CPU that is currently in use.
Shown as fraction
gcp.cloudsql.database.disk.bytes_used
(gauge)
Disk space used.
Shown as byte
gcp.cloudsql.database.disk.quota
(gauge)
Maximum data disk size in bytes.
Shown as byte
gcp.cloudsql.database.disk.read_ops_count
(count)
Disk read IO operations.
Shown as operation
gcp.cloudsql.database.disk.utilization
(gauge)
The fraction of the disk quota that is currently in use.
Shown as fraction
gcp.cloudsql.database.disk.write_ops_count
(count)
Disk write IO operations.
Shown as operation
gcp.cloudsql.database.memory.quota
(gauge)
Maximum RAM in bytes
Shown as byte
gcp.cloudsql.database.memory.usage
(gauge)
RAM usage in bytes
Shown as byte
gcp.cloudsql.database.memory.utilization
(gauge)
Fraction of memory quota currently in use
Shown as fraction
gcp.cloudsql.database.mysql.innodb_buffer_pool_pages_dirty
(gauge)
Number of unflushed pages in the InnoDB buffer pool.
Shown as page
gcp.cloudsql.database.mysql.innodb_buffer_pool_pages_free
(gauge)
Number of unused pages in the InnoDB buffer pool.
Shown as page
gcp.cloudsql.database.mysql.innodb_buffer_pool_pages_total
(gauge)
Total number of pages in the InnoDB buffer pool.
Shown as page
gcp.cloudsql.database.mysql.innodb_data_fsyncs
(count)
InnoDB fsync calls.
Shown as operation
gcp.cloudsql.database.mysql.innodb_os_log_fsyncs
(count)
InnoDB fsync calls to the log file.
Shown as operation
gcp.cloudsql.database.mysql.innodb_pages_read
(count)
InnoDB pages read.
Shown as page
gcp.cloudsql.database.mysql.innodb_pages_written
(count)
InnoDB pages written.
Shown as page
gcp.cloudsql.database.mysql.queries
(count)
Number of query statements executed by the server.
Shown as query
gcp.cloudsql.database.mysql.questions
(count)
Number of question statements executed by the server. Includes only statements sent to the server by clients and not statements executed within stored programs
Shown as question
gcp.cloudsql.database.mysql.received_bytes_count
(count)
Delta count of bytes received by MySQL process.
Shown as byte
gcp.cloudsql.database.mysql.replication.available_for_failover
(gauge)
(Deprecated) This is > 0 if the failover operation is available on the master instance.master.
gcp.cloudsql.database.mysql.replication.seconds_behind_master
(gauge)
Approximate number of seconds the read replica is behind its' master.
Shown as second
gcp.cloudsql.database.mysql.replication.slave_io_running
(gauge)
Indicates whether the I/O thread for reading the master's binary log is running. Possible values are Yes, No, and Connecting.
gcp.cloudsql.database.mysql.replication.slave_sql_running
(gauge)
Indicates whether the SQL thread for executing events in the relay log is running
gcp.cloudsql.database.mysql.sent_bytes_count
(count)
Delta count of bytes sent by MySQL process.
Shown as byte
gcp.cloudsql.database.network.connections
(gauge)
Number of connections to the Cloud SQL instance.
Shown as connection
gcp.cloudsql.database.network.received_bytes_count
(count)
Delta count of bytes received through the network.
Shown as byte
gcp.cloudsql.database.network.sent_bytes_count
(count)
Number of bytes sent through the network.
Shown as byte
gcp.cloudsql.database.postgresql.num_backends
(gauge)
Number of connections to the Cloud SQL PostgreSQL instance.
Shown as connection
gcp.cloudsql.database.postgresql.transaction_count
(count)
Delta count of number of transactions.
Shown as transaction
gcp.cloudsql.database.up
(gauge)
Indicates if the server is up or not.
gcp.cloudsql.database.uptime
(gauge)
Number of seconds the instance has been running.
Shown as second

Événements

L’intégration Google Cloud SQL n’inclut aucun événement.

Checks de service

gcp.cloudsql.database.state L’état de service actuel de l’instance Cloud SQL.

Dépannage

Besoin d’aide ? Contactez l’assistance Datadog.