Chapter 19 Advisors Configuration

Note

MySQL Enterprise Monitor is available as part of the MySQL Enterprise subscription, learn more at http://www.mysql.com/products/.

MySQL Enterprise Advisors gather information from your MySQL Instances via the Agent, analyze that information, and then offer advice, create Events, and provide Graphs and Reports when necessary.

Figure 19.1 MySQL Enterprise Monitor User Interface: Advisors

MySQL Enterprise Monitor User Interface: Advisors

General Advisor Control

This section is available at the top and at the bottom of the page. It contains seven buttons that let you:

Advisors Categories

The MySQL Enterprise Advisors are classified under the following categories:

An Advisor Category groups a set of Advisors that are designed to enforce MySQL best practices for that specific category.

Advisors Listing Table

Each Advisor Category panel contains a table listing of Advisors in that category. This table is a "tree-table", showing the hierarchy of Monitoring Assets. The row containing the Advisor itself represents a "global" scope: the Advisor being evaluated for every appropriate type of Asset in your entire monitored infrastructure. If you expand the "global" scope, underneath are all defined Groups. Expanding each Group displays the appropriate type of Monitored Assets in that Group (MySQL Instances, Hosts, Agents, etc.). Advisors can be configured against nodes in this hierarchy to represent overrides.

For example, while all Advisors are scheduled "globally" by default, you might want to have different Advisor thresholds for MySQL Instances in hypothetical "Dev" and "Production" Groups. Furthermore, if you had an MySQL Instance in the "Dev" group that had exceptional demands due to, say, a load test, you could then configure the Advisor to have different thresholds just for that one Instance. As well, Advisors can be Disabled for any node or sub-tree in the hierarchy.

The table is divided by six columns:

An advisor category provides a set of rules designed to enforce MySQL best practices for that specific category. Rules can be targeted to run at the individual server or group level and, upon rule violation, provide alerts and expert advice on how to address and correct a problem before it becomes a costly outage.

Configure Advisors

When the MySQL Enterprise Monitor User Interface is first installed, all Advisors are enabled by default.

To edit a single Advisor, click the Advisor schedule drop-down icon to the left of the Advisor/Group/Asset title, and choose Edit Advisor Configuration or Override Advisor Configuration. Or if you are editing multiple Advisors, select them and click the Edit Selected Advisors button on the top left of the page. It will then display a dialog box similar to:

Parameters

Advisors can have multiple types of parameters.

Figure 19.2 MySQL Enterprise Monitor User Interface: Edit Selected Advisors: Parameters

MySQL Enterprise Monitor User Interface: Edit Selected Advisors: Parameters

The most common pattern for Parameters are the thresholds. The four levels of Thresholds, which are Notice, Warning, and Critical, and Emergency, indicate increasing levels of severity. Events can be created by the Advisor evaluation result being equal to a certain value, greater than a certain value, or less than a certain value.

For instructions on setting up notification groups, see Chapter 18, Event Handling. Once you have set the Advisor parameters, click Save.

Schedule

The Schedule dialog box lets you configure several fields, as described below.

Figure 19.3 MySQL Enterprise Monitor User Interface: Edit Selected Advisors: Schedule

MySQL Enterprise Monitor User Interface: Edit Selected Advisors: Schedule

Note

Some Advisors are "On Demand", such as the expensive Advisor that populates the InnoDB Buffer Pool graph, and they are not listed on the Advisors page.

Note

When upgrading MySQL Enterprise Service Manager 3.x to 3.x, new Advisors are auto-scheduled.

Remove Advisors Configuration

To remove an Advisor configuration override, use the menu to the left of the Advisor, Group or Asset name, depending on what level of override you would like to remove. If you remove a configuration override, the selected node and its children will inherit the Advisor configuration of their parent.

It will then display a confirmation dialog similar to:

Figure 19.4 MySQL Enterprise Monitor User Interface: Advisors: Override Configuration

MySQL Enterprise Monitor User Interface: Advisors: Override Configuration

Disable Advisors

To Disable and Advisor, click on the Advisor menu drop-down icon ( A drop-down Icon ) to the left of the Advisor, Group or Asset title, and choose "Disable Advisor". If you're disabling multiple Advisors, select them and click the Disable Selected Advisors button at the top of the page. It will then display a dialog box similar to:

Figure 19.5 MySQL Enterprise Monitor User Interface: Advisors: Disable Configuration

MySQL Enterprise Monitor User Interface: Advisors: Disable Configuration

Note

Graphs that depend on a disabled Advisor will automatically be removed.