Hacker's ramblings

MySQL Enterprise Monitor is a really good tool to see what's going on in the DB. At least I'd like to give my DB-box all the possible resources, I'm running the Service Manager -part in another server.

Sometimes there is a need to upgrade servers. This time it moving other roles out of the way was piece-of-cake, except the Service Manager. In the entire Internet, there is no spot-on information about how to do it in detail. The only really relevant information I could find is B.5. Backing up MySQL Enterprise Service Manager in the MySQL documentation. In the doc they manage to describe how to back things up, but not really how to restore anything.

I did the operation in following steps:

1. Fresh installation of Service Manager in the new server
• I chose not to configure anything and ended the installation there
2. Backup of the data as described in the doc:
   mysqldump --single-transaction -uservice_manager -p -P13306 -h127.0.0.1 mem > mem.dump
   
3. Restore of data into the new server using command like:
   /opt/mysql/enterprise/monitor/mysql/bin/mysql -u service_manager -p -P13306 -h 127.0.0.1
   
4. In the DB-server the Enterprise Monitor Agent needs to be reconfigured to send information to a new Service Manager
1. Edit file /opt/mysql/enterprise/agent/etc/mysql-monitor-agent.ini
2. Confirm value of agent-mgmt-hostname
   
3. Confirm value of aggr-mem-baseurl
   
5. After these changes a login to the newly setup Service Manager showed the DB as fully functional
   

Hope this helps somebody.