{"id":1143,"date":"2016-01-31T11:07:19","date_gmt":"2016-01-31T09:07:19","guid":{"rendered":"http:\/\/www.ludovicocaldara.net\/dba\/?p=1143"},"modified":"2016-01-31T11:07:19","modified_gmt":"2016-01-31T09:07:19","slug":"mysql-plugin-em12c","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/mysql-plugin-em12c\/","title":{"rendered":"Configuring the MySQL Database Plug-In for Oracle Enterprise Manager 12c"},"content":{"rendered":"

I have blogged in the past about MySQL Enterprise Monitor 3.0<\/a> and I was quite happy at the very beginning, but after a while I have to admit that I was missing\u00a0many of the Oracle Enterprise Manager 12c features.<\/p>\n

In particular, MEM 3.0 does not have a usable database. In MEM all the tables are crypted and it is not possible to list, for example, all the targets monitored, nor it is possible via API or REST web services because MEM 3.0 lacks these features.<\/p>\n

What makes EM12c a GREAT product comparing to MEM, are many\u00a0features like blackouts<\/strong>, a usable command line interface (emcli<\/strong>), integrated reporting<\/strong>, scheduler<\/strong>, automatic groups<\/strong>… the list would be just huge.<\/p>\n

Luckily, Oracle has officially released a MySQL plugin for EM12c, provided that the EM is at least in version 12.1.0.4.<\/p>\n

So I’ve upgraded (a while ago) my customer’s EM12c to 12.1.0.5<\/a>. and decided to try the plugin.<\/p>\n

The first step is to download the last version of plugin for MySQL.<\/p>\n

I\u00a0can verify that you have the last version by going to<\/p>\n

Setup -> Extensibility -> Self-Update -> Plugins<\/strong>:<\/p>\n

\"2015-08-19<\/a><\/p>\n

The agent has been downloaded, but in order to make it available on the targets, I first need to deploy it on the management servers (2 OMSes in my case):<\/p>\n

\"2015-08-19<\/a><\/p>\n

Check\u00a0the plugin name and version:<\/p>\n

\"2015-08-19<\/a><\/p>\n

Verify the prerequisites check (here I have one column per OMS):
\n\"2015-08-19<\/p>\n

Specify the credentials for the Management Repository:
\n\"2015-08-19<\/a>Execute the deploy:<\/p>\n

\"2015-08-19<\/a>\u00a0 \u00a0 \u00a0If everything went OK, I’m able to check the status of the deployment:<\/p>\n

\"2015-08-19<\/a><\/p>\n

\"2015-08-19<\/a><\/p>\n

Now I can see that the plugin is correctly deployed on the OMSes, I can do the same for the agents:<\/p>\n

\"2015-08-19<\/a><\/p>\n

\"2015-08-19<\/a>I must select one by one the agents that run on the hosts\u00a0where I have MySQL running. I may select all agents as well, but it’s better to be neat…<\/p>\n

\"2015-08-19<\/a>again, there are prerequisite checks and confirmations:<\/p>\n

\"2015-08-19<\/a><\/p>\n

\"2015-08-19<\/a>The plugin deployment went well:<\/p>\n

\"2015-08-19<\/a><\/p>\n

\"2015-08-19<\/a>Now I can run the target discovery on the agent:<\/p>\n

\"2015-08-19<\/a><\/p>\n

But the discovery does not find my MySQL targets. What went wrong?<\/p>\n

\"2015-08-19<\/a>Each agent has a default list of “discovery modules”\u00a0\u00a0used for the discovery, but by default the MySQL one is not enabled after I install the plugin:<\/p>\n

\"2015-08-19<\/a>so it is necessary to activate it and deactivate\u00a0the discovery modules I do not need:<\/p>\n

\"2015-08-19<\/a>Tada! at the next discovery, I have my target available:<\/p>\n

\"2015-08-19<\/a>The target name is automatically set to hostname:mysqlport:<\/p>\n

\"2015-08-19<\/a>as all discovered targets, I need to promote it to have it available for monitoring with EM12c:<\/p>\n

\"2015-08-19<\/a>The target is available, now I\u00a0can use most of the EM12c features to monitor my MySQL environment.<\/p>\n

\"2015-08-19<\/a>HTH<\/p>\n

—<\/p>\n

Ludovico<\/p>\n","protected":false},"excerpt":{"rendered":"

I have blogged in the past about MySQL Enterprise Monitor 3.0 and I was quite happy at the very beginning, but after a while I have to admit that I was missing\u00a0many of the Oracle Enterprise Manager 12c features. In … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,132],"tags":[90,130,67,287],"class_list":["post-1143","post","type-post","status-publish","format-standard","hentry","category-mysql","category-triblog","tag-em12c","tag-mem3","tag-monitoring","tag-mysql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/1143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/comments?post=1143"}],"version-history":[{"count":4,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/1143\/revisions"}],"predecessor-version":[{"id":1268,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/1143\/revisions\/1268"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=1143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=1143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=1143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}