安装MySQL Enterprise Monitor

笑吧傻瓜 2018-04-24

展开全文

原创安装MySQL Enterprise Monitor

Kevin_ora 2015.07.29 阅 1627

对于MySQL的监控工具，市面上有很多种，这里介绍怎么安装MySQL Enterprise Monitor，官方提供的工具，安装记录不详细解释，记录如下:

[root@ora11g soft]# ./mysqlmonitor-3.0.22.3178-linux-x86_64-installer.bin Language SelectionPlease select the installation language[1] English - English[2] Japanese - —￥èaPlease choose an option [1] : 1Info: During the installation process you will be asked to enter usernames and passwords for various pieces of the Enterprise Monitor. Please be sure to make note of these in a secure location so you can recover them in case they are forgotten.Press [Enter] to continue :----------------------------------------------------------------------------Welcome to the setup wizard for the MySQL Enterprise Monitor----------------------------------------------------------------------------Please specify the directory where the MySQL Enterprise Monitor will be installedInstallation directory [/opt/mysql/enterprise/monitor]: ----------------------------------------------------------------------------Select RequirementsSelect RequirementsPlease indicate the scope of monitoring this installation will initially encompass so we can configure Tomcat and MySQL memory usage accordingly. The manual contains instructions for updating the configuration later, if needed. This installation will monitor a:System Size[1] Small system: No more than 5 to 10 MySQL Servers monitored from a laptop computer or low-end server with no more than 4 GB of RAM[2] Medium system: Up to 100 MySQL Servers monitored from a medium-size but shared server with 4 GB to 8 GB of RAM[3] Large system: More than 100 MySQL Servers monitored from a high-end server dedicated to MEM with more than 8 GB RAMPlease choose an option [2] : 2----------------------------------------------------------------------------Tomcat Server OptionsPlease specify the following parameters for the bundled Tomcat ServerTomcat Server Port [18080]: Tomcat SSL Port [18443]: ----------------------------------------------------------------------------Service Manager User AccountYou are installing as root, but it's not good practice for the Service Manager to run under the root user account. Please specify the name of a user account to use for the Service Manager below. Note that this user account will be created for you if it doesn't already exist.User Account [mysqlmem]: mysql----------------------------------------------------------------------------Database InstallationPlease select which database configuration you wish to use[1] I wish to use the bundled MySQL database[2] I wish to use an existing MySQL database *Please choose an option [1] : 2* We will validate the version of your existing MySQL database server during the installation. See documentation for minimum version requirements.Important: MySQL Enterprise Monitor 2.3 and 3.0 cannot share a Repository. If you're not using the bundled Repository and will be running both versions in your environment, you must set up and maintain separate repositories for them.Visit the following URL for more information:http://dev./doc/mysql-monitor/3.0/en/mem-install-server.html----------------------------------------------------------------------------Repository ConfigurationPlease specify the following parameters for the existing MySQL serverRepository Username [service_manager]: rootPassword :Re-enter :MySQL Hostname or IP address [localhost]: MySQL Database Port [3306]: MySQL Database Name [mem]: Use SSL when connecting to the database [y/N]: yWarning: SSL is not enabled in the existing MySQL server. Please either uncheck the SSL option or manually enable SSL in the MySQL server before continuing.Press [Enter] to continue :----------------------------------------------------------------------------Repository ConfigurationPlease specify the following parameters for the existing MySQL serverRepository Username [root]: Password :Re-enter :MySQL Hostname or IP address [localhost]: MySQL Database Port [3306]: MySQL Database Name [mem]: kevinUse SSL when connecting to the database [Y/n]: n----------------------------------------------------------------------------Setup is now ready to install MySQL Enterprise Monitor on your computer.Do you want to continue? [Y/n]: ----------------------------------------------------------------------------Please wait while Setup installs MySQL Enterprise Monitor on your computer. Installing 0% ______________ 50% ______________ 100% #########################################----------------------------------------------------------------------------Completed installing filesSetup has completed installing the MySQL Enterprise Monitor files on your computer (errors were found during the installation process).Uninstalling the MySQL Enterprise Monitor files can be done by invoking:/opt/mysql/enterprise/monitor/uninstallTo complete the installation, launch the MySQL Enterprise Monitor UI and complete the initial setup. Refer to the readme file for additional information and a list of known issues.Press [Enter] to continue :----------------------------------------------------------------------------Completed installing filesWARNING: To improve security, all communication with the Service Manager uses SSL. Because only a basic self-signed security certificate is included when the Service Manager is installed, it is likely that your browser will display a warning about an untrusted connection. Please either install your own certificate or add a security exception for the Service Manager URL to your browser. See the documentation for more information.http://dev./doc/mysql-monitor/3.0/en/mem-install-server.htmlPress [Enter] to continue :----------------------------------------------------------------------------Setup has finished installing MySQL Enterprise Monitor on your computer.View Readme File [Y/n]: READMEMySQL Enterprise Monitor - http://www./monitoring----------------------------------------------------------------------Version 3.0.22.3178----------------------------------------------------------------------This is a release of MySQL Enterprise Monitor. For the avoidance ofdoubt, this particular copy of the software is released under acommercial license and the GNU General Public License does not apply.MySQL Enterprise Monitor is brought to you by Oracle.Copyright (c) 2005, 2015, Oracle and/or its affiliates. All rightsreserved.This distribution may include materials developed by third parties.For license and attribution notices for these materials, please referto the documentation that accompanies this distribution (see the'Licenses for Third-Party Components' appendix) or view the onlinedocumentation at: http://dev./doc/mysql-monitor/3.0/en/index.html.Welcome to the MySQL Enterprise Monitor. This README file containsthe following sections:Press [Enter] to continue : GETTING STARTED IMPORTANT INSTALL & CONFIGURATION CHANGES FROM EARLIER VERSIONS INSTALLATION UPGRADE NOTES REPORTING ISSUES & FEEDBACKFor more information about the MySQL Enterprise Monitor (MEM), referto the helpful tooltips in the MEM UI, or read the completedocumentation that can be downloaded from the same place youdownloaded the package containing this README file, or read thedocumentation online at: http://dev./doc/mysql-monitor/3.0/en/index.html----------------------------------------------------------------------GETTING STARTED----------------------------------------------------------------------IMPORTANT: If you're performing an upgrade, make sure to read thecomplete documentation for important guidance on doing so safely.If you're doing a new installation, here are basic steps:Press [Enter] to continue : (1) Download, install and launch the Service Manager (2) Open the UI in your browser (3) Complete configuration using the UI's first-time setup screen (4) Install one Agent on each additional Host you will monitor (optional, but highly recommended)If you will be monitoring a large number of hosts and/or MySQLInstances, see the complete documentation for guidance on tuning Agentand Service Manager settings.----------------------------------------------------------------------IMPORTANT INSTALL & CONFIGURATION CHANGES FROM EARLIER VERSIONS----------------------------------------------------------------------We recommend installing a single Agent on each host system you wish tomonitor. New in this release, a newly-installed Agent will begincollecting local CPU, memory, file system, and other OS-related data whether or not the Agent has also been configured to monitor a MySQLInstance at install time. The Agent will also look for running MySQLprocesses and report them as unmonitored in the UI. You can ignore oradd monitoring connections to them on the MySQL Instances Dashboard.(Process discovery is not currently supported on Windows.)Press [Enter] to continue :The Service Manager now includes a built-in Agent that automaticallycollects OS-related data (including unmonitored MySQL processes) fromits own host and also monitors the MySQL Repository that MEM uses tostore data it collects from your monitored systems.In another change from earlier versions, we strongly recommendinstalling only one Agent per host with this release regardless of howmany MySQL Instances you have running on that host. To conserveresources on monitored hosts, the 3.0 Agent is, by default, configuredto monitor approximately 5-10 MySQL Instances (actual number varieswith system load and performance). See the complete documentation forguidance on tuning the Agent's settings, allowing it to monitor manyadditional instances of MySQL.Finally, note that SSL is now required as follows:* HTTP requests to the 3.0 UI now redirect to a secure port (and may generate an 'untrusted site' warning in your browser, see complete documentation for details).* 3.0 Agents always use a secure connection when communicating with the Service Manager. For backwards compatibility, SSL is still optional (but recommended) for 2.3 Agents connecting to the 3.0Press [Enter] to continue : Service Manager.----------------------------------------------------------------------INSTALLATION----------------------------------------------------------------------WARNING - Before you install:* Make sure to retain and securely store a written copy of all login credentials that you specify throughout the installation and configuration process. For security reasons, there is no way to recover forgotten passwords, and the configuration reports no longer include credential information.* MEM stores data it collects from your monitored systems in a MySQL database instance ('Repository'). The Service Manager installer will optionally install and manage its own 'Bundled' Repository, or you can direct the installer to utilize a MySQL Instance you already maintain. MEM 3.0 and earlier versions *cannot* share a common Repository; if you're not using the bundled Repository and will be running MEM 3.0 in parallel with an earlier version, set up and maintain separate Repositories for each of them. (See the complete documentation for more information, including minimum MySQL version managing the Repository.)Press [Enter] to continue :* Refer to the complete documentation if you're performing an upgrade.Service Manager:----------------Execute the MEM Service Manager Installer that you downloaded from oracle.com and follow the prompts.After the Installer exits, load the UI to complete the installation and initial configuration process. If you installed on localhost usingthe default ports, the URL to the UI would look like this: https://localhost:18443/Setup.actionYou will use the Manager credentials you specify here to login to theUI and will provide the Agent user and password when you installadditional Agents.Agent:------Several differences from the 2.3 Agent installation are worth noting(see the documentation for more details):Press [Enter] to continue : - Multiple MySQL user accounts with different privilege levels (Admin, General, Limited) are now defined and used by the Agent - Groups play a central role in the new UI and can optionally be assigned at Agent install-time - The old Agent .ini files (mysql-monitor-agent.ini and agent-instance.ini) are no longer supported - Passwords in the .ini file are now stored in encrypted form - The Service Manager now includes a built-in Agent (described above) - The MySQL Proxy and Aggregator are no longer bundled with the Agent installer. See the complete documentation for guidance if you will continue to use them with MEM 3.0.Performance Tuning MEM for your environment-------------------------------------------Customizing Tomcat and MySQL configuration can make a dramatic difference to MEM's performance. Consult the complete documentationfor more information.Consult the Troubleshooting sections of the online documentation ifany of these occur: - You have trouble starting your Agent - The Agent starts but doesn't show up in the UIPress [Enter] to continue : - You're using the Query Analyzer but no results are shown on the Query Analyzer page (wait at least 10 minutes after startup)Contact Support at https://support.oracle.com/ if you have problemsor need help tuning MEM for your environment.If you are upgrading from a previous version, see the UPGRADE NOTESbelow.Note that the source code for the LGPL components used in the ServiceManager can be found in the licenses/lpgl directory.----------------------------------------------------------------------UPGRADE NOTES----------------------------------------------------------------------WARNING! MySQL Enterprise Monitor 3.0 has entirely differentinventory, instrument data, Query Analyzer, Advisor configuration, andnotification models from 2.3. Consider installing 3.0 in parallel withyour production 2.3 system instead of performing an upgrade. Historydata for Events, Graphs, Query Analysis, and configuration data forAdvisor schedules are not migrated.Press [Enter] to continue :Before you attempt an upgrade, make sure to see the guidance providedin the complete documentation with this package or go to: http://dev./doc/mysql-monitor/3.0/en/mem-upgrading-3.0.htmlWe strongly recommend that you backup your existing Repository beforeproceeding with an upgrade. If you are not using the bundledRepository, back up your self-managed Repository data prior to runningthe update installer on the Service Manager. Depending on the size ofyour Repository, a backup can take a lot of time and disk space. See'Backing up MySQL Enterprise Service Manager' in the completedocumentation for details.----------------------------------------------------------------------REPORTING ISSUES & FEEDBACK----------------------------------------------------------------------To report a problem, get help with an issue or provide product feedback, login to https://support.oracle.com/. Generally, it's better to create a separate issue for each problem you're reporting.Do not hesitate to file a Support issue if you need help tuning MEM toPress [Enter] to continue :monitor a large number of hosts and MySQL instances.If you'd like to participate in a future beta test of MEM, contactSupport, your Sales Representative or your Sales Engineer.Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development TeamCopyright ? 2005, 2015, Oracle and/or its affiliates. All rights reserved.This software and related documentation are provided under a licenseagreement containing restrictions on use and disclosure and areprotected by intellectual property laws. Except as expressly permittedin your license agreement or allowed by law, you may not use, copy,reproduce, translate, broadcast, modify, license, transmit,distribute, exhibit, perform, publish, or display any part, in anyform, or by any means. Reverse engineering, disassembly, ordecompilation of this software, unless required by law forinteroperability, is prohibited.If this software or related documentation is delivered to the U.S.Government or anyone licensing it on behalf of the U.S. Government,Press [Enter] to continue :the following notice is applicable:U.S. GOVERNMENT RIGHTS Programs, software, databases, and relateddocumentation and technical data delivered to U.S. Governmentcustomers are 'commercial computer software' or 'commercial technicaldata' pursuant to the applicable Federal Acquisition Regulation andagency-specific supplemental regulations. As such, the use,duplication, disclosure, modification, and adaptation shall be subjectto the restrictions and license terms set forth in the applicableGovernment contract, and, to the extent applicable by the terms of theGovernment contract, the additional rights set forth in FAR 52.227-19,Commercial Computer Software License (December 2007). Oracle USA,Inc., 500 Oracle Parkway, Redwood City, CA 94065.This software is developed for general use in a variety of informationmanagement applications. It is not developed or intended for use inany inherently dangerous applications, including applications whichmay create a risk of personal injury. If you use this software indangerous applications, then you shall be responsible to take allappropriate fail-safe, backup, redundancy, and other measures toensure the safe use of this software. Oracle Corporation and itsaffiliates disclaim any liability for any damages caused by use ofthis software in dangerous applications.Press [Enter] to continue :Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respective owners.This software and documentation may provide access to or informationon content, products, and services from third parties. OracleCorporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-partycontent, products, and services. Oracle Corporation and its affiliateswill not be responsible for any loss, costs, or damages incurred dueto your access to or use of third-party content, products, orservices.Press [Enter] to continue :Info: To configure the MySQL Enterprise Monitor please visit the following page: https://localhost:18443Press [Enter] to continue :[root@ora11g soft]#

对于MySQL的监控工具，市面上有很多种，这里介绍怎么安装MySQL Enterprise Monitor，官方提供的工具，安装记录不详细解释，记录如下: