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.
For each process, the following process parameters are explored in the following order:

--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.

Credentials

Configure these credentials:
Credential type
Applicative credentials
Windows credentials
SSH credentials

Classifiers and probes

Discovery uses these classifiers, probes, and patterns for MySQL discovery:
Classifier Trigger probes
MySQL Server
  • Powershell-Windows - MySQL Configuration
  • SSHCommand-MySQL - Configuration
  • SSHCommand-MySQL - Version
  • WMIRunner-Windows - MySQL Version
Table 1. Data collected
Label Table Name Field Name Source
MySQL configuration cmdb_ci_db_mysql_instance myconf my.cnf
TCP port(s) cmdb_ci_db_mysql_instance tcp_port running_process
Version cmdb_ci_db_mysql_instance version mysqld