Bug #73685 Advisor for version without premier support
Submitted: 22 Aug 2014 11:03 Modified: 9 Jan 2015 10:11
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Advisors/Rules Severity:S4 (Feature request)
Version:3.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: support

[22 Aug 2014 11:03] Daniël van Eeden 
Description:
MySQL 5.1 and earlier are not covered under Oracle Premier support. Please create an advisor to give a warning for versions without premier support.

http://www.mysql.com/support/eol-notice.html
http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf

How to repeat:
Check advisors

Suggested fix:
Advisor:
%mysqlversion% < THRESHOLD

Threshold:
Warning: 50500 (5.5)

Premier support: should be OK (currently: 5.5, 5.6)
Extended support: info alert (5.5 from dec 2018)
Sustaining: warning (currently: 5.1 and older)

Data collection item:
mysql:Server:server.version_numeric

A similar check should be made for ndb cluster, but there as far as I know there is not a numeric version data item for ndb. So one of the version% variables should be used for checking the ndb cluster version.
[22 Aug 2014 11:37] Daniël van Eeden 
Advisor rule

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: Unsupported_MySQL_major_version.xml (text/xml), 1.66 KiB.
[27 Aug 2014 10:14] Mark Leith 
Verifying, thanks for both the feature request, and contribution!