For AI agents: the complete documentation index is available at https://docs.ovhcloud.com/de/llms.txt, the full documentation bundle is available at https://docs.ovhcloud.com/de/llms-full.txt, and this page is available as Markdown at https://docs.ovhcloud.com/de/guides/public-cloud/databases/databases-cross-service-integration.md.
Zum Inhalt springen

Set up service integration for Public Cloud Databases

Als Markdown ansehen

Find out how to use Cross Service Integration for Public Cloud Databases engines

Objective

Cross Service Integration allows you to expose your Public Cloud Databases Logs and Metrics.

This guide explains how to use Cross Service Integration.

Warning

Out of scope:

  • Expose metrics and logs outside of OVHcloud Public Cloud
  • MongoDB engine is not supported

Requirements

  • A Public Cloud project in your OVHcloud account
  • A database running on your OVHcloud Public Cloud Databases (this guide can help you to meet this requirement)
  • Access to the (optional)

Concept

The Cross Service Integrations for Logs and Metrics allow you for example:

  • To send Valkey or MySQL metrics in PostgreSQL.
  • To send PostgreSQL or MySQL metrics to OpenSearch.
  • To show metrics in Dashboards service.

For that you need:

  • A source service
  • A destination service
Best practices
Warning

Although it is possible to define the same cluster as destination service and source service, this is a bad practice for multiple reasons (performance, security, resiliency, ...)

Bad practices

Integration matrix

  • All services support logs to opensearch & kafka_logs to kafka.
  • All services support metrics to pg.

Other integrations:

source →
↓ destination
dashboards servicekafka
pgdashboard, datasource
opensearchdatasource
kmmkafka_mirrormaker
kckafka_connect

OVHcloud Console Access

  • Direct link:
  • Navigation path: Public Cloud > Select your project > Databases

Instructions

Using the OVHcloud Console

Store yours logs or metrics

Warning

First create a Public Cloud Database for your Destination service via the OVHcloud Console or API.

In the left-hand menu of your Public Cloud project, click your engine under Databases, then click the name of your service. Open the Integrations tab and click Add an integration.

In the Add an integration panel, select the integration type, then the Destination service, and confirm.

Your first integration is ready and is listed in the Integrations tab, with its Source and Destination.

Info

Note that this integration creation may have created two users, respectively: metrics_reader and metrics_writer in your engine instance. They are listed in the Users tab of your service.

Don't delete them.

Allow metrics visualization into Dashboards service

Go to the Integrations tab of your Destination service service and click on Add an integration. The first integration is already referenced in the list.

In the Add an integration panel, select grafanaDashboard as integration type, then the Source service, and confirm.

Your second integration is ready and is listed in the Integrations tab.

Connect to your Dashboards instance and browse the dashboards:

Browse Dashboards

Then open your new dashboard:

PostgreSQL Dashboard

Using API

Info

If you are not familiar with using the OVHcloud API, please refer to our guide on First Steps with the OVHcloud APIs.

Get your service and cluster IDs

You first need to identify your serviceId and your clusterId.

Get the desired service ID

Execute the following API call:

GET/cloud/project

Example response:

[
  "702de32b692c4842b0bb751dc5085daf",
  "297c1776595544759d77eee921edd49b",
  "3d4f8b8811ba4962a78f971503915f0d"
]

From the resulting list, select and copy the service identifier corresponding to the desired service, also known as serviceName.

Get the desired cluster ID

Open the following API call, paste your service ID into the serviceName input field and click Execute:

Example response:

[
  "b412100d-d298-4bee-84b7-4d5e552d3bf1"
]

Get integration capabilities

Get integration capabilities related to your Public Cloud Databases service:

Get Integration Capabilities

Store yours logs or metrics

As a first step, you need to push your metrics or logs somewhere to store them and retrieve the metrics with Dashboards.

For that, you need to create a new integration:

Fill in the form with the information corresponding to the type of integration chosen.

Create a new integration

The destinationServiceId and the sourceServiceId correspond to the destination cluster ID and to the source cluster ID.

Allow metrics visualization into Dashboards service

Now that metrics are stored somewhere, you need to connect your Public Cloud Databases service to a Dashboards service.

For that, first create a Public Cloud Database for Dashboards via the OVHcloud Console or API.

Once done, get the GrafanaDashboard integration capability related to the destination service:

Get Dashboards integration capabilitie

Then create a second integration from your Destination service name:

For example, set the request body to:

{
  "destinationServiceId": "210f40f5-e5fc-4c89-bc98-a95e357d692f",
  "sourceServiceId": "28cf7618-408d-41a5-9442-601598db0d0f",
  "type": "grafanaDashboard"
}

Example response:

{
  "id": "17ee7634-8ef5-4eea-9a23-b89852e1ea45",
  "sourceServiceId": "28cf7618-408d-41a5-9442-601598db0d0f",
  "destinationServiceId": "210f40f5-e5fc-4c89-bc98-a95e357d692f",
  "type": "grafanaDashboard",
  "status": "READY"
}

Connect to your Dashboards instance and browse the dashboards:

Browse Dashboards

Then open your new dashboard:

PostgreSQL Dashboard

We want your feedback!

We would love to help answer questions and appreciate any feedback you may have.

For training or technical assistance implementing our solutions, contact your sales representative or visit our Professional Services page to request a quote and have your project analysed by our experts.

Are you on Discord? Connect to our channel at https://discord.gg/ovhcloud and interact directly with the team that builds our databases service!

War diese Seite hilfreich?