Visualizing IP addresses on a world map with Grafana

Well, This document is something particular, since it had a series of public IP addresses in a MySQL table, that I would like to visualize it in Grafana. Basically I'm talking about the visits to the blog 🙂 I have a WordPress and I don't have the database in my possession since it's on an external hosting… I leave you the steps I followed to achieve it, I hope it can be useful for other ideas.

Monitoring MySQL database queries using Centreon

Another marvel of monitoring with Centreon, is that it allows us to make queries to any type of database, in this post we will see how to query a MySQL database, We can launch any type of query that helps us to know the state or value that interests us, then we will be able to know that there are no blockages or that 'something’ He has not stopped writing on his table…

Put the Home Assistant DB in MariaDB

Call me meticulous, but I usually put the Home Assistant database on an external server with MariaDB or MySQL, since I usually make remote queries to the DB with some system, or for the issue of backup, robustness, etc… It is not something usual to do, But I'll leave you the steps in case you need it!