Grafana, Prometheus and a bunch of SQL’s

Extraction

We need to find a job system able to query the database at a specific interval, and prometheus-SQL is the tool that will do the job!

Collection

As we are collecting data at a specific time-interval this allows us to play around with time-series database:

Prometheus, an open-source monitoring system with a dimensional data model, flexible query language, efficient time series database and modern alerting approach.

At this stage, we have all our data extracted from our relational database into time-series events in Prometheus:

Visualisation

Summary

Using a combination of 3 different tools: Prometheus-SQL, Prometheus and grafana we can extract, collect and visualise different metrics based on our projects, and with the simplicity of this stack we are even able to add other queries in few necessary steps.

--

--

Passionate about people management, effective coaching and IT development. Currently Head Of Development, Scrum Master, AWS Certified, Surfer.

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alberto Cubeddu

Alberto Cubeddu

Passionate about people management, effective coaching and IT development. Currently Head Of Development, Scrum Master, AWS Certified, Surfer.