MySQL management plugin for EM 12c has been long overdue. I’ve initially migrated the older plugin to EM 12c about 6 months ago and few dozen people received this as initial beta of the plugin. It worked OK but didn’t use any of the 12c new features and its home page was a bit of a mess in the EM 12c Cloud Control web interface.
I’ve had lots of new features to add but I didn’t really have much time to invest into completing them all. Finally, I decided to just finish the home page dashboard and clean it up from all unfinished new features. I did, however, finish MySQL Slave configuration and status monitoring which was the largest gap in the the functionality of the previous plugin. There is no custom UI for MySQL slave management yet (that’s coming) but monitoring is available as standard metrics and configuration management features.
Home page looks like that in the released plugin version 184.108.40.206.0:
There you can see the summary of the MySQL instance configuration in the top left corner. Below that there is availability history and to the right there are several performance charts showing you the current snapshot of MySQL instance and how it’s doing. At the bottom of the page, there is a standard EM incident management panel.
Note the standard plugin menu in the top-left corner below the target name:
This is where you can access standard EM 12c user interface to metrics, incidents, configuration management, reports and target setup.
For example, Configuration section gives you access to the latest target configuration as well as the history and comparison with past or another MySQL target configuration:
Note that Slave Configuration is new compare to previous version of plugin for Grid Control. The configuration is obtained from
show slave status. Show slave status also has some real-time setting which I collect at Slave Status Realtime. Most of these settings are only important as the current snapshot so by default I didn’t schedule the collection of those metrics. They include the position in bin logs and relay logs, for example, as well latest errors of SQL and IO threads. Few metrics are also collected in Slave Status collection group — Slave Lag in seconds (using
show slave status) and the state IO and SQL slave threads which might be important to look at and set thresholds to raise incidents automatically.
Please report any other issues you encounter — I’m sure there will be plenty as I haven’t done extensive testing. Consider this more of the first release candidate quality. Please also comment if you get it to work along with you EM detailed version for OMS and Agents, Agent OS, MySQL OS and MySQL version.