9.2 Tuning CPU

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

To do this, you should:

Stop the application Apache Tomcat server and MySQL Instance.
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.
Modify Tomcat's configuration to use the new MySQL Instance on the new host.

Update the configuration with the configuration tool. This tool can be found at the following location:

Table 9.4 Configuration utility location (default)

Operating System	Path
Microsoft Windows	`C:\Program Files\MySQL\Enterprise\Monitor\bin\config.bat`
Linux / Unix	`/opt/mysql/enterprise/monitor/bin/config.sh`
Mac OS X	`/Applications/mysql/enterprise/monitor/bin/config.sh`

For more information on the configuration utilities, see Chapter 10, Configuration Utilities.