[FEATURE REQUEST] Add an integration to monitor MongoDB metrics

lspxxv commented 1 year ago

Feature Suggestion

Our customers would like to monitor their mongodb instances with Sensu.

Possible Implementation

Context

Internal Ref - https://secure.helpscout.net/conversation/2099896432/30501?folderId=4465878

fguimond commented 5 months ago

https://www.mongodb.com/basics/how-to-monitor-mongodb-and-what-metrics-to-monitor

ManishaKumari295 commented 5 months ago

Details received from justin, Looking at the ticket that initiated the conversation about a MongoDB plugin, there are a few items that may provide some context on what the customer is looking for:

The customer noted a broken link for instructions on how to use this very old Sensu community MongoDB plugin:

https://github.com/sensu-plugins/sensu-plugins-mongodb

Our team let them know they can use the following in a check command to collect information from mongodb,

We are looking at using the command below as a check command, it uses the mongosh client to send a simple query request to perform a health check. mongosh --eval 'db.runCommand("ping").ok' localhost:27017/test --quiet

In response, the customer noted:

I would like to monitor as many aspects of our 3-node mongodb cluster as possible. Can you list what is possible to monitor via sensu and can you also point me to instructions on how to setup sensu to monitor those values?

In response we offered:

There's no Sensu native plugin for monitoring mongoDb at this time but we have put in a catalog integration feature request to get coverage for MongoDb monitoring. Since we do not have a timeframe for when this catalog integration could be started or completed, we believe the next best option would be the configuration of a prometheus exporter and also getting some graphing going with grafana, links below. https://grafana.com/grafana/dashboards/2583-mongodb/ https://github.com/dcu/mongodb_exporter https://github.com/percona/mongodb_exporter https://www.digitalocean.com/community/tutorials/how-to-monitor-mongodb-with-grafana-and-prometheus-on-ubuntu-20-04 - Provides step by step instructions

This seems to be the end of the case, and the customer noted they have what they need in the short term.
This may be what their end results look like as far as monitoring mongodb:

https://grafana.com/grafana/dashboards/2583-mongodb/

Sensu DocsSensu Docs

Sensu Catalog | Sensu Go 6.11 Read the Sensu Catalog documentation to deploy effective monitoring and observability solutions, add catalog integrations, and create your own private catalog.

Grafana LabsGrafana Labs MongoDB | Grafana Labs Note for a official Grafana MongoDB plugin, please view: https://grafana.com/grafana/plugins/grafana-mongodb-datasource This is a MongoDB Prometheus Exporter Dashboard. Works well with https://github.com/dcu/mongodb_exporter

If you have the node_exporter running on the mongo instance, you will also get some useful alert panels related to disk io and cpu.

sensu / catalog