Free space monitoring

Question

linux

Good afternoon!
What is the best way to implement monitoring of free space on sql server disks?
disk_free_space is not suitable, because it displays free space on the localhost, and in my case, the web server and sql server are different machines.

Answer 1

Write cron once a minute to a separate sql database on the sql server in a suitable format, and on the second server make a request to this database.
You shouldn't do this via ssh. Is that a shell to the user from whom you will monitor to expose something in the spirit of df in the correct format.

Answer 2

Put a simple monitoring system on a sql server? (see munin ).
If you need to receive data yourself, then instead of the munin server, you can poll clients yourself (there is a very trivial data exchange protocol).

Answer 3

In any case, you will have to do something on the SQL server - for example, write a simple script that would do df by cron, and send its results somewhere, or parse and notify the admin when it decreases below the specified limit.

Answer 4

look towards nagios-plugins