Configuring MySQL Status Device Modules Estimated Reading Time: 3 Minutes Configuring MySQL Status Device Modules Estimated Reading Time: 3 Minutes The MySQL Status device module monitors the activity and connection counts of your MySQL database hosts. Configuring the MySQL Host Create a user and password on your MySQL server. This user must be able to retrieve the server's status information. Also allow this user to connect from your Ubersmith appliance host. For more information on how to create this user, refer to the MySQL documentation on the 'GRANT' statement (http://dev.mysql.com/doc/refman/5.5/en/grant.html). Do not use the MySQL 'root' user for this purpose. Give this user the following privileges: slave status, global variables, and global status. Verify that Ubersmith can connect to the database host through TCP/IP. You may need to change the bind_address configuration variable (http://dev.mysql.com/doc/refman/5.5/en/server-options.html) in your MySQL server's my.cnf file. Use secure firewall settings. Opening database access to remote hosts is a security risk. Configuring the MySQL Status Device Module Click the 'edit' link for the 'MySQL Status' device module. A popup opens with configuration settings. Use these settings to enter the connection details for your MySQL server. Note: Use this page to add or change the server configuration in the Ubersmith appliance. Fill out all fields accurately. If you are unsure about any details, contact support@ubersmith.com. Model - Select 'MySQL RDBMS' from the drop down menu. Address - Select the address for your MySQL database host from the 'Address' drop down menu. This menu lists the IP addresses and interfaces already configured on the device. If the address you need is not listed, use the adjacent 'edit' link to add it. Then select the new address. Port - By default, MySQL listens for connections on TCP port 3306. If you configured MySQL to use a different port, enter that port number here. Update Interval - Set 'Update Interval' to 1 to enable polling. Set it to 0 to disable polling. Username - Enter the username for the MySQL user configured in the section 'MySQL Host Configuration' above. Password - Enter the password for the MySQL user configured in the section 'MySQL Host Configuration' above. Tip: Each field in this popup has a (?) tooltip icon. Click this icon for a quick reminder of what the field expects. Post-Configuration - After configuration, your Ubersmith appliance begins to poll MySQL for data. The module shows a 'Query Profile' with database activity and connection details. Click either link to see a graph of the data over time. Configuring MySQL Status Monitoring After you confirm that your appliance collects data from MySQL, you can configure monitoring. Click the 'Monitors' tab for the device. Then click 'Add Monitor' on the orange bar. A popup opens 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'. Configure the remaining items as described in the knowledge base article 'Adding and Configuring a Monitor' (https://docs.ubersmith.com/display/UbersmithDocumentation/Adding and Configuring a Monitor). After you finish the 'Details' tab, click the 'Config' tab. Is this a slave database host? - If the host is a slave database host, select Yes. Then configure the next two items if desired. Maximum Slave Delay - Enter the maximum value for the 'SecondsBehindMaster' slave status variable (http://dev.mysql.com/doc/refman/5.5/en/show-slave-status.html) before Ubersmith sends a notification. Minimum Slave Processing Rate - Enter the minimum rate at which the slave can process queries from the master before Ubersmith sends a notification. Warn if active connections are greater than - Ubersmith sends a notification if active connections to the host exceed the 'max_connections' value.