Using the MySQL Administration panel dashboard (4376405)

Using the MySQL Administration panel dashboard

What does MySQL agent Administration Panel dashboard represent?

The MySQL Administration Panel features server operations which can be performed through the console by permitted users. The actions currently available represent the initial offering and later versions will incorporate more possibilities. An action is performed by clicking the icon in the relevant category, which will bring up a menu dialog with options and confirmation of the requested action. Actions can only be performed on one server at a time. The active server can be switched using the MySQL Agent Selector in the right-hand pane. Only agents where administration is enabled will be shown.

The Administration Log below records actions performed in the specified time range for auditing purposes. Information includes a timestamp, the Foglight user who performed the action, the database user employed, the actual statement text, execution time, result (if any) and any resulting SQLExceptions or warnings from the statement.

Prerequisites to use Administrative Actions

1. In the Agent Properties of the agent monitoring the MySQL server, Enable Administration must be set to true.
2. Also in the Agent Properties, a DB user and password must be provided. This user must have the necessary privileges to perform actions taken through the Administration Panel or the action will fail. This user will be solely employed to perform actions on request, not for data collection or other purposes.
3. A Foglight user must have the MySQL Administrator role granted to them in the Administration | Users & Security dashboard in order to access and use the Administration Panel