Munin

Use Munin to monitor a Dreamhost MySQL VPS

Earlier I showed how to set up Munin on Dreamhost to monitor their VPS service (see: Monitor Dreamhost VPS performance, load, etc with munin). Among the available Munin plugin's is one to monitor MySQL. Out of the box it monitors the MySQL on the localhost, but if you have a Dreamhost MySQL VPS it's on a remote host and there are a few special considerations to take care of. The reason for doing this is Munin's data capture is much more comprehensive than the resources page which Dreamhost gives us.