Integrate Datadog with Tiger Cloud

Datadog is a cloud-based monitoring and analytics platform that provides comprehensive visibility into applications, infrastructure, and systems through real-time monitoring, logging, and analytics.

This page explains how to:

• Monitor Tiger Cloud service metrics with Datadog

  This integration is available for Scale and Enterprise pricing plans.

• Configure Datadog Agent to collect metrics for your Tiger Cloud service

  This integration is available for all pricing plans.

To follow the steps on this page:

• Create a target Tiger Cloud service with time-series and analytics enabled.

  You need your connection details.

• Sign up for Datadog.

  You need your Datadog API key to follow this procedure.

• Install Datadog Agent.

Export telemetry data from your Tiger Cloud services with the time-series and analytics capability enabled to Datadog using a Tiger Cloud data exporter. The available metrics include CPU usage, RAM usage, and storage.

A Tiger Cloud data exporter sends telemetry data from a Tiger Cloud service to a third-party monitoring tool. You create an exporter on the project level, in the same AWS region as your service:

This section shows you how to attach, monitor, edit, and delete a data exporter.

To send telemetry data to an external monitoring tool, you attach a data exporter to your Tiger Cloud service. You can attach only one exporter to a service.

To attach an exporter:

You can now monitor your service metrics. Use the following metrics to check the service is running correctly:

• timescale.cloud.system.cpu.usage.millicores
• timescale.cloud.system.cpu.total.millicores
• timescale.cloud.system.memory.usage.bytes
• timescale.cloud.system.memory.total.bytes
• timescale.cloud.system.disk.usage.bytes
• timescale.cloud.system.disk.total.bytes

Additionally, use the following tags to filter your results.

To update a data exporter:

To remove a data exporter that you no longer need:

When you create the IAM OIDC provider, the URL must match the region you create the exporter in. It must be one of the following:

Datadog Agent includes a PostgreSQL integration that you use to collect detailed PostgreSQL database metrics about your Tiger Cloud services.

1. Connect to your Tiger Cloud service

   For Tiger Cloud, open an SQL editor in Tiger Cloud Console. For self-hosted TimescaleDB, use psql.

2. Add the datadog user to your Tiger Cloud service

   create user datadog with password '<password>';

   Copy

   grant pg_monitor to datadog;

   Copy

   grant SELECT ON pg_stat_database to datadog;

   Copy

3. Test the connection and rights for the datadog user

   Update the following command with your connection details, then run it from the command line:

   psql "postgres://datadog:<datadog password>@<host>:<port>/tsdb?sslmode=require" -c \
    "select * from pg_stat_database LIMIT(1);" \
    && echo -e "\e[0;32mPostgres connection - OK\e[0m" || echo -e "\e[0;31mCannot connect to Postgres\e[0m"

   Copy

   You see the output from the pg_stat_database table, which means you have given the correct rights to datadog.

4. Connect Datadog to your Tiger Cloud service

   1. Open the datadog agent PostgreSQL configuration file, usually located at:

      • Linux: /etc/datadog-agent/conf.d/postgres.d/conf.yaml
      • MacOS: /opt/datadog-agent/etc/conf.d/postgres.d/conf.yaml
      • Windows: C:\ProgramData\Datadog\conf.d\postgres.d\conf.yaml

   2. Integrate Datadog Agent with your Tiger Cloud service

      Use your connection details to update the following and add it to the datadog agent PostgreSQL configuration file:

      init_config:
      
      instances:
      - host: <host>
        port: <port>
        username: datadog
        password: <datadog's password>>
        dbname: tsdb
        disable_generic_tags: true

      Copy

5. Add Tiger Cloud metrics

   Tags to make it easier for build Datadog dashboards that combine metrics from the Tiger Cloud data exporter and Datadog Agent. Use your connection details to update the following and add it to <datadog_home>/datadog.yaml:

   tags:
     - project-id:<project-id>
     - service-id:<service-id>
     - region:<region>

   Copy

6. Restart Datadog Agent

   See how to Start, stop, and restart Datadog Agent.

Metrics for your Tiger Cloud service are now visible in Datadog. Check the Datadog PostgreSQL integration documentation for a comprehensive list of metrics collected.