In the Central list, select Monitoring
- Click the New Monitoring Server Group icon.
The Monitoring Server / Monitor wizard
appears. Select Monitor Server and click Next.
The Name and Connection step is shown.
Type a name for the Monitoring Server and optionally provide a description.
The Resources step is shown. Check
"Databases" and click Next.
The Hosts/Device Agents step is shown.
Enter the hostname or IP address of the server into the Host field and click Add. Click
The Database(s) step is shown. Choose
the Connection Method. You must choose a Conductor if the database type is set to MySQL
because the JDBC driver for MySQL is not bundled in CloudTest. Note the “Direct/SQL”
connection method does not work for MySQL.
Select MySQL, then enter the TCP/IP port
number, the user name, and password (shown above).The resulting Monitor will have the
characteristics shown below.
Click the Test Connection button to test
the connection. If the connection is successful, you will see a pop-up containing some
information about the MySQL server. If the connection fails, you will see an error message
explaining what went wrong.
Click Next. Review the information to be
sure it is correct, then check the "Create a new Monitor for this Monitor Server" box and
Monitor appears in the list of existing monitors. Click Next again to proceed to configure
this monitor to track various statistics.
- At this point you can choose which statistics you are interested in. For each statistic, you can choose a "sample rate" which determines how often that statistic will be collected.
- The "Commits" statistic tracks the number of database commits per second.
- The "Rollbacks" statistic tracks the number of database rollbacks per second.
- The "Total Connections" statistic tracks the number of users connected to the MySQL server. This will never be zero, because monitoring itself uses at least one connection.
- The "Per Catalog Connections" statistic tracks the number of users connected to a specific MySQL database. If you use this statistic, you must enter the name of the database in the "Arguments" column.
What you should see
Note: Use the Name (Optional) column to give the metric a user-friendly label that will be used in the widget's title bar whenever this metric appears on a dashboard.
When you are finished, click Next. Review the information to be sure it is correct, then click Finish.