No, it’s not normal to have 500 active alarmsMarch 11, 2019
Muutech participates in #4YFN 2019 in BarcelonaMarch 25, 2019
Database monitoring in the current company
There are two main types of databases taking into account their storage format, the physical (libraries, newspaper libraries, etc.) and the digital, more extended format. The last one have some substantial advantages, among the most prominent are the speed of search, remote access to data and the multiplicity of opportunities and operations that can offer different users on the same data. We will focus on these from now on.
Within this type, there are other formats, such as relational (MySQL), object-oriented (ONTOS), etc. but that is another matter. Here we want to focus on how these databases are useful for companies today.
What can they do for my company?
In addition to the obvious data storage utility. There are many other utilities for a database. For example, having a centralized database is a very useful way to avoid the always costly duplication of data. It is also useful to increase productivity due to the instantaneous access to information from different points and that it is always sorted in the same way.
Another important advantage, which we will discuss in this article, is the greater ease of these databases to be managed and monitored. For a correct monitoring of a database, it is necessary to monitor both the database and the elements that allow access and execution of it. Next, we will see some of the improvements that can suppose an effective monitoring of this database.
Advantages of monitoring
The main advantage of monitoring lies in effectively seeing the performance of the database for the tasks we want to perform. There are many specific tools designed for this function, but not all are adapted equally for everyone, so the selection of a monitoring tool is very important for a company.
For example, if in your company the database is only used as a data warehouse and the speed with which it returns data is not important, monitoring which requests are the slowest will not be of much help. However, if your company requires a quick response, this data is essential. On the other hand, knowing the exact number of connections (and their location) to a database can be interesting from a security point of view.
If our company was dedicated to the development of software related to databases, it would also be important to know data such as database usage, search speed, insertions, deletions, etc.. that can help detect bugs in the developed software.
Continuing with a previous example, we can see an example of the Muutech platform, based on Zabbix, in which we show the number of connections to the PostgreSQL database, we see that it is stable, so we do not have any unwanted connection.
As we can see, having a good monitoring tool is fundamental for any company. It is also very important that this tool adapts perfectly to what we require, since sometimes it is as bad to have insufficient data as an excess of them, if they do not know how to manage correctly.