Design And Implementation Of Monitoring Tool Of Virtual Database System

Virtualization technology is a solution. The database management system virtua-lization, virtualization can form a database management system, it can block out the differences between the data source so that the user can use a uniform way to access it. To virtualize database management system for monitoring, not only to monitor the cluster machine hardware, but also need to monitor the database instance. Al-ready existing database monitoring system, because of other reasons platform, vir-tualization database monitoring system requirements can not be a simple way to meet integration. Therefore, the design and implementation of an easy to use, plat-form-independent and can provide a unified way to access database management system virtualization monitoring tool is very meaningful.Centralized architecture and multi-tree structure of the existing monitoring tools and monitoring system using up to two structure, they each have advantages and disadvantages, and be used in different scenarios. After a careful analysis of the structure on the basis of the merits,we proposed a three-tier tree structure.This virtualized database monitoring system consists of four parts, namely:WEB side, the central controller, monitor-server and monitoring information collector. Monitor-collector is responsible for collecting the information coming from host nodes and the running database system. Monitor-server is responsible for monitoring and controlling the operational status information,collect and aggregate all detection information into the central database. Monitor-collector and monitor-server is ma-naged by a central controller, when there up or down monitor nodes, collectors and monitor-server can be rescheduled by central controller. Load balancing algorithm aims to harmonize the number of collector monitored by monitor-server, adjust the relationship between monitor-server and monitor-collectors dnamically. Meanwhile, users or the third-party applications can access the required monitoring data through the central controller which provides application programming interfaces, the infor-mation can be properly processed and displayed visually on the WEB page. Using timer technology, asynchronous requests and Fushion Widgets technology and FLOT graphics rendering technology, real-time, dynamic monitoring plotted graphs, users can learn more about the current system’s running state.In the realization of each module, we used the very mature and popular Spring framework, which reflects the very good persistence layer, business layer and the view layer of the three-tier architecture design ideas.