Top 60 Oracle Blogs

Recent comments

Announcing MySQL Plugin for Oracle Enterprise Manager 12c Cloud Control

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 the initial beta of the plugin. It worked OK but didn’t use any of the new 12c 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.

The home page looks like that in the released plugin version

There, you can see the summary of the MySQL instance configuration in the top left corner. Below that is the availability history, and to the right 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, the 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 compared to the previous plugin version 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 in 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. A few metrics are also collected in Slave Status collection group — Slave Lag in seconds (using Seconds_behind_master of 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.

Known issues:

  1. The plugin home page generates run-time errors if MySQL target is down. This is because the dashboard is using real-time data, and it can’t retrieve it. I’m looking into ways to solve this. It’s a bit annoying as there are multiple errors popping up, but you don’t need to close them and you can just select page from the menu that you want (like target setup or the latest configuration). You don’t really have anything useful on the home page when target is offline.
  2. If you’ve been using the previous private beta version, please undeploy it and deploy the new plugin from scratch. The new Plugin Id is different, but the target type is the same so you will encounter an error during deployment. Note that you might loose target instances when you undeploy the old beta release of the plugin along with its configuration and metrics history. When I tested it on my setup, I was able to undeploy and deploy a new one without removing existing targets. All their settings persisted, but to be on the safe side I would remove old targets and add them again. The future plugin upgrade should be straightforward.

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.

Useful links:

Happy monitoring!