The MySQL Plug-in for Oracle Grid Control 10g and 11g
This is the homepage of the MySQL Monitoring Plug-in for Oracle Enterprise Manager 10g and 11g Grid Control, a development project sponsored by The Pythian Group. The plug-in extends monitoring capabilities of Grid Control so that DBAs with heterogeneous environments can monitor MySQL systems using the same tool they use for Oracle products such as Oracle Databases and Application Servers.
With this plug-in, a DBA can add a new MySQL target just as they can an Oracle database. Oracle Enterprise Manager Agent doesn’t have to be running on the same host as the monitored MySQL database. I.e., remote monitoring of the MySQL database using one or two agents is possible. This is very important as many administrators prefer to keep server software stack at bare minimum whereas Oracle Agent is often considered somewhat heavy and bulky to install.
MySQL targets behave in the same way as any other Grid Control targets, including availability monitoring, performance metrics collections, configurations management, alerts notifications, and reports.
The datasheet is available here.
Notes
| Version | Notes |
|---|---|
| 1.1.2 27-MAR-2012 |
|
| 1.1.1 11-SEP-2009 |
|
| 1.1 16-JUN-2008 |
|
| 1.0 28-MAY-2008 |
|
| 0.42 14-APR-2008 |
|
Please follow this link to view requirements
Oracle has certified this plug-in as the official MySQL plug-in for Oracle Grid Control.
To go directly to the download page, click below:
The plug-in is distributed as a Management Plug-in Archive (MPA) — a .jar file that can include one or more Management Plug-ins. The file is zipped so make sure you unzip it before installation and importing it to the Grid Control.
Please follow this link to view the installation manual
Issues with a specific release, new feature requests and etc. can be posted on the blog posts in category MySQL Plug-in for Oracle Grid Control.
Category:
Tags:
[...] have just released a new version of the MySQL plug-in for Oracle Enterprise Manager — MySQL plug-in 1.1.1. This is a long overdue bug fix [...]
[...] presentation is about building monitoring plug-ins for Grid Control, the example is based on the MySQL plug-in, which I wrote and that Pythian published as free software and Oracle validated the plug-in working [...]
How can I add a new MySQL target to OMS please ?
Think
The page above has the link to the installation manual.
Alex,
How long after the 11g OEM comes out do you expect to have the plug-in certified for use in it ?
Thanks much for your and Pythian’s efforts in the Oracle and MySQL communities.
@Tony: expect it working immediately as Extensibility framework is the same in 11g EM. That what I was told. I’m working on validating the plug-in now.
[...] CommentsShow/HideMark on Nobody Killed OpenSolaris — Stop the FUD!Alex Gorbachev on The MySQL Plug-in for Oracle Grid ControlAlex Gorbachev on Nobody Killed OpenSolaris — Stop the FUD!Alex Gorbachev on Nobody Killed [...]
I have successed install this plus-in,and add the mysql target.
The HOME page works well,but REPORTS page doesn’t work, it shows “No data is currently available.”
I want to know why?
Thanks.
@seven: It takes some time to collect initial data that can be displayed in the charts.
But it has already passed more than 36 hours after I add the mysql agent. The PRPORT is still blank.
Please help me.
@seven: do you see all the metrics collected properly? Check in All Metrics section – link at the bottom of MySQL target home page.
hi
can this monitor mysql replication topologies?
thanks.
Kim, I didn’t add slave status in this version. There is very limited slave_running variable which is frequently unreliable as far as I know.
Other than that, slave and masters can be monitored independently but not replication status.
Hy Alex
We monitor the Replication status with a script that check 2 entries form show slave status .
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
if the 2 entries are YES the replication is ok . i think its enough.
ok, thank you!
Thank You, Plugin works like magic on GC 11.
Manual config for the target.xml on the MySQL server box.
Kind Regards
[...] usual, the download link is on the MySQL Plug-in Home Page as well as installation [...]
Hello, will this plug-in work with MySQL 5.5?
Yes. Make sure to use 1.1.2 version.
Will it be a plugin for the GC 12C ?