The MySQL check allows you to monitor MySQL database services. You can verify that the database server is accepting connections, or optionally login and run a query, and verify that the query results match or are within user-defined limits.
If you chose to verify query results, the check connects to the MySQL service and makes a user-defined database query. It then verifies the results of the query with user-defined fields. The results can be either numeric or strings.
For numeric query results, the MySQL check will verify that the number is within the user-defined minimum and maximum range. If the result is outside that range, the check will fail and notifications will be sent.
For string query results, the MySQL check will try an exact match against the user-defined 'match' field. The 'match' field also support regular expressions (regex) matching.
NodePing's MySQL checks can be used to test the availability of a MySQL database service. It can also be used to verify the results of a query. It is often required to whitelist connections from our probes in the service firewall for the monitoring to function. A list of our probe IPs can be found in the FAQ.
If your MySQL service requires authentication please remember that by providing a username/password to someone that is not you, you are creating a new risk. This decision should be weighed very carefully. Please keep our Terms of Service in mind when you are configuring your MySQL checks. It is best practice when you are creating a user for monitoring that you have a separate user for monitoring that is restricted to read-only as discussed in the MySQL documentation.
To set up a MySQL check,
To monitor availability of MySQL database services.
SSLv3/TLS1.0 are not supported.
If you have any questions, get in touch at email@example.com, or use our Contact form.