If you want to backup the data stored within your MySQL Enterprise Service Manager, you can use any of the typical backup solutions, such as
mysqldump, to save your data. All you need to backup the information is host name, user name and password details that were set during the installation of the MySQL Enterprise Service Manager
You can locate this information by examining the contents of the
configuration_report.txtfile that was generated when MySQL Enterprise Service Manager was installed. A scample of the file is provided below:
MySQL Enterprise Monitor (Version 126.96.36.19988 : 20081031_152749_r7088) Here are the settings you specified: Application hostname and port: http://127.0.0.1:18080 Tomcat Ports: 18080 - 18443 (SSL) MySQL Port : 13306 Repository Credentials (bundled MySQL): --------------------------------------- service_manager/Password Use the following command to login to the MySQL Enterprise Monitor database: mysql -uservice_manager -pPassword -P13306 -h127.0.0.1
The last line provides the information about how to connect to the server using the standard mysql command line client.
All the MySQL Enterprise Monitor repository information, including your configuration, rule and historical data is stored within the
To backup this information using
mysqldumpyou might use the following command:
shell> mysqldump --single-transaction » -uservice_manager -pPassword -P13306 -h127.0.0.1 mem >mem.dump
The above command would create a file,
mem.dump, containing all of the MySQL Enterprise Monitor data.
To ensure consistency in a recovery situation, you may also want to backup the agent configuration and metadata stored on each monitored MySQL server. To do this:
Backup the configuration files of each agent. You should keep a copy of the
etcdirectory for each agent. This directory contains the main configuration file,
mysql-monitor-agent.ini, and the configuration information for each server being monitored, which is stored within the
On each server being monitored, retain a copy of the
mysql.inventorytable, which contains the unique ID of the MySQL server.