Documentation Home
MySQL Enterprise Monitor 2.3 Manual
Related Documentation Download this Manual
PDF (US Ltr) - 4.0Mb
PDF (A4) - 4.0Mb
EPUB - 3.2Mb
HTML Download (TGZ) - 3.1Mb
HTML Download (Zip) - 3.1Mb

MySQL Enterprise Monitor 2.3 Manual  /  ...  /  Service Manager Installation Common Parameters

5.2.1 Service Manager Installation Common Parameters

All installations of the Service Manager install the Tomcat and MySQL applications using the same basic set of parameters. Although the defaults provided by the installation process are designed not to interfere with existing installations of either product, check these parameters before installation to ensure that you do not experience any problems.

A value must be assigned to all settings that are defined in the configuration file. This is different than passing these settings into the command-line, which may default to true when not passing in a value. Glib is used for option handling, and specifically g_key_file_get_boolean() to parse boolean values. This means that false and 0 represent boolean false, whereas true and 1 represent boolean true. For example:

Passing a value to may look like this:


Or to the command-line, like either of these:

    $ ./mysqlmonitor-installer.bin --log-use-syslog
    $ ./mysqlmonitor-installer.bin --log-use-syslog 1

The common parameters are divided into those applying to the location of the MySQL server, the Tomcat server, and the connection properties for the MySQL server (Repository Configuration):

  • Tomcat Server Options

    • Tomcat Server port: The default port that the Tomcat server uses when listening for connections. If you change this option, make the same change to the equivalent port number specified during the Agent installation. The default value is 18080.


      If you do not have a web server running on port 80, you can use this well-known port rather than 18080. Since port 80 is the default for a web server, you can then open the dashboard without specifying a port.

    • Tomcat Shutdown port: The port used by the management scripts that is used to shut the Tomcat server down when you need to stop the Service Manager. The default value is 18005.

    • Tomcat SSL Port: The standard port used to connect to the Service Manager when you want to use Secure Sockets Layer (SSL) encrypted communication. The default value is 18443.

  • MySQL Server selection

    • Using the bundled MySQL Server is preferred, but you may also choose to use your own MySQL Server to store repository data for the MySQL Enterprise Service Manager. The MySQL Server can be located on the same machine as the MySQL Enterprise Service Manager, or on a different machine. If you use your own MySQL Server, it must already be running when you start the installer.


      Configuring the MySQL Enterprise Service Manager repository to use a database that you plan to monitor will be problematic, because the MySQL Enterprise Service Manager statistics will interfere with your setup. Using the same host will function normally, although some monitored statistics are host specific.

      The requirements for the MySQL Server are:

      • MySQL 5.1.43 or higher.

      • Partitioning enabled.

      • InnoDB Storage Engine enabled. MySQL Enterprise Monitor operation relies on the InnoDB-related configuration options being set high enough to handle the monitoring traffic. For example, the bundled MySQL server includes the settings:

        innodb_buffer_pool_size = 512M
        innodb_log_file_size = 256M
        innodb_flush_log_at_trx_commit = 2
        innodb_support_xa = 0
        innodb_max_dirty_pages_pct = 20
        innodb_locks_unsafe_for_binlog = 1

        Using too-low settings for the repository data could result in errors such as Session is closed! in the Tomcat log file.

      Configure the MySQL server with suitable credentials to allow MySQL Enterprise Service Manager to create the database, tables and other settings. The user should have ALL privileges on the MySQL Enterprise Monitor repository, which is stored within the database mem, or you can provide full access to all tables. Also, ensure you have the GRANT OPTION. For example, you might create a suitable user using the following GRANT statement:

      mysql> GRANT ALL PRIVILEGES ON *.* TO 'service_manager'@'localhost' 
          -> IDENTIFIED BY 'password' WITH GRANT OPTION 
  • Repository Configuration (MySQL Server)

    • Repository Username — if you are connecting to an existing MySQL database, specify the username and password that you configured with access to the MySQL Enterprise Monitor repository. If you install the bundled MySQL database, choose a username and password for the MySQL Enterprise Service Manager, and that user is created automatically during installation. In normal use, you do not need to access the repository database directly, but it might be required to resolve a service request. The default value is service_manager.

    • Repository User password — the password to use to connect to the MySQL database. Set it to a secure password so that the repository data is secure.

    • Use SSL when connecting to the database — adds a line mysql.use_ssl=true to the file. The repository database must be configured for SSL connections, as described in Building MySQL with SSL Support. You can add this line yourself to enable SSL connections after installation. You can also manually add any of the following items to to customize the SSL connections to the repository database:

      mysql.verify_server_cert (default is false)
      mysql.trust_cert_keystore_url (no default)
      mysql.trust_cert_keystore_type (no default)
      mysql.trust_cert_keystore_password (no default)
      mysql.client_cert_keystore_url (no default)
      mysql.client_cert_keystore_type (no default)
      mysql.client_cert_keystore_password (no default)

      These items correspond to similarly-named JDBC connection properties that are described in Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J.

The information that you configure during installation is recorded within the configuration_report.txt file within the installation directory for the Service Manager, with any passwords obscured. (Thus, be sure to record all passwords that you specify during the installation process.)

Download this Manual
PDF (US Ltr) - 4.0Mb
PDF (A4) - 4.0Mb
EPUB - 3.2Mb
HTML Download (TGZ) - 3.1Mb
HTML Download (Zip) - 3.1Mb
User Comments
Sign Up Login You must be logged in to post a comment.