MySQL Enterprise Monitor 8.0 Release Notes
Note
The parameters listed here, with the exception of the four repository connection parameters, correspond to those displayed on theWelcome to MySQL Enterprise Monitorpage used for initial setup. For more information, see13.1节,“初始登录”.
Important
These parameters enable you to configure MySQL Enterprise Service Manager from script or command line and should only be run while the MySQL Enterprise Service Manager is stopped.
Theconfig.sh/config.batscript is used to configure the MySQL Server Repository for the Service Monitor. Its default location is as follows:
Table 10.1 Default Location of Agent Configuration Utility
| Operating System | File Location |
|---|---|
Microsoft Windows |
|
UNIX/Linux |
|
Mac OS X |
|
Use--helpto view the options.
The Service Manager configuration utility contains the following sets of commands:
Service Manager Configuration Utilities: define or change the configuration of MySQL Enterprise Service Manager.
Service Manager Certificate Utilities: modify or upgrade MySQL Enterprise Service Manager SSL certificates.
Theconfigscript enables you to define or change any of the system configuration parameters such as credentials used to connect to the repository, proxy connection details, and MySQL Enterprise Service Manager user credentials.
Table 10.2 Service Manager Configuration Utilities
| Name | Description |
|---|---|
|
MySQL username for the Service Manager repository. The password is requested via STDIN when the command is run. The default value is |
|
MySQL port for the Service Manager repository. The port the target MySQL server listens on. The default is 13306. |
|
MySQL database for the Service Manager repository. The name of the database used for the repository. The default is |
|
MySQL server for the Service Manager repository. This must be a resolvable name or IP address of the server where the MySQL instance is running. |
|
Checks your repository to ensure compatibility with MySQL Enterprise Service Manager. For more information on the checks performed, seeSection 3.2.4, “MySQL Enterprise Monitor Repository”. |
|
Runs |
|
Base directory of the local MySQL installation. |
|
Service Manager manager username. The user defined here is added to the manager role. |
|
Service Manager agent username. The user defined here is added to the agent role. |
|
Enable automatic checking for online updates. |
|
Defines the Query Analyzer data retention policy. Query Analyzer data older than the number of days defined here is deleted. Default is 28 days. |
|
Defines the historical data retention policy. Historical data older than the number of days defined here is deleted. Default is 28 days. |
|
HTTP Proxy host. |
|
HTTP Proxy port. |
|
HTTP Proxy username. |
Important
Passwords are always requested via STDIN and are requested in the order manager, agent, and proxy, regardless of the order in which they are defined on the command line or in script.
The following example instructs MySQL Enterprise Service Manager to use a locally installed instance, listening on port 3306, thememdatabase, and connect using the userservice_manager.:
config.sh --mysql-server=localhost --mysql-port=3306 --mysql-db=mem --mysql-user=service_managerThe following is an example of a basic setup, defining the admin and agent users, only. :
config.sh --sm-admin-user=admin --sm-agent-user=agentAll other parameters are set to their default values.
Important
You are prompted to define passwords for each of the users defined. Passwords are only accepted through STDIN.
Passwords are always requested in the order manager, agent, proxy, regardless of the order defined on the command line or in the script.
All other values are set to their defaults.
The following is an example of a complete setup, defining all available options:
config.sh --sm-admin-user=admin --sm-agent-user=agent --purge-quan=7 --purge-data=14 --proxy-host=localhost --proxy-port=9190 --proxy-user=proxy --auto-updateThe certificate utilities enable you to modify, renew, import, and upgrade your SSL certificates.
Important
It is strongly recommended you use this utility to modify your SSL certificates and not attempt to modify them with any other tool.
Table 10.3 Service Manager Certificate Utilities
| Name | Description |
|---|---|
|
Tomcat backup path to be used to perform upgrade |
|
Upgrades certificates on non-OS X platforms. That is, Microsoft Windows, Linux, and so on. |
|
Upgrades certificates on OS X platforms. |
|
Generates a keystore with a new self-signed certificate for a new installation |
|
If specified, the user is prompted to enter the keystore password. If not specified, the default password |
|
Renew an existing, self-signed certificate. If the certificate is not self-signed, an error is returned. |
|
Imports the specified certificate. For example:
|
|
Imports the specified private key. For example:
|