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

Apr 14, 2008 / By Alex Gorbachev

Tags: , , ,

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 10.2.0.4, but I’ve tried to keep it compatible with 10.2.0.3. At least, I keep the required version at 10.2.0.3 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.

11 Responses to “MySQL Plug-in 0.42 for Oracle Grid Control: First Beta Released”

  • Paul Vallee says:

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

    Cheers, enjoy Collaborate!

    Paul

  • Thanks Paul – excellent idea.
    Enjoy MySQLConf!

  • Doug Burns says:

    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 says:

    Alex,
    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

  • [...] 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 [...]

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

  • [...] 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 [...]

  • DAN V LU says:

    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 says:

    @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 says:

    Just perfect!

    Works great, no problem to install.

  • leo5511 says:

    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

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>