15.3 Customize MySQL Server Name

This section describes how to configure the display names of your monitored MySQL hosts.

Figure 15.2 Customize MySQL Server Name

Content is described in the surrounding text.

Table 15.2 Customize

Name Description

Name	Description
Show MySQL Server Names as:	Defines how hostnames are displayed. The following display settings are possible: Reported by Agent (default): the MySQL server names are displayed exactly as reported by the monitoring agent. Hostname only: only the host name is displayed, omitting suffixes such as `companyname.com`. Transformed by substitution expression: enables the Substitution Expression field. This enables you to replace some, or all, of the hostname with custom values.
Substitution Expression	Enables you to substitute your hostnames with custom values. These substitutions can be simple substitutions, or more complex regular expressions. The substitution expression is a name-value pair, with the original value, or regular expression on the left, and the substitution value on the right. You can include multiple, comma-separated, substitutions. For example: dx521\.example\.com=Staging dx984[.]example[.]com=Production database-server-(.*?)\.example\.com=$1 ^database-server-="", [.]example[.]com$="",dx521="Staging DB" More complex substitutions are possible by using a regular expression. For more information on the syntax used in these regular expressions, see Regular Expression Constructs.
Display Connection Endpoint Values	Defines how connection endpoint values are displayed. The following display settings are possible: Always (default): endpoint values are always displayed. Never: endpoint values are never displayed. For non-default values: endpoint values are displayed only if they differ from `3306` and `/tmp/mysql.sock`.

Show MySQL Server Names as:

Defines how hostnames are displayed. The following display settings are possible:

Reported by Agent (default): the MySQL server names are displayed exactly as reported by the monitoring agent.
Hostname only: only the host name is displayed, omitting suffixes such as companyname.com.
Transformed by substitution expression: enables the Substitution Expression field. This enables you to replace some, or all, of the hostname with custom values.

Substitution Expression

Enables you to substitute your hostnames with custom values. These substitutions can be simple substitutions, or more complex regular expressions. The substitution expression is a name-value pair, with the original value, or regular expression on the left, and the substitution value on the right.

You can include multiple, comma-separated, substitutions.

For example:

                
dx521\.example\.com=Staging
dx984[.]example[.]com=Production
database-server-(.*?)\.example\.com=$1
^database-server-="", [.]example[.]com$="",dx521="Staging DB"

More complex substitutions are possible by using a regular expression. For more information on the syntax used in these regular expressions, see Regular Expression Constructs.

Display Connection Endpoint Values

Defines how connection endpoint values are displayed. The following display settings are possible:

Always (default): endpoint values are always displayed.
Never: endpoint values are never displayed.
For non-default values: endpoint values are displayed only if they differ from 3306 and /tmp/mysql.sock.