How to use MongoDB exporter metrics in Grafana?

Joao_Freire · April 20, 2021, 2:36pm

Good afternoon, I’m having some problems connecting Mongodb exporter metrics to Grafana. Metrics are being successfully extracted for Prometheus and now I would like to use Grafana to have a more interactive view of the data. The dashboards I used are from this link [GitHub - percona/grafana-dashboards: PMM dashboards for database monitoring] and the exporter version is the latest, 0.20.4. I wonder if anyone could assist me in this matter ?
Cheers

Vadim_Yalovets · April 20, 2021, 3:41pm

Hi Joao,

Could you try a dashboard that were prepared for PMM1? Dashboards for PMM2 are using a specific parameters in formulas.
e.g.

github.com

percona/grafana-dashboards/blob/pmm-1.x/dashboards/MongoDB_Overview.json

{
    "annotations": {
        "list": [
            {
                "builtIn": 1,
                "datasource": "-- Grafana --",
                "enable": true,
                "hide": false,
                "iconColor": "#e0752d",
                "limit": 100,
                "name": "PMM Annotations",
                "showIn": 0,
                "tags": [
                    "pmm_annotation"
                ],
                "type": "tags"
            },
            {
                "builtIn": 1,
                "datasource": "-- Grafana --",

This file has been truncated. show original

Joao_Freire · April 20, 2021, 4:05pm

I tried to access the dashboard that indicated me and I had to change the name of the datasource that is fixed as “Prometheus” to the name of my Prometheus. However, the errors that appeared in the other dashboards did not appear to me, but data are not shown.

Joao_Freire · April 20, 2021, 4:06pm

In the image below, you can see a case of a list of metrics from the MongoDB Exporter, so I assume that it is not a problem for either the exporter or Prometheus configuration.

Vadim_Yalovets · April 21, 2021, 9:03am

Could you share parameters that are provided by Prometheus for a metric?
e.g.
mongodb_mongod_op_counters_total

This metric is used in the first element of the dashboard.
rate(mongodb_mongod_op_counters_total{instance=~“$host”, type!=“command”}[$interval])

Joao_Freire · April 21, 2021, 9:24am

Good morning, I researched the metrics that were indicated and just found this metric from op_counters but they have different names as you can see in the image below.

It represents an extraction of the exporter’s metrics to a txt file. I remember that I am using the latest version of Mongodb exporter.

Joao_Freire · April 21, 2021, 9:34am

I looked at the dashboard json and the metrics he is waiting for have different names than those the exporter is drawing on. That is, do I have to change the name of the metrics in json manually?
If that is the case it is worth trying, however I thought that the metrics name would not be changed in this way.

Vadim_Yalovets · April 21, 2021, 10:09am

Ok. I have missed the fact that you are using the latest version of exporter. So metrics name were changed there.

You should take a dashboard for PMM2 and modify variable names.
IMHO the easiest way is to modify formula for service_name variable.
Please replace “service_name” word by “instance”
label_values(mongodb_up{cluster=~“$cluster”}, service_name) → label_values(mongodb_up{cluster=~“$cluster”}, instance)

Joao_Freire · April 21, 2021, 11:12am

I followed these steps and already recognized my instance as you can see.

I still have to add this plugin to see if the mongodb_up metrics are really working.
But what about the rest of the metrics do I change manually? In this edit of connections you are going to get the name of old metrics.

Or is it better to wait for the updated dashboards to come out with the new metrics?

Vadim_Yalovets · April 21, 2021, 11:24am

Dashboards in PMM-2.0 brunch has already working new metrics names.
It’s a pretty strange that you don’t have metric mongodb_connections.
Could you check it on Prometheus UI?

Joao_Freire · April 21, 2021, 11:34am

It’s working, I just needed to add the name of the metrics that appears in my exporter regarding the connections.

What it seems to me is that I have to do this process for all metrics.

Joao_Freire · April 21, 2021, 11:38am

As far as connections are concerned, these are the names of the metrics that the exporter is drawing.

Joao_Freire · April 21, 2021, 11:45am

I now also changed the cursors and did the same process, that is, the name of the metrics that the Mongodb exporter is drawing are different from those presented by the dashboard.

Vadim_Yalovets · April 21, 2021, 11:59am

Also you may use flag --compatible-mode for exporter in order to get both variants of metrics.

Joao_Freire · April 21, 2021, 12:32pm

Yes, I think that was the problem, when I implemented MongoDB exporter through CHEF, I did not set this flag to true, I have already seen the metrics and they are there with the correct name.

Having said that, I will configure the Grafana with these metrics and at the outset I should have no problems, thank you very much for your help and attention.

Perwaiz_Alam · September 29, 2021, 12:05pm

Did anyone face problem while importing MongoDB ReplSet Summary json file? i am not able to import any file of mongodb to grafana dashboard.I am using latest mongodb exporter and grafana version.
please help me out.

I am using this dashboard - GitHub - percona/grafana-dashboards: PMM dashboards for database monitoring

Vadim_Yalovets · September 29, 2021, 2:04pm

Could you provide a screenshot with errors?

Perwaiz_Alam · September 29, 2021, 8:27pm

Metrics are not showing on grafana dashboard. I have used below version of mongo exporter and dashboard version.

Mongodb_exporter → v0.20.7
Grafana Dashboard version → v2.22.0
Grafana Version → Grafana v8.1.0
Screenshot Attached of error

Observation: The query which starts with mongodb_mongod doesn’t work on the Prometheus query.

Vadim_Yalovets · September 30, 2021, 2:14pm

The dashboard is using PMM datasource for variables.
Please use next script for converting dashboards.

github.com

percona/grafana-dashboards/blob/main/misc/convert-dash-from-PMM.py

##############################################################################################################
# This script converts a PMM dashboard so it can be used in an external Prometheus + Grafana installation. 
# It doesn't need any input from you. It replaces PMM2 labels (node_name, service_name) 
# used in variables with default labels (instance).
#
##############################################################################################################
#
#    !!! WARNING !!! 
#
# The script is for experiments and education. There is no guarantee that it will work on all cases as 
# the PMM uses specific labels to provide a better user experience to PMM users. 
#
##############################################################################################################



#!/usr/bin/env python2

import sys
import json

This file has been truncated. show original

Topic		Replies	Views
How to use MongoDB exporter metrics in Grafana? PMM 2.x mongodb	22	6191	July 6, 2021
Metrics from mongodb_exporter do not work with grafana-dashboards MongoDB® General Discussion	3	197	February 19, 2024
Mongodb_exporter is exporting to prometheus, but no grafana dashboards available on grafana website mongodb-exporter	5	789	October 6, 2023
Grafana MongoDB Dashboards to match with mongodb-exporter PMM 2.x	11	6905	May 15, 2023
[MongoDB] Grafana dashboard(s) MongoDB grafana	3	1224	September 2, 2021

How to use MongoDB exporter metrics in Grafana?

Related Topics