Edit file /opt/mysql/enterprise/agent/etc/mysql-monitor-agent.In the DB-server the Enterprise Monitor Agent needs to be reconfigured to send information to a new Service Manager.opt/mysql/enterprise/monitor/mysql/bin/mysql -u service_manager -p -P13306 -h 127.0.0.1 Restore of data into the new server using command like:.Mysqldump -single-transaction -uservice_manager -p -P13306 -h127.0.0.1 mem > mem.dump Backup of the data as described in the doc:.I chose not to configure anything and ended the installation there.Setup has finished installing MySQL Enterprise Monitor on your computer. Without an Agent installed for each MySQL server you’ll never see any data. The Service Manager is simply the web front end for visualising the results, it’s the Agent that gathers the data. Fresh installation of Service Manager in the new server The software comes in two separate packages the MySQL Service Manager and the Agent.In the doc they manage to describe how to back things up, but not really how to restore anything. Backing up MySQL Enterprise Service Manager in the MySQL documentation. Learn more about bidirectional Unicode characters. To review, open the file in an editor that reveals hidden Unicode characters. The only really relevant information I could find is B.5. Bash script to install MySQL Enterprise Monitor Service Manager 3.x in Enterprise Linux 7.x Raw provision-memservicemanager-el7.sh This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. In the entire Internet, there is no spot-on information about how to do it in detail. This time it moving other roles out of the way was piece-of-cake, except the Service Manager. Sometimes there is a need to upgrade servers. At least I'd like to give my DB-box all the possible resources, I'm running the Service Manager -part in another server. Note that remote monitoring does not collect OS information, see the online documentation for more information.MySQL Enterprise Monitor is a really good tool to see what's going on in the DB. * To monitor MySQL Instances running on unsupported platforms, monitor remotely using the built-in Agent. Disk I/O subsystem applicable for a write-intensive database installation (RAID 10, RAID 0+1).Recommended System Requirements: (if monitoring 100 or more MySQL servers): Disk I/O subsystem applicable for a write-intensive database installation.Microsoft Windows Server 2012 R2 and later Oracle Linux, RHEL, CentOS, SUSE, Debian, Ubuntu, Fedora For further details, please contact the MySQL Sales Team. MySQL supports deployment in virtualized environments, subject to Oracle KM Note 249212.1. Supported Platforms: MySQL Enterprise Monitor
0 kommentar(er)
