Monitoring the MySQL on Azure

eG Enterprise provides a special-purpose monitoring model for the MySQL on Azure.

Figure 1 : Layer model of the MySQL on Azure

Each layer of Figure 1 is mapped to a variety of tests pertaining to the MySQL Service, MySQL Database, MySQL Memory, MySQL Server and MySQL Azure Infrastructure layers. Since the tests pertaining to theMySQL Service, MySQL Database, MySQL Memory, and MySQL Server layers are similar to MySQL Server monitoring model; they have already been discussed in the Monitoring MySQL Servers section, the sections to come will discuss the tests associated with the MySQL Azure Infrastructure layer alone. The tests mapped to this layer track the CPU usage, memory utilization, network traffic, database connections, and storage of the target database. Using the measures reported by these tests, administrators can find quick and accurate answers to the following performance queries:

  • What is the current status of the target database?

  • Is the percentage CPU utilized by the target database to process the tasks too high?

  • Is the percentage of memory utilization too high?

  • Is the percentage of storage utilized by the target database too high? If so, then what is the amount of used and available storage?

  • Are there too many connections on the target database?

  • Are there too many connection failures?

  • Does the target database optimally utilize server log storage?

  • Is the replication lag time of the replica server too high?

  • Is the target database experiencing too much network traffic?

  • Is the database excessively consuming I/O?