Databases & Analytics - Set up a service integration
Learn how to use Cross Service Integration to expose your Cloud Databases or Analytics service's Logs and Metrics.
Out of scope:
- Expose metrics and logs outside of OVHcloud Public Cloud
- MongoDB® is not supported
Requirements
- A Public Cloud project in your OVHcloud account
- A Cloud Database or Analytics service running (this guide can help you to meet this requirement)
- Access to your OVHcloud Control Panel or the OVHcloud API
Concept
The Cross Service Integrations for Logs and Metrics allow you, for example*:
- To send Valkey or MySQL® metrics to PostgreSQL®.
- To send PostgreSQL® or MySQL® metrics to OpenSearch™.
- To show metrics in Dashboard.
For that, you need:
- A source service
- A destination service
NOTE: 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, etc.).
Integration matrix
- All services support logs to OpenSearch® & kafka_logs to kafka.
- All services support metrics to pg.
Other integrations:
Instructions
Using the OVHcloud Control Panel
Store your logs or metrics
Log in to your OVHcloud Control Panel and open your database instance via the Public Cloud and Databases menus.
Open the Integration tab and click + Add an integration.
Define the Integration type and the Destination service:
NOTE: First, create an instance for your Destination (Target) service via your Control Panel or API.
Your first integration is ready:
This integration creation may have created two users, respectively: metrics_reader and metrics_writer in your engine instance.
Don't delete them.
Allow metrics visualization into Dashboard
Go to the Integrations tab of your Destination service and click on + Add an integration.
As you can see, the first integration is referenced.
Define grafanaDashboard as the Integration type and the Source service. Then click Add.
Your second integration is ready:
Connect to your Grafana® instance and browse the dashboards:
Then open your new dashboard:
Using API
If you are not familiar with using the OVHcloud API, please refer to our guide on First Steps with the OVHcloud API.
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:
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:
Get integration capabilities
Get integration capabilities related to your Cloud Databases or Analytics service:
Store your logs or metrics
As a first step, you need to push your metrics or logs somewhere, to store them and retrieve the metrics with Dashboard.
For that, you need to create a new integration:
The destionationServiceId and the sourceServiceId correspond to the destination cluster ID and the source cluster ID.
Allow metrics visualization into Dashboard
Now that metrics are stored somewhere, you need to connect your Cloud Database or Analytics service to a Dashboard service.
For that, create an instance for Dashboard via our Control Panel or API.
Once done, get the GrafanaDashboard integration capability related to the destination service:
Then create a second integration from your Destination service name:
Connect to your Grafana® instance and browse the dashboards:
Then open your new dashboard:
Go further
Browse all the Databases guides.
Browse the rest of the OVHcloud US documentation for guides on our other products and services.
Learn more about Managed Databases on the OVHcloud US website.
OVHcloud Managed Databases and Analytics:
- Grafana® is a registered trademark of Grafana Labs and is used with the permission of Grafana Labs. OVH SAS and its subsidiaries are not affiliated with or endorsed by Grafana Labs.
- Kafka® is a registered trademark of The Apache Software Foundation and has been licensed for use by OVHcloud, who has no affiliation with and is not endorsed by The Apache Software Foundation.
- MongoDB® is a registered trademark of MongoDB, Inc.
- MySQL® is a registered trademark of Oracle and/or its affiliates.
- PostgreSQL® is a registered trademark of the PostgreSQL Community Association of Canada.