Documentation Home
MySQL Enterprise Monitor 3.2 Manual
Related Documentation Download this Manual

9.2 Tuning CPU

If both Apache Tomcat server and MySQL repository are installed on the same host, the best option within large scale environments is to move the MySQL Instance to its own host. This enables both processes to use up the resources of each host, and allows scaling to monitor hundreds of MySQL Instances and Hosts.

To do this, you should:

  1. Stop the application Apache Tomcat server and MySQL Instance.

  2. Copy the datadir contents to the new host (if moving to a fresh MySQL instance), or run mysqldump and import the dump into the new MySQL instance.

  3. Modify Tomcat's configuration to use the new MySQL Instance on the new host.

The configuration should be updated with the configuration tool (as it encrypts the password for the repository instance), this tool can be found at the following location:

Table 9.4 MEM repository configuration tool location (default)

Operating SystemPath
Microsoft WindowsC:\Program Files\MySQL\Enterprise\Monitor\bin\config.bat
Linux / Solaris/opt/mysql/enterprise/monitor/bin/config.sh
Mac OS X/Applications/mysql/enterprise/monitor/bin/config.sh

This Service Manager repository tool has the following options:

Option                   Description
------                   -----------
--accept-keystore-password, --akp    If specified, the user will be asked   
                                     the keystore password, otherwise the 
                                     password "changeit" will be used to  
                                     access the keystore 
--help                               Prints this usage message
--md, --mysql-db                     MySQL database for the Service Manager repository
--mp, --mysql-port                   MySQL port for the Service Manager repository
--ms, --mysql-server                 MySQL server for the Service Manager repository
--mu, --mysql-user                   MySQL username for the Service Manager repository
--new-install, --ni                  Generates a keystore with a fresh self-
                                     signed certificate for a new installation
--tbp, --tomcat-backup-path          Tomcat backup path to be used to       
                                     perform upgrade 
--upg, --upgrade                     Upgrades certificates on an existing   
                                     non OS X installation        
--upgo, --upgrade-osx                Upgrades keystore on an existing OS X                                     
-v, --version                        Displays the version of the agent and components

Updating MySQL Enterprise Service Manager Configuration

Option                   Description
------                   -----------

--md, --mysql-db                     MySQL database for the Service Manager repository
--mp, --mysql-port                   MySQL port for the Service Manager repository
--ms, --mysql-server                 MySQL server for the Service Manager repository
--mu, --mysql-user                   MySQL username for the Service Manager repository

To update the configuration, run the script in the following way:

shell> ./config.sh –mysql-server=[new host] –mysql-port=[new port] –mysql-user=[new user]
Important

The configuration script must be run by the same user as the MySQL Enterprise Service Manager.

You are prompted to enter the password for the new user, and the repository configuration is updated. Once finished, restart the Apache Tomcat server.

Updating Security Configuration

Option                   Description
------                   -----------
--accept-keystore-password, --akp    If specified, the user will be asked   
                                     the keystore password, otherwise the 
                                     password "changeit" will be used to  
                                     access the keystore 
--new-install, --ni                  Generates a keystore with a fresh self-
                                     signed certificate for a new installation
--tbp, --tomcat-backup-path          Tomcat backup path to be used to       
                                     perform upgrade 
--upg, --upgrade                     Upgrades certificates on an existing   
                                     non OS X installation        
--upgo, --upgrade-osx                Upgrades keystore on an existing OS X

User Comments
Sign Up Login You must be logged in to post a comment.