Server Monitoring with the MYSQL Monitor
Description
| This monitor allows you to monitor a MySQL database server. You can monitor any mySQL server which is available on the internet and is externally accessible. |
Parameter
| Port | mySQL server's port. (default value: 3306) |
| Username | Username to log in at the mySQL server |
| Password | Password to log in at the mySQL server |
| Timeout [Seconds] |
Time in seconds before a connection attempt times out. If a timeout occurs, the status of the check is changed to Critical. |
Availability Report
| OK | Server responding, successful connection to port, reply from mySQL server |
| Critical | Server not responding, no connection to port within the timeout, no reply from mySQL server |
Performance Report
| Response Time | Time, which is needed to execute the check |
Monitor Integration
In order to have your mySQL server monitored by ServerGuard24 , the right to connect all
measuring points from ServerGuard24 to the mySQL server is required in addition to the connection to the server (please keep firewalls in mind).
Therefore you should add a new mySQL user, which is used by ServerGuard24 for monitoring purposes only and which does not need any access rights to you data.
To do so you could use the SQL statement listed below:
INSERT INTO mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES ('%', 'sg24test', password('sg24pass'), 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
flush privileges;
If you want to set the configurations manually, add a new entry with the following values in the "mysql" databank in the table "user":
Host: %
User: <Username>
Password: <Password>
All other fields: 'N'
To finish the process enter the assigned username and password in the ServerGuard24 MYSQL service form.
INSERT INTO mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES ('%', 'sg24test', password('sg24pass'), 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
flush privileges;
If you want to set the configurations manually, add a new entry with the following values in the "mysql" databank in the table "user":
Host: %
User: <Username>
Password: <Password>
All other fields: 'N'
To finish the process enter the assigned username and password in the ServerGuard24 MYSQL service form.
SUPPORT
Phone: +49 228 / 37749 152
Fax: +49 228 / 37749 153
Email: info@serverguard24.com
Payment types
Phone: +49 228 / 37749 152
Fax: +49 228 / 37749 153
Email: info@serverguard24.com
Payment types
