Oracle EM 12C monitoring MySQL

Oracle EM 12C monitoring MySQL

[Preface] Oracle EM 12C itself does not provide MySQL monitoring. The plug-in can be used to monitor the database on EM 12C. Pythian Group developed the corresponding plug-ins, by installing this plug-in, you can monitor MySQL;

Note: The Pythian group is a well-known Oracle database service support and consultancy. It is headquartered in Ottawa, Canada and has offices in the United States, Europe, India and Australia, manages 718 production databases for 56 Oracle customers.

[1] Introduction to the plug-in itself, you can click the link here to view.

[2] download the plug-in: Click Here (You can also download the plug-in from the help house resource site)

------------------------------------------ Split line ------------------------------------------

Free in http://linux.bkjia.com/

The username and password are both www.bkjia.com

The specific download directory is in/July 6, 2015,/July 5, May,/Oracle EM 12C, monitoring MySQL/

For the download method, see

------------------------------------------ Split line ------------------------------------------

[3] plug-in Installation

3.1 preparations: JDK1.6 needs to be installed on the server

3.2 upload the file to the directory defined by oms: settings-Pre-configuration and patching-software library to view the location of the uploaded file

3.3 run emcli: emcli setup-url = https: // hostname: 7301/em-username = sysman on the server

3.4 upload plug-in: emcli import_update-omslocal-file = D: \ patching \ 12.1.0.1.2 _ pythian. mysql. prod_2000_0.opar

[4] deploy the plug-in as follows:

4.1 set-> scalability-> plug-in-> database, right-click Pythian MySQL Plugin, deploy location-> Manage Server, and then deploy it. The entire process is completed in about 30 minutes.

4.2 install plug-ins on the client

/Tmp/logs/archives/agentDeploy. sh OMS_HOST = hostname EM_UPLOAD_PORT = 4889 bytes = oracle123 bytes =/data/agent AGENT_PORT = 1833 B _startAgent = true ORACLE_HOSTNAME = hostname AGENT_BASE_DIR =/data

4.3 add mysql monitoring on EM 12C as follows:

Set-Add a target-manually add a target-Add a non-host target by setting a target monitoring attribute

4.4 Add a MySQL Instance

4.5 On the MySQL monitoring page, choose MySQL from enterprise> overview>