Come on, go, that we hadn't given to Centreon for a while; today a classic, But well. If we have any Microsoft SQL Server services in our organization, We can't let it go, apart from your availability, we must know its performance!
Well, in this post we will see something as always different and that we can simply add to our Grafana installation, and it is nothing more than exploiting the usage data of our phone calls. I've been using it for a long time and I wanted to share it in case you're interested, I was curious how much I talked on my mobile phone, with whom, what they called me and I called, See it by schedules, people… with nougat!
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.
Good, I leave you a post where we see how we can exploit the information stored by Citrix in its databases. As I imagine you know, Citrix stores in a database the records of what happens on our Citrix farm, but that is true, as much as you pay, as much as you get, that is, which depends on the Edition we have, Citrix will store information in those databases for 1 week, or 1 month or 1 year. Here we will see how to make our own panels with Grafana and without date limits!
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…
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!
This document will be useful in reducing the size of our VMware vCenter database, it will also be necessary when it reaches the limits if we have it in a SQL Express, since the services will not start and therefore we will have errors in the registry that will indicate it to us.
If we ever need to migrate the database from our Symantec Backup Exec to another database server, or even to get it from SQL Express itself to a network DB server we can follow this simple doc, it will be enough to run the 'Exec Backup Utility', we will indicate the new destination of the DB and restart the Bexec services.
Do Tailor-made training
Windows Server – VMware vSphere – Citrix Virtual Apps & Desktops – Centreon
|
We are a consulting firm that cares and pampers
|
 |
|
With quality and added value
|
 |
|
¡Let's work together!
|
 |
