The MySQL Plug-in for Oracle Grid Control 10g and 11g

If you are looking for the plugin for Oracle Enterprise Manager 12c, it’s here.

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	Fixed “#08S01Bad handshake” bug in Net::MySQL Improvements in Net::MySQL to make it work with 4.1.22 (and probably older) by Nigel Williams from RMIT University
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.

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.

40 comments on “The MySQL Plug-in for Oracle Grid Control 10g and 11g”

Pingback: Announcement: Release 1.1.1 of MySQL Plug-in for Oracle Enterprise Manager | Pythian Group Blog
Pingback: Alex Gorbachev at Oracle Open World 2009: Speaking Schedule | Pythian Group Blog
LAKHAL on February 25, 2010 at 9:12 am said:

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

Think

Reply ↓
Alex Gorbachev on February 25, 2010 at 11:46 am said:

The page above has the link to the installation manual.

Reply ↓
Tony Johnson on April 14, 2010 at 12:00 pm said:

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.

Reply ↓
- Alex Gorbachev on April 16, 2010 at 8:16 am said:
  
  @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.
  
  Reply ↓
Pingback: Liveblogging: Edward Screven State of the Dolphin Keynote | The Pythian Blog
seven on May 10, 2010 at 9:22 pm said:

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.

Reply ↓
- Alex Gorbachev on May 11, 2010 at 9:00 am said:
  
  @seven: It takes some time to collect initial data that can be displayed in the charts.
  
  Reply ↓
  - seven on May 11, 2010 at 9:47 pm said:
    
    But it has already passed more than 36 hours after I add the mysql agent. The PRPORT is still blank.
    Please help me.
    
    Reply ↓
    - Alex Gorbachev on May 18, 2010 at 1:32 am said:
      
      @seven: do you see all the metrics collected properly? Check in All Metrics section – link at the bottom of MySQL target home page.
      
      Reply ↓
kim on January 25, 2011 at 11:26 am said:

hi
can this monitor mysql replication topologies?
thanks.

Reply ↓
- Alex Gorbachev on January 25, 2011 at 2:58 pm said:
  
  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.
  
  Reply ↓
  - PerYcut on March 27, 2012 at 6:14 am said:
    
    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.
    
    Reply ↓
kim on January 27, 2011 at 12:29 pm said:

ok, thank you!

Reply ↓
Bongani on March 8, 2011 at 7:33 am said:

Thank You, Plugin works like magic on GC 11.

Manual config for the target.xml on the MySQL server box.

Kind Regards

Reply ↓
Pingback: Announcement: Release 1.1.2 of MySQL Plug-in for Oracle Enterprise Manager 10g/11g | The Pythian Blog
anya mendenhall on May 7, 2012 at 10:13 am said:

Hello, will this plug-in work with MySQL 5.5?

Reply ↓
- Alex Gorbachev on May 7, 2012 at 10:49 am said:
  
  Yes. Make sure to use 1.1.2 version.
  
  Reply ↓
ulf edfors on May 22, 2012 at 7:09 am said:

Will it be a plugin for the GC 12C ?

Reply ↓
- Alex Gorbachev on May 22, 2012 at 11:32 am said:
  
  plugin 1.1.2 works for GC11 and new MySQL versions.
  GC 12c exists in alpha and everyone who received it reported it as working. I’m finishing some UI work and it will be released shortly for public.
  
  Reply ↓
sma on May 24, 2012 at 9:25 am said:

I installed the mysql 1.1.2 grid control add on. All the steps went fine. However target is not collecting the stats

Target mysqldb
Type MySQL Server
Metric Response
Collection Timestamp May 24, 2012 9:55:50 AM
Error Type Collection Failure
Message em_error=Timeout of authentication at /u01/app/OEM11g/Middleware/agent11g/sysman/admin/scripts/emx/mysql/mysql_oem.pm line 45

Any idea? I have specified ip address, username, password for mysql. I have verified the password works and has privilges. Is there a linux command line I can run to simulate this perl error?

Thanks
SM

Reply ↓
- Alex Gorbachev on May 24, 2012 at 9:45 am said:
  
  What’s your MySQL version? OS?
  
  Reply ↓
sma on May 24, 2012 at 2:56 pm said:

Hi Alex -

its as below

Server version: 5.5.23 MySQL Community Server (GPL)

I had host name of mysql server before then I tried ip address. Same issue. Also, I can ssh from agent node to target mysql server and ping

Thanks
SM

Reply ↓
- Alex Gorbachev on May 24, 2012 at 3:31 pm said:
  
  Can you connect to that server from the host with Oracle EM Agent using normal MySQL client?
  
  Reply ↓
sma on May 24, 2012 at 4:21 pm said:

Hi Alex,
I am able to connect. I had given ‘root’ user before but now I have given some other user name and has process/reload priv. The agent node didnt have mysql so I installed it.

Reply ↓
sma on May 24, 2012 at 4:59 pm said:

Alex,

After I changed the user to some username other than ‘root’ – it seems to be connected. Although not knowing normal its little bit hard to tell all is working. However, availability of 100% and various choice in “Reports” showing data makes me think its working …

Thanks

Reply ↓
- Alex Gorbachev on May 25, 2012 at 12:05 pm said:
  
  I think it must be something else than just a user. Can you try to enter an invalid password and see if you get a timeout or a wrong password error ? Or enter a non-existing username?
  
  Reply ↓
Remco on July 9, 2012 at 1:23 am said:

Alex,

Could you give an estimate about when the plugin for em12c will be released?

Thanks,
Remco

Reply ↓
Bill Zeledon on July 9, 2012 at 2:19 pm said:

Can we get the alpha release of the plug-in for OEM 12c ?

Reply ↓
Livia on July 17, 2012 at 10:25 am said:

when is the plugin for 12c be available for download?

Reply ↓
Jenn on August 8, 2012 at 12:31 pm said:

Is there a time estimate when the EM 12c plug-in will be available?

Thanks,
Jenn

Reply ↓
Frank Delisle on August 21, 2012 at 8:33 am said:

Hi Alex,
can you please send me the alpha (or beta) version of the plugin for cloud 12c bp1? I’d like to test it. I’ll send you feedback.

Regards

Reply ↓
Byron Bush on August 22, 2012 at 9:40 am said:

I’m willing to work with Alpha plugin for EM 12c. Please let me know how to make this happen. Thank you very much for your efforts. I know it can be a thankless job!

Reply ↓
Aletta Santos on October 26, 2012 at 6:42 am said:

Hi, how can an article describing the metrics monitored in MySQL Yeah, I’m having some critical alerts and do not know how to solve them.

Reply ↓
Pingback: Announcing MySQL Plugin 12.1.0.1.0 for Oracle Enterprise Manager 12c Cloud Control
Chris Slattery on January 25, 2013 at 10:53 am said:

Fixed a bug in the plugin. Alex there’s an issue when there’s an non-numeric value in MGMT$METRIC_DETAILS. The optimizer can choose an execution path that does an FTS, causing a 1722 error in the Commands and Executions page. Fixed temporarily by editing MGMT_IP_REPORT_ELEM_PARAMS to hack the driver script and added a NaN check. Now the Executions History is working OK !

Reply ↓
- Alex Gorbachev on January 25, 2013 at 5:06 pm said:
  
  Chris, can you give me the details? I’ll send you an email so you can email me directly.
  Thanks.
  
  Reply ↓
Hong on June 11, 2013 at 1:07 pm said:

Based on the datasheet for OEM11g with plug-in 1.1.2, you only support MySql 4.0,4.1, and 5.1. do you support MySql 5.5 and 5.6. also it mentioned it is planed to support MySql cluster. is any new plug-in for OEM 11g supporting cluster or newer version of MySQl?

Reply ↓
- Alex Gorbachev on June 11, 2013 at 2:09 pm said:
  
  It works with 5.5 and 5.6 (after some versions of 5.6 MySQL has to start with secure-auth disabled though). Cluster support is in the air as there hasn’t been anyone prepared to sponsor the development but if there is interest — ndb cluster support wouldn’t be a stretch.
  
  Reply ↓