Database Monitoring
Database monitoring Database monitoring - DB check for access and regular execution of the specified query.

Database monitoring feature allows to run a query during every check and react in the appropriate way on the result. Also, it is possible to check just possibility to connect to DB - by ignoring the query field. To set the monitoring, fill the connection data: DB server address, port, database name, login and password of a user for connection. We strongly recommend to create the new user with limited rights. However, do not forget to provide him enough rights for performing the supposed actions. Also, it is necessary to add HostTracker servers addresses, to the whitelists on firewall or other blocking software, to allow the access. The addresses are permanent, and are listed on the same form.

Create ContentCheck Task

There could be arbitrary query - SELECT, UPDATE, DELETE, INSERT, execution of stored procedures (like scheduler), results comparison, logical operations. The only restriction is execution time - it should not take longer than 30 seconds. Otherwise, the timeout error will be reported.

It is recommended to create the queries which display the necessary value in the first row of the first column. This result can be analysed. For UPDATE, INSERT, DELETE queries the number of affected rows is analysed. There are different ways to analyse the resulted value by comparison with specific preset - equal/not equal/higher/lower/in range. In case the condition is not satisfied, no connection to DB, query timeout - the error is reported.

Create ContentCheck Task
  • CM.Glossary.WebsiteMonitoring
  • CM.Glossary.ContentCheck
more glossary
"

Very usefull service, helps us to monitor activity of our sites.

"
- A.
What could we check by using the cloud services? Part 2

  In the beginning, HostTracker company was founded on the basis of a simple website to provide free customer services. Though, a few years later, this startup developed a wide variety of tools serving to solve various problems, including different network issues. In a series of publications, we have decided to describe thoroughly all the features of our service, also to share our experience in the development of such projects with you and to mention interesting challenges that we faced. 

In the beginning, HostTracker company was founded on the basis of a simple website to provide free customer services. Though, a few years later, this startup developed a wide variety of tools serving to solve various problems, including different network issues. In a series of publications, we have decided to describe thoroughly all the features of our service, also to share our experience in the development of such projects with you and to mention interesting challenges that we faced. Moreover, for those seeking an example of how to sell something that had been made for themselves, our experience would be useful, as most of our features were developed due to our personal needs.

In the previous part of the review we have talked about the history of the service and the most basic functions - regular inspection of sites and servers, and what is more, notification of their efficiency. Before starting to describe more advanced features, we should write where do all these ideas come from and how to prioritize them. One of the key secrets often used by entrepreneurs is to follow the statement: all people are unique. All customers’ requests are unique, so you have to learn how to deal with them. Therefore the IT sector is utterly susceptible to this factor, as a great number of customers have profound knowledge and diverse experience. Nevertheless, part of the problems can be solved with available resources. However, the main feature of our work is that, frequently, we have to evolve something. Most of the HostTracker’s functions were developed or adapted due to the conveniences and needs of the particular people. We are also a part of that people, as having rather large infrastructure, and also need to have everything work properly. Therefore, we ourselves are the most picky client.


Precious little things

It worth noting, that in addition to different regular checks, there are other useful tools. They include monitoring of the domain and SSL certificate expiration time. This seems to be negligible, but could bring a lot of unexpected inconveniences to work. These functions appeared in HostTracker, when one of our personal domains had expired. Moreover, large companies also frequently face these problems, as the prolongation of the domain /certificate expiration time depends on the unreliable human factor. Therefore, a notification that the domain should be prolongated, is stored not only within spam folder (already overflowed with continuous marketing messages from your hosting company), but also to the folder with the data of website downs. As well as, the SMS notification capability still exists. That’s why these features are being so handy.

Another interesting feature is the domain check to see if they are blacklisted in DNS-based lists. These lists are independent and are generated separately using different algorithms. What is more, they were mainly created for filtering of the suspicious entities. Each administrator can configure own web server in different ways, for example, not to receive messages from the servers from a specific list. It helps fight off spam, malware spread, DDoS attacks and other problems. But all of these lists have their own algorithms, and there is no guarantee that in the result of any coincidences your website wouldn’t appear in any of these blacklists. Moreover, according to the statistics, this is happening on a regular basis with the most innocent sites. For example, no one can guarantee that a hacker wouldn’t use your nearby IP for different spam attacks. In this situation, the entire range of IPs would be considered as unreliable. What are the consequences of that?  Your messages wouldn’t be delivered to customers, the site wouldn’t be so easily found in search system and so on. Furthermore, you will find out this problem when the changes become critical or even irrevocable. Therefore, the monitoring and notification of DNSBL are also essential.

The content check

Here is a good example of how the usage of functions may exceed developers expectations. We have mentioned about several such cases earlier. Actually, nowadays a lot of things have a web interface whilst for others – it could be easily created, if needed. Therefore, it was developed not only the check function of whether the page was loaded completely using simple parsing, but also another mind-boggling things of this check. Adapting to different customer requests, this feature has become very flexible. It may look for one or plenty of words from the list at once. Moreover, it may detect the emergence of certain phrases. This feature may also raise as an error the whole line that contains the keyword. For instance, if there is a kind of server-status page (“Server 1 OK” etc.) and it shows “Error”, then the message will be “1 Server Error”.  In this case, all diagnostic is already done, and you can start troubleshooting immediately.

What if it happens, that the server should be down?

In addition to the notification of the failures of the sites, HostTracker provides another important function – gathers statistics of each examined site. When the various buttons on the sites were popular – HostTracker’s button also often appeared with the figures of website attendance, the weather forecasts and other things like that. Now it is possible to use a widget, but still the button is also available for retro fans. In addition, statistics is very important for managers. They constantly want to know whether the website and administration of it are working properly. Therefore, there is another useful function - the maintenance planning. Even the most stable sites and servers must be updated or rebooted from time to time. At the same time, it’s not the desired to lose so-called “9s” in terms of uptime. Planning of the maintenance let us achieve two goals (together or separately). This includes: not to send error notifications and not to record errors to the statistics during a specific span of time. Of course, it seems to be a kind of cheating, but outlined maintenances are justified, especially in excluded time. In addition to this, different verifications have being done and written to the log during maintenances. It can be useful for webmasters and administrators, as log let determine exactly the duration of updating or restarting processes, any occurred errors, other breakages etc. Moreover, thanks to that, the whole process of error emergence could be tracked: from the stage when the server wouldn’t be available for some time to the stage when the application would return an error.

Maintenance can be scheduled as a one-time job or on a regular basis. For example, if the backup is done every night, or a new release - every Thursday. The only condition is that the maintenance schedule should be made up at least 12 hours prior to the site/server nearest suspension period of time. This is done to ensure that all maintenances won’t be responsible for any pity unexpectancies, and statistics provided by HostTracker will be trustful.

A kind of an epilogue

We are frequently asked why we are doing this. The same things could be done without HostTracker’s help.  And you know what - definetely, they could. Especially, if you need only one tool. Many people are talking, that the whole Business World is built on human laziness. By solving routine problems, HostTracker provides a slice of work-free and responsibility-free time in the customer’s schedule. Truly, not everyone is able to assemble a car by himself. We look up to people, who are eager to create something good for personal needs in our field, but most people don’t want to spend their free time for doing something like that.

Additionally, our clients are: non-IT specialists; IT specialists who have to report something to their managers; managers themselves; fans of reliability – they use their own tools and take advantages of someone else’s; and many other groups of people.

All in all, we are always looking forward to your comments.

more blog
Thank you for feedback!
 
Sign In
Sign Up
Prices & packages
Our monitoring network
Home > Blog > UptimeWebMonitoring

Website monitoring is a process of supervision over the performance of the site. HostTracker is a powerful tool which serves that purpose.

Website monitoring is a process of supervision over the performance of the site. Usually it is used to keep an eye on commercial sites or other pages for which high availability is very important.

Companies, which provide website monitoring services, let their clients to check a website, a server, port or other available from the Internet entity. The responses are collected and analyzed. Usually, the monitoring is performed from different locations, distributed over the whole world or the specific continent or country. Such monitoring is called distributed monitoringand helps to detect network-related issues as well as site or server-related. Also, distributed monitoring often makes possible to analyze the site performance from the places which are close to the real customers, instead of some distant locations which could have high latencies. The collected information could be found in a different form: email reports, graphs and different smart dependencies, to help the client to get a comprehensive view of the site's performance. Parameters like load time, speed and others can help to optimize the site performance. In case of critical error, monitoring services use variety of notification methods to deliver the alert to the client: SMS, voice call, instant messengers, email and others. This, together with immediate diagnostics, helps responsible persons like server administrators or developers to fix the site as soon as possible and minimize the duration of the failure.

Why is this important? For commercial sites, working time is proportional to their income. Roughly speaking, 2 hours of failure per day means that 1/12 part of the potential clients are lost. Even more - loyal customers also can find a more reliable competitor in case they can not receive their services/goods when they want. For other types of sites, like government, educational, NGO this is very important too. If people can't find the information fast, they'll find another source. Some parameters like site speed are important for search engines, others - database connectivity, for example - can greatly affect the convenience of usage of the site. Monitoring of some internal values like CPU load, memory consumption and disk space are important for administrators in order to prevent performance degradation. Another important purpose is verification of SLA (service-level agreement) of hosting provider. For technical issues, no site can be available 100% of time during long enough period. Sometimes servers are rebooted, updated or upgraded. So each hosting provider guarantee some specific value, which is called uptime, that shows how long can a site be down for technical reasons. Uptime is usually measured in percent. In this table it is shown for how long a site could be down for each uptime value:

  • 90%          876 hours
  • 95%          438 hours
  • 99%          87,5 hours
  • 99.9%       8 hours 45 minutes
  • 99.99%     52,5 minutes
  • 99.999%   5 minutes 15 seconds

If the real site performance does not correspond to SLA, it could be a reason for claim and refund request. Also, it can help the customers to select the best hosting for their needs.

Monitoring companies often provide some additional services, like vulnerability check, virus scanning, domain and certificate expiration check and many others, in order to make a useful product for their customers.

Different ways to monitor

The monitoring, based on the purpose, can be performed in several ways. Internal monitoring tools require some software to be installed into the monitored system, for example, corporate network. It helps to detect network issues, system performance and exclude or catch hardware and performance issues. External monitoring is performed from outside. It's purpose is check the availability and performance of the system by the third-party's eyes. Real user monitoring is external monitoring which simulates the real visitor of a site. Depending on complexity, such monitoring can analyze the page loading, content, sometimes - even design problems. Most advanced monitoring can offer its client to create a scenario for a visitor. This is called transaction monitoring and can perform some steps one-by-one: like load the page, navigate through menu, make a purchase. Passive monitoring is performed by a code which is integrated into the website code and sends specific information to the collector server each time the page is loaded. It helps to analyze customers actions on the site and analyze the traffic.

Monitoring services usually support different check protocols, and can monitor not only the websites, but also other entities like a file servers, mail servers, specific ports etc. Depending on task, monitoring interval can vary from several seconds to once per day.

Share:
Send to Twitter Send to Facebook Send to LinkedIn Share on Google+
Blogs:
HostTracker blog HostTracker page on Facebook