THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

The MySQL Plug-in for Oracle Grid Control

This is the homepage of the MySQL Monitoring Plug-in for Oracle Enterprise Manager 10g 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.1
11-SEP-2009
  • Tested with Oracle Enterprise Manager Grid Control 10g Release 5 (10.2.0.5)
  • Fixed the bug with connections not closed properly
  • Fixed bug that caused collection to hang and time-out (Net::MySQL bug — not recognizing a final packet in result-set)
  • Fixed bug that caused collection processes to spin on CPU (Net::MySQL bug when zero length packet returned from the socket — very weird why it happens)
  • Fixed few bugs in Commands and Executions report – graphs produced errors from time to time
  • Removed columns Compression and Tc_log_% in Others metric
  • Changed metric Opened_tables into ratio per second
1.1
16-JUN-2008
  • Perl Net::MySQL package is used
  • No MySQL client is required
  • Fully compatible with Windows
  • Unix sockets support
  • Visible error message when target is down
  • Commands statistics collection improved
  • Changed default collection frequency for network, joins and sort statistics
  • “Processes by Action” metric is improved
1.0
28-MAY-2008
  • Certified by Oracle
  • Added optional path to mysql binary
  • Few minor bug fixes
0.42
14-APR-2008
  • The first public beta release 0.42

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:

MySQL Plugin for Grid Control

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.

4 Responses

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

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

  3. LAKHAL says:

    How can I add a new MySQL target to OMS please ?

    Think

  4. The page above has the link to the installation manual.

Leave a Reply

Start NowWith Pythian - database design, management and emergency handling capabilities...

Live Updates

pythian: RT @sheeri: #confoo talk "Bending Queries to your Will with EXPLAIN" slides http://bit.ly/explainslides & handout
more



Testimonials

  • Serge Racine

    DBA, Brookfield Energy

    We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more