Configuring MySQL Status Device Modules

Configuring the MySQL Host

You will need to create a user and password on your MySQL server to allow access for the retrieval of the server's status information. You will also need to specify that this user is permitted to connect from your Ubersmith appliance host. Refer to the MySQL documentation on the 'GRANT' statement for more information on how to create this user. Ubersmith strongly recommends against using the MySQL 'root' user for this purpose. The privileges you will want to ensure that this user has are: slave status, global variables, and global status.

You may also need to verify that Ubersmith can connect to the database host via TCP/IP. This may require a modification of the bind_address configuration variable in your MySQL server's my.cnf file. Please ensure that you use sensible security and firewall settings as opening access to your database from remote hosts is a potential security risk.Configuring the MySQL Status Device Module

Clicking the 'edit' link for the 'MySQL Status' Device Module will open a popup with configuration settings which will allow you to specify the connection details for your MySQL server.

Model

For MySQL, select 'MySQL RDBMS' from the drop down menu.

Address

Specify the IP address at which your MySQL database host can be reached.

Port

By default, MySQL will listen for connections on TCP port 3306. If you have configured MySQL to listen on an alternative port, change it to the appropriate value here.

Update Interval

Set the 'Update Interval' to 1 to enable polling, 0 to disable polling

Username

The username associated with the MySQL user configured in the section 'MySQL Host Configuration' above.

Password

The password associated with the MySQL user configured in the section 'MySQL Host Configuration' above.

Post-Configuration

Once configured, your Ubersmith appliance will begin to poll MySQL for data. The module will show a 'Query Profile' with database activity, as well as connection details. Clicking on the links for either of these items will show a graphical representation of the data over time.

Configuring MySQL Status Monitoring

Once you have confirmed that your appliance is collecting data successfully from MySQL, you may wish to configure monitoring. Click the 'Monitors' tab for the device you are working with, and then click 'Add Monitor' on the orange bar. This will provide you with a popup to add a new monitor.

Protocol

Set this drop down to 'Module'.

Address

Leave this configured as 'No Address Selected'.

Module

Set this drop down to 'MySQL Status'.

The remaining items can be configured as described in the knowledge base article 'Adding and Configuring a Monitor'. Once you have completed configuring the 'Details' tab, click the 'Config' tab.

Is this a slave database host?

If the host you are adding the monitor for is configured as a slave database host, select Yes, and configure the next two items if desired.

Maximum Slave Delay

The maximum acceptable value for the 'Seconds_Behind_Master' slave status variable without a notification being sent.

Minimum Slave Processing Rate

The minimum rate the slave is permitted to process queries from the master without a notification being sent.

Warn if active connections are greater than

If active connections to the host are greater than the value of 'max_connections' defined, send a notification.