Prometheus Monitoring of DBs

Prometheus monitoring of a MongoDB and PostgreSQL DB instances and integration into Grafana UI for checking all is working.

Configuration

There are several parameters that need to be fixed in the deployment of the docker compose, and described in the .env file:

• PostgreSQL
  • PGSQL_USERNAME, the name of the admin user of the PostgreSQL DB.
  • PGSQL_PASSWORD, the password of the admin user of the PostgreSQL DB.
  • PGSQL_DBNAME, the name of the DB that contains the metrics of the PostgreSQL DB.
  • PGSQL_PORT, PostgreSQL Port, default: 5432.
• MongoDB
  • MONGODB_ROOT_USERNAME, the name of the admin user of the MongoDB.
  • MONGODB_ROOT_PASSWORD, the password of the admin user of the MongoDB DB.
  • MONGODB_USERNAME, the name of the monitoring user of the MongoDB.
  • MONGODB_PASSWORD, the password of the monitoring user of the MongoDB.
  • MONGODB_DBNAME, the name of the monitoring DB to keep the metrics in MongoDB
  • MONGODB_PORT, MongoDB Port, default: 27017.
• Grafana
  • GRAFANA_USER, Grafana user name.
  • GRAFANA_PASSWORD, Grafana user password.
  • GRAFANA_PORT, Grafana Port, default: 3000.
• Prometheus
  • PROMETHEUS_PORT, Prometheus Port, default 9090.
• MongoDB Exporter
  • MONGODB_EXPORTER_PORT, MongoDB Exporter Port, default: 9216.
• PostgreSQL Exporter
  • PGSQL_EXPORTER_PORT, PostgreSQL Exporter Port, default: 9187.

Remote metrics write

In case that we want to translate the monitoring metrics to an external components we can add the following section into the prometheus.yml configuration file.

remote_write:
- url: "http://your-remote-write-target/endpoint"
  headers:
    "X-Scope-OrgID": "Any ID to identify the source of the data"

Deployment

To deploy the components just execute:

docker compose -f compose.yml up -d

If you want to destroy the docker containers, just execute the command:

docker compose -f compose.yml down -v

License

This repository is licensed under Apache License 2.0.