Database Manager

MySQL Database Plugin

The Databases plugin is automatically enabled when you add a new device to SevOne NMS to enable you to monitor the MySQL database metrics for the databases you designate on the device.

Devices for which you enable the Databases plugin can display the following MySQL database indicator data on the Device Summary page.

  • Database Name - Displays the database name.
  • Description - Displays the database description.
  • Availability - Displays database availability.
  • Traffic (in and out) - Displays the traffic in and out.

Perform the following steps to enable the Databases plugin for each device from which to poll databases metrics.

  1. From the navigation bar, click Devices menu and select Device Manager.
  2. Either add a device with the Databases plugin or edit a device to enable the Databases plugin.
  3. triangledown - Click the plugin drop-down (displays SNMP by default) and select Databases.
  4. Select the Allow MySQL Database Polling check box to enable discovery of MySQL objects and to poll MySQL metrics.
  5. On the New Device page, click Save as New to display the Edit Device page to perform the next steps.
  6. On the Edit Device page, click Manage This Devices Databases to display the Database Manager.
  7. Click Add Database to display fields that enable you to designate the databases to poll on the device.
  8. In the Name field, enter the database name.
  9. In the Description field, enter the description of the database to display.
  10. The Type field is set to MySQL to add a MySQL database.
  11. In the Username field, enter the username SevOne NMS needs to authenticate onto the database on the device. See the Minimum User Requirements section below for a list of the minimal requirements the Databases poller needs.
  12. In the Password field, enter the password SevOne NMS needs to authenticate onto the database.
  13. In the Confirm Password field, re-enter the password.
  14. In the Port field, enter the port on the device for SevOne NMS to use to listen for data.
  15. Click Save.
  16. Repeat these steps to manage the databases.