To further enhance TDengine’s own monitoring and maintenance capabilities, Taos Data has developed TDinsight, a zero-dependency monitoring solution based on Grafana that works with TDengine 2.3.3.0 and above.
As a basic component, the smooth operation of TDengine itself is critical, so we need to monitor its performance during the actual application process.
After TDengine is started, it automatically creates a log to monitor the database and periodically writes server information such as CPU, memory, disk space, bandwidth, number of requests, disk read/write speed, and slow query to the database.
TDengine also logs important system operations (such as logging in, creating, deleting databases, etc.) and various error alarms in the log library. System administrators can view the database directly from the command line or view the monitoring information in a graphical interface on the Web. The collection of this monitoring information is turned on by default, but can be controlled by modifying the option monitor in the configuration file.
To further enhance TDengine’s own monitoring and operations capabilities, Taos Data has developed TDinsight, a zero-dependency monitoring solution based on Grafana. TDinsight can be used with TDengine 2.3.3.0 and later.
TDinsight offers a wealth of monitoring options, and its complete interface view is as follows:
The TDinsight dashboard is designed to provide usage of TDEngine-related resources such as DNodes, MNodes, and VNodes, or database usage and status. Let’s take a look at them in turn.
1. Cluster Status
This section contains the current information and status of the cluster, as well as the alarm information (from left to right and top to bottom). Here you can see the situation of the cluster number, database, the current number of connections, such as DNodes/MNodes/VGroups/VNodes and total survival of each of these resources, etc.
2. DNodes Overview
You can view the DNode life cycle, number change, and reason if any DNode is offline.
3. MNodes Overview
You can view the status and number of MNodes.
(4) Requests for Requests
You can view the change of the number of insert requests and insert records over time, the average number of insert requests per second, the number of query requests and change rate (Count of second), and the number of HTTP requests and request rate (count of second).
5. Database
Database usage, a repeated multi-row display of each value of the variable $DATABASE, i.e. each database, including the number of super tables, the number of all tables, the number of sub-tables of all super tables, the graph of the number of ordinary tables over time, and the number of tables contained by each VGroups.
6. DNode Usage
Display of data node resource usage, repeat multi-line display of variable $FQDN, i.e., each data node, including: Time elapsed since DNode creation, whether the DNode is an MNode, number of CPU cores, number of VNodes in the current DNode, number of VNodes in the master role, CPU usage of the TaOSD process, memory usage of the TaOSD process, and total disk usage of the TaOSD data directory Ratio, process and system CPU usage, disk I/O rate, and network I/O. There is also Login History information.
TDinsight is very simple to install and deploy, and we provide an automated script tdinsight.sh for your convenience. For more details, please refer to the related documentation.
Download and try it out!