Learn how to use Cross Service Integration to expose your Managed Databases (also called Cloud Databases) Logs and Metrics.
- Expose metrics and logs outside of OVHcloud Public Cloud
- MongoDB is not supported
Requirements
- a Public Cloud project in your OVHcloud account
- a database running on your OVHcloud Cloud Databases (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 Caching or MySQL metrics or Cassandra metrics in M3db or PostgreSQL.
- To send PostgreSQL or MySQL metrics to OpenSearch.
- To show metrics in Grafana®. 1
For that you need:
- A source service
- A destination service
Integration matrix
- All services support logs to OpenSearch & kafka_logs to kafka.
- All services except m3db & m3agg support metrics to pg & metrics to m3db.
Other integrations:
source → ↓ destination |
grafana® | m3db | kafka |
pg | dashboard, datasource | ||
opensearch | datasource | ||
m3db | dashboard, datasource | ||
m3agg | m3agg | ||
kmm | kafka_mirrormaker | ||
kc | kafka_connect |
Instructions
Using the OVHcloud Control Panel
Store your logs or metrics
Log in to your OVHcloud Control Panel and open your Public Cloud
project. Click on Databases
in the left-hand navigation bar, select your engine instance, and open the Service integration
tab.
Click on Add an integration
:
Define the Integration type and the Destination service:
m3dbMetrics
as the Integration type and your M3db database as the Destination (Target) service, as shown below. Then click Confirm
.Your first integration is ready:
Don't delete them.
Allow metrics visualization into Grafana®
Go to the Service integration tab of your Destination service service and click on Add an integration
.
Define grafanaDashboard
as the Integration type and the Source service. Then click Confirm
.
Your second integration is ready:
Connect to your Grafana® instance and browse the dashboards:
Then open your new dashboard:
Using 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 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 Grafana®.
For that, you need to create a new integration:
Fill in the form with the information corresponding to the type of integration chosen.
The destionationServiceId
and the sourceServiceId
correspond to the destination cluster ID and to the source cluster ID.
Allow metrics visualization into Grafana®
Now that metrics are stored somewhere, you need to connect your Cloud Databases service to a Grafana® service.
For that, create a Cloud Database for Grafana® 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
For more information and tutorials, please see our other Cloud Databases support guides or explore the guides for other OVHcloud products and services.
[1]: The Grafana Labs Marks are trademarks of Grafana Labs, and are used with Grafana Labs’ permission. We are not affiliated with, endorsed or sponsored by Grafana Labs or its affiliates.