
I regret that it’s still impossible to take actions like hooking shell scripts or send WS calls. The Event Handling is simpler to manage IMO, but the only choices are still sending an email and/or an SNMP trap. Many new graphs are displayed by default providing great information on database statistics trends. The Query Analyzer is now active by default for instances that have the performance_schema enabled. When a new instance is discovered is not monitored by default: an event is raised so you can create an handle that sends you an email that reminds to enable the monitoring for that instance. Now a single agent installation can monitor all database instances on the server and actively discover new ones. The new MySQL Enterprise Agent brings some benefits comparing to the old one. the filesystems are now separated objects belonging to the server. You can see from the screenshot that now the agent collects data from the system and regroup the items differently, e.g. The new graph browser allows to choose the correspondent object from the left tree-view pane. The overview page resumes well the overall availability, workload and alerts. Globally I have to say that the experience is really improved. MEM3 comes with a new graphic vest, definitely more “Oracle style” and eye-candy. If you’re new to MEM installations, just refer to the official documentation. The installation steps have not changed at all, so I won’t list them here. You can still choose between using an existent MySQL database or a new one created my the installer. The installation of the new product is as straightforward as it was for the previous release. So, as it is for Oracle RDBMS, now the new versions are released as patchsets that can be installed from scratch. Patch 17721960: MySQL Enterprise Monitor Agent 3.0.3 for Linux x86 (64-bit).Patch 17721950: MySQL Enterprise Monitor Service Manager 3.0.3 for Linux x86 (64-bit).But the release 3.0.3 is available since November 1st: in order to get it you must download two patchsets from the My Oracle Support. The binaries you can download from edelivery belong to the “base” 3.0.2 version. I want to share my very first experience with it. I’ve had the chance to propose a POC on MEM 3.0 to a customer currently relying on MEM 2.3, so we set up a VM to make some tests on it. During the MySQL Connect Open World, Oracle has announced the release of MySQL Enterprise Monitor 3.0.
