Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.

MySQL discovery

Log in to subscribe to topics and get notified when content changes.

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.
Warning: DO NOT switch from probes to patterns if you are already running Discovery with probes, and your CMDB is already populated. If you do so, it is possible that the pattern Discovery process does not synchronize on the same values that the probe Discovery process does. This could result in duplicate CIs in your CMDB.

Credentials

Configure these credentials:

For a list of privileged commands that you need for Discovery and Service Mapping, see Service Mapping commands requiring a privileged user for a list of the 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
  • Horizontal Pattern: launches patterns
  • Windows - MySQL Configuration*
  • Windows - MySQL Version*
  • MySQL - Configuration*
  • MySQL - Version*
My SQL server On Windows and Linux Patte

*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
Feedback