MySQL discovery
Discovery can identify an instance of MySQL that is running on UNIX or Windows operating systems.
Requirements
Discovery searches for the MySQL configuration file location from the following areas:
- UNIX: Discovery searches for the MySQL configuration file location from the mysqld process, or port 3306.
- Windows: Discovery searches for the MySQL configuration file location from the mysqld.exe process, or port 3306.
--defaults-extra-file
--defaults-file
If the MYSQL configuration file location is not found from that search, then the following
occurs:
- UNIX: The configuration file location defaults to /etc/my.cnf.
- Windows: No default configuration file location exists, and the probe to read the configuration file location is skipped.
Remarque :
For information on Probe to Pattern migration see the knowledge article KB0694477.
Credentials
Configure these credentials:
- Windows credentials
- SSH credentials
- Applicative credentials (When
applications require credentials in addition to the credentials the that host
machine requires.)Remarque :There’s no need to configure applicative credentials unless your Discovery prerequisites mention them.
For a list of privileged commands that you need for Discovery and Service Mapping, see Service Mapping commands requiring a privileged user. This list includes commands that require elevated rights to discover and map Unix-based hosts in your organization.
Classifiers, patterns, and probes
Discovery uses these classifiers, probes, and patterns for MySQL discovery:
| Classifier | Trigger probes | Pattern |
|---|---|---|
| MySQL Server |
|
My SQL server On Windows and Linux Pattern |
*For new instances, these probes are inactive on the classifier. Discovery uses patterns for discovery.
To use patterns, verify that the correct pattern is specified in the horizontal pattern probe on the classifier. See Add the Horizontal Pattern probe to a classifier for instructions.
Data collected
Discovery populates these fields in the MySQL Instance [cmdb_ci_db_mysql_instance]
table:
| Label | Field name | Source |
|---|---|---|
| MySQL configuration | myconf | my.cnf |
| TCP port(s) | tcp_port | running_process |
| Version | version | mysqld |