| 摘要: |
| 气象信息机房作为保障预报业务的基础支撑，影响其设备运行的主要因素包括供电系统、环境系统和空调系统。为实现以上因素的全天候监控，基于Linux操作系统，通过Python开发技术，实现对机房动环SQL Server数据库信息的实时采集并输出到日志，通过Zabbix监控系统实现对日志信息的再次解析，系统内建的告警媒介模块判断日志信息最终实现声音告警。Zabbix系统具备图形化展示功能，分析历史趋势和拓扑结构，有利于准确定位故障节点，缩短排除故障的时间，大量减轻人力成本，符合当前智能化运维的趋势。 |
| 关键词: 机房动环；SQL Server数据库；Python；Zabbix |
| DOI： |
| 投稿时间：2021-08-11修订日期：2021-11-18 |
| 基金项目: |
|
| The Design and Realization of the Monitoring System for the Dynamic Environment of the Provincial Meteorological Computer Room |
| Baitienan,tangweiyao,jinshisheng,luxia,tanhaibo |
| (Guizhou Provincial Center of Meteorological Information Support;Guizhou Meteorological Information Center) |
| Abstract: |
| As the basic support for the weather forecasting business, the weather information computer room has factors that affect the normal operation of internal equipment including power supply system, environmental system, and air conditioning system. In order to realize all-weather real-time monitoring of the above factors, this article uses the Python development technology of the Linux system. Realize real-time collection of database table information of the dynamic SQL Server database. After outputting it as a log, it will be integrated into the Zabbix system to achieve secondary log analysis and real-time monitoring of alarms. Through Zabbix historical data trend chart and the topological structure of each factor, it is conducive to accurately locate the faulty node, shorten the time for troubleshooting, greatly reduce labor costs, and comply with the current trend of intelligent operation and maintenance. |
| Key words: Engine room moving ring；SQL Server database；python；Zabbix |
