Steps
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.
On this page: