MySQL Plug-in 0.42 for Oracle Grid Control: First Beta Released

Posted in: Technical Track

Update: I’m currently working with Oracle development on certifying this plug-in.

Further update: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:

MySQL Plugin for Grid Control

It has finally happened! The first public release of the MySQL plug-in for Oracle Enterprise Manager 10g Grid Control is out.

It’s been a while since I first started to work on this, first as part of the Grid Control Extensibility article that I wrote for IOUG SELECT Magazine in 2006 (thanks to John Kanagaraj for encouraging me to write it), and then later as part of a demo for my presentations. I was already working at Pythian and was considering further developing my example and releasing it.

In the last few months, more and more people showed interest in the potential plug-in, and even few guys from Oracle contacted me independently of each other with their own reasons to have a MySQL plug-in available. This interest accelerated the fermentation of thoughts in my brain, and I got down to work. Pythian generously sponsored my development time.

I’ve called this first release beta but as I didn’t do much testing, it should probably be called alpha. Having said that, it has been tested with MySQL 5.1 and 5.0, and it should also work with MySQL 4.1. I develop and use it with Oracle Management Agents running on the Linux platform, but I changed all the collection scripts to use the Perl that comes with the Oracle agent so it should run on Windows as well. It works quite stably for me, and I have verified it in several real-life environments.

I would probably take some more time before releasing it, but I really wanted to have the plug-in out before I leave for COLLABORATE 08 (should I also tell you the readiness level of my presentation?). I hope to get some feedback and first impressions from DBAs who try the plug-in. Bear in mind that this is the very first release — expect some rough edges. Please do report them here. We will probably set up a more structured set of pages, but for now leaving comments here is the way to go.

Here are the details. The first release version is 0.42 because that’s obviously the perfect number to start something good.

What’s implemented so far

Standard availability monitoring in Grid Control

MySQL plug-in 0.42 homepage

Hundreds of statistics collected, organized in 19 categories

MySQL plug-in 0.42 metrics

Four out-of-the-box reports to start with

MySQL plug-in 0.42 reports

Configuration management, including history and comparison

MySQL plug-in configuration management

MySQL plug-in 0.42 view configuration

MySQL plug-in 0.42 compare configuration

What versions of Grid Control are required?

My development environment has been recently upgraded to, but I’ve tried to keep it compatible with At least, I keep the required version at in the plug-in definition so you can try it. If you need to try it with an earlier release, let me know and I will try to package a version for you.

What’s coming? Lots! Assuming there is enough interest, here are just few planned enhancements:

  1. Test and improve cross-platform compatibility (Unix/Linux/Windows)
  2. Test and improve support for MySQL 4.1-6.0
  3. Add more metrics collected, including space monitoring
  4. Assign more appropriate out-of-the-box thresholds
  5. Create more reports out-of-the-box
  6. Add logfile monitoring
  7. Rework configuration collection and categories
  8. Add out-of-the-box policies
  9. Add jobs support
  10. Add support for slave replication monitoring
  11. Add support for clusters
  12. You name it!

I have created the homepage for the MySQL plug-in for Oracle Grid Control; there you can download this and all future versions.

Give it a go and let me know how it works for you.

Interested in working with Alex? Schedule a tech call.

About the Author

What does it take to be chief technology officer at a company of technology experts? Experience. Imagination. Passion. Alex Gorbachev has all three. He’s played a key role in taking the company global, having set up Pythian’s Asia Pacific operations. Today, the CTO office is an incubator of new services and technologies – a mini-startup inside Pythian. Most recently, Alex built a Big Data Engineering services team and established a Data Science practice. Highly sought after for his deep expertise and interest in emerging trends, Alex routinely speaks at industry events as a member of the OakTable.

11 Comments. Leave new

Great job, Alex, I will be sure to do my best to get some visibility for this release during MySQLConf!

Cheers, enjoy Collaborate!


Alex Gorbachev
April 14, 2008 2:03 pm

Thanks Paul – excellent idea.
Enjoy MySQLConf!


Excellent news, Alex, particularly as our GC deployment project starts next week ;-)

I’ll be forwarding this round the work-place. Hey, I suppose that will make me a beta tester at last. It had better be good! LOL

ghassan salem
April 15, 2008 8:39 am

thanks a lot. I unjarred the file and found the ecm_deploy and ecm_un,deploy bits, used them on my Apache plugin (which lets you monitor “non-standard” apache installs), and works like a charm.
We installed your plugin (JP Pinte and myself) and it worked flawlessly.

Thanks again and keep up the good work

MySQL Plug-in for Oracle Grid Control Announced, Released
April 15, 2008 11:51 am

[…] PlanetMySQL today, I discovered that Alex Gorbachev’s announcement that he has released the first public beta of his Oracle Grid Control plugin for MySQL was not […]

Log Buffer #93: a Carnival of the Vanities for DBAs
April 18, 2008 12:17 pm

[…] Pythian’s Alex Gorbachev was there, but he still found some time to publish his MySQL Plug-in 0.42 for Oracle Grid Control. […]

MySQL plug-in 1.1 for Oracle 10g Grid Control
June 16, 2008 12:28 pm

[…] been a while since the MySQL Management Plug-in 0.42 was released. Since then, I quietly updated it to version 1.0. The changes were very few; the biggest news was […]


i have been trying to deploy an agent for monitoring, but i have not been able to do so. do you know what i am missing? i selected the host from an existing server that has oracle agent running. i assume that we do not need an agent running on the server the MySQL instance is running?
can you please help?

Alex Gorbachev
July 23, 2009 10:14 pm

@DAN: I need more details on what’s the error you are getting.

I suspect you have successfully imported the plug-in in the Enterprise Manager and now are trying to deploy it to one or more agents and this is when you are stuck.

Before deploying the plug-in to an agent, make sure it’s status is Up in Grid Control. Also make sure you have configured preferred credentials for this agent. Installation instructions reference that.

If you use the latest version of the plug-in, you don’t need an agent to the MySQL node itself – it can monitor remotely.

Silviu Risco
July 24, 2009 1:43 am

Just perfect!

Works great, no problem to install.


hola alex, soy nueva en este tema pero ya he implementado el plugin 1.1.1 con exito, puedo ver ya el servidor mysql pero en la pestaña de reports al ver informes me sale la opcion de comamds and executions ingreso a esta pero solo me sale el grafico current executions celeste y a lado un cuadro del mismo color que dice others.
el grafico de historial tambien solo presenta un solo color, mi pregunta es que debo hacer para que me salga todo lo que se realiza select, insert, begin, update, etcetera, tal como se muestra en el grafico de esta pagina. espero que me puedas ayudar con esto.


Leave a Reply

Your email address will not be published. Required fields are marked *