Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what are the mainstream database monitoring tools". In the daily operation, I believe that many people have doubts about the mainstream database monitoring tools. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "what are the mainstream database monitoring tools?" Next, please follow the editor to study!

Prometheus

Official website: https://prometheus.io/docs/introduction/overview/

Prometheus is an open source monitoring system, which stores all information as time series data, so it implements a Profiling monitoring mode to analyze the running status, execution time and calls of the system in real time, in order to find the hotspots of the system and provide a basis for performance optimization.

Its own function lies in data extraction, does not have the monitoring function, but relies on its surrounding components to achieve a powerful monitoring function.

Advantages:

Easy to manage, the core has only a single binary file, which can work directly locally and does not rely on distributed storage.

The relevance of business data monitors the running status of the service, so that users can get the real running status of the service and the application.

Efficient, a single Prometheus can handle millions of monitoring indicators; hundreds of thousands of data points per second.

Easy to scale, Prometheus can be extended to form a logical cluster by using functional partitions (sharing) + federated clusters (federation); Prometheus provides client SDK in multiple languages.

Good visualization, comes with Prometheus UI and provides a stand-alone Ruby On Rails-based Dashboard solution, Promdash.

Disadvantages:

For Prometheus users, all metric endpoints must be reachable, which means a more complex secure network configuration.

Scaling is a problem in large deployments, and Prometheus recommends collecting short-term work metrics.

One of the main design goals of Prometheus is operational simplicity. In this way, Prometheus limits the number of possible failure modes of the monitoring system, following a principle, Prometheus is currently limited to a single point, because the cluster brings additional operational complexity, using a single node is not so complicated, but there is a strict limit on the appropriate amount of metrics that can be monitored by Prometheus.

Zabbix

Official website: https://www.zabbix.com/

Zabbix is an enterprise-level open source solution that provides distributed system monitoring and network monitoring functions based on WEB interface. It has a very comprehensive application in enterprises, and it is also the most widely used monitoring software among domestic Internet users.

Easy to start, easy to use, powerful and open source free is the most intuitive evaluation of Zabbix. Zabbix is easy to manage and configure, can generate beautiful data maps, and its automatic discovery function greatly reduces the workload of daily management. Rich data acquisition methods and API interfaces allow users to collect data flexibly, while distributed system architecture can support monitoring more devices. In theory, any needs of the enterprise can be met through the plug-in architecture provided by Zabbix.

Advantages:

Enterprise-level distributed open source monitoring software supporting multi-platform

Simple installation and deployment, flexible integration of various data acquisition plug-ins

Powerful function, can realize complex multi-condition alarm

It has its own drawing function, and the obtained data can be plotted into graphics.

Provides a variety of API interfaces to support calling scripts

The command can be executed remotely automatically when there is a problem (you need to set the execution permission on agent)

Disadvantages:

It is not convenient to modify the project in batch.

There are few Chinese materials and limited service support:

It is easy to get started, but the deep-seated requirements need to be very familiar with Zabbix and do a lot of secondary customization development, which is difficult.

System-level alarm, alarm email and custom project alarm need to be set by yourself, and the process is tedious.

Lack of data summary function, data report also needs secondary development.

Nagios

Official website: https://www.nagios.org/

Nagios is an open source computer system and network monitoring tool, which can effectively monitor the host status of Windows, Linux and Unix, network settings such as switches and routers, printers and so on. Send an email or SMS alarm to notify the operation and maintenance personnel when the system or service status is abnormal, and send out a normal email or SMS notification after the status is restored.

Nagios provides a browser-based web interface that makes it easy for managers to view the running status of the system, network status, service status, log information, and other anomalies.

Advantages:

Servers, applications and devices that go wrong will automatically restart and log scrolling automatically

Flexible configuration, can be customized shell script, through distributed monitoring mode

Support for host monitoring in a redundant way, with various alarm settings

Command to reload the configuration file without disturbing the operation of Nagios

Disadvantages:

The function of the event console is weak and the plug-in is not easy to use

For performance, traffic and other indicators

Without historical data, it is difficult to trace the fault.

The configuration is complex and it takes time for beginners.

Open-falcon

Official website: http://open-falcon.org/

Xiaomi's monitoring system: OpenFalcon is an enterprise-class, highly available, scalable open source monitoring solution.

Can be from the operation level (basic configuration), and the application level (secondary development, log reporting through the port), the server, operating system, middleware, applications for comprehensive monitoring, and alarm.

Advantages:

Automatic discovery, support for falcon-agent. Snmp, support for user active push, user-defined plug-in support

Support 100 million data collection, alarm determination, historical data storage and query in a single cycle

Support for policy templates, template inheritance and override, multiple alarm methods, support for callback calls

Stand-alone support for 2 million metric reporting, archiving and storage

Data archiving strategy based on rdool

Multi-dimensional data display, user-defined Screen

Linux, Windows, Mysql, Redis, Memache RabbitMQ and switch monitoring are currently supported through various plug-ins.

Disadvantages:

The release time is short.

Many basic service monitoring plug-ins (such as Tomcat, apache, etc.) are not supported.

The function is not perfect

There is no special operation and maintenance support, community operation is lacking.

Ganglia

Official website: http://ganglia.info/

Ganglia monitoring system is an open source project of UC Berkeley, which is designed to monitor distributed clusters. The monitoring level includes resource level and business level, and the resource level includes cpu, memory, disk, IO, network load and so on.

It is a monitoring system that is easy to expand. Use it to view the performance metrics in Linux servers and clusters (graphical presentation) in real time.

Advantages:

It is suitable for monitoring system performance, and it is easy to see the working status of each node through the curve.

You can customize the monitoring items. There are two types of monitoring display: forms and images. Mobile version is supported.

It is easy to deploy and manage tens of thousands of machines through different layers without adding configurations one by one, which is conducive to large-scale expansion in the later stage.

Disadvantages:

No built-in message notification system

There is no alarm mechanism, problems can not be reported to the police in time.

Cacti

Official website: https://www.cacti.net/

Cacti is a set of graphical analysis tools for network traffic monitoring based on PHP,MySQL,SNMP and RRDTool. It provides a very powerful data and user management functions, you can specify that each user can view the tree structure, host and any map, can also be combined with LDAP for user authentication, but also can add their own templates, the function is very powerful and perfect.

Advantages:

Open source, free distribution, open source, efficient operation.

Cross-platform, supported platforms redhat, windows, solaris, centos, suse

Friendly interface, rich graphics, various templates, custom templates

Extensible, support 20 kinds of plug-ins, rich plug-in resources, greatly improve the function of cacti.

Disadvantages:

Using a textual database, the data cannot be reused

You can only view data by day, week, month, and year; you can only draw two DS (one line, one block) per picture.

Every time you get the data, you need to draw it, which is a waste of system resources.

Does not have the management function.

Graylog

Official website: https://www.graylog.org/

Graylog is an open source complete log management tool with functions similar to ELK but simpler than ELK. It is a powerful log management and analysis tool. It is based on Elasticsearch, Java and MongoDB. Graylog can collect and monitor logs for many different applications

Advantages:

The integration scheme is easy to install, unlike ELK, which has the integration problem of three independent systems.

Personalized customization development (brings a lot of freedom) the script to collect logs

The search results are highlighted.

The search syntax is simple.

Disadvantages:

Cannot handle multi-line logs, such as Mysql slow query and Java abnormal printing of Tomcat/Jetty applications.

Can not keep the original log, can only save the original log fields, so that the search log results are a pile of Json format text, can not be read.

Log lines that do not match the regular expression are all discarded.

Grafana

Official website: http://grafana.org/

Grafana is a visual panel (Dashboard) with beautiful charts and layouts, full-featured measurement dashboards and graphical editors that support Graphite, zabbix, InfluxDB, Prometheus and OpenTSDB as data sources.

Grafana is a showcase tool that we can use with Prometheus and zabbix.

Zenoss Core

Official website: https://www.zenoss.com/

Zenoss Core is open source enterprise IT management software-intelligent monitoring software that allows IT administrators to rely on a single WEB console to monitor the status and health of the network architecture.

Zenoss Core's power comes from an in-depth list and configuration management database to discover and manage a variety of assets (including servers, networks, and other structured devices) in the company's IT environment. Zenoss can create a list of key assets and corresponding component levels (interfaces, services, processes, installed software, etc.). Once the model is established, you can monitor and report on the status and performance tolerance of various resources in the IT architecture. Zenoss also provides event and error management systems associated with CMDB to help improve the efficiency of event and reminder management.

Advantages:

Comprehensive functions, network management software should cover the main functions are: availability management, event management, performance monitoring and so on.

The configuration is flexible, and because CMDB database is used to store data model objects, it is convenient to add, delete and modify data model objects.

Developer-friendly and zenoss-based development is convenient for short development cycle, concise code and easy to use.

Disadvantages:

High requirements for resources, even if only a few devices are managed, a lot of additional resources such as hardware and memory will be consumed.

For windows systems, the open source version only provides SNMP, and CPU,Disk is tested through WMI. Software, hardware and performance are only available in the paid version.

Graphite

Official website: https://graphiteapp.org/

Graphite is an open source enterprise monitoring drawing tool written in Python that can be run on cheap computer hardware. Graphite can collect, store and display time series data in real time.

Advantages:

Very fast, and its architecture is modular and scalable.

There are many open source tools that collaborate with Graphite

Graphite does a single job and does it well.

Disadvantages:

Graphite cannot fragment data, so to solve this problem is to use multiple Graphite instances

Installing Graphite is a complex task, although you now have a complete Docker image that allows you to install Graphite and its dependencies at once

At this point, the study of "what are the mainstream database monitoring tools" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.