Simplifying MySQL management with Enterprise monitor

For database administrators, monitoring the database is of great importance, and the open source database has consistently fared poorly compared to commercial database products such as Oracle and SQL Server, but after MySQL launched the Enterprise version, it was Enterprise database administrators who use this Open-source database have brought a gospel: the MySQL Enterprise Monitor (Enterprise monitor). Please follow the author below to understand this powerful tool.

With the latest version of the MySQL Enterprise Monitor, database administrators can not only obtain advanced data replication and database monitoring capabilities, but also to simplify the installation, whether for the business version of the MySQL Enterprise version, or for the MySQL Community edition, it can help administrators to achieve the installation and maintenance of the database.

MySQL Enterprise monitor Fall 2007 offers silver, gold and platinum three levels of service, I tested the most versatile platinum version, its per server price of 4999 U.S. dollars each year.

The September 07 launch of the Enterprise Monitor fall 2007 consists of: A service agent, each monitored MySQL server needs to install it; there is also a service manager that uses a Java service on Windows or UNIX servers to monitor the scope of the Collect MySQL and operating system data on each MySQL server inside; a MySQL database is used by the Service Manager to display and Report server health status as an information warehouse.

For MySQL database administrators, one of the biggest reasons to consider using the Enterprise monitor is that it allows administrators to visually manage multiple MySQL servers in groups, rather than logging on to each system as before. Although such features are already commonplace in commercial databases, MySQL, which was commercialized two years ago, has taken a big step forward through this version of enterprise monitors.

The Enterprise Monitor also provides the database administrator with a web-based enterprise panel to view the chart and event data for the monitored server. I use this enterprise dashboard to configure the enterprise Monitor to maintain monitoring of the system and to get updates from the MySQL company, as well as to view events and modify settings.

Figure 1:mysql Enterprise Monitor Enterprise Panel