Mysql – the best way to monitor a production server

apache-2.2monitmonitoringMySQL

We are running two production servers with Apache 2 and MySQL. I am looking for a reliable way of monitoring our load, stability and uptime.

I have come across monit, but are there better alternatives?

Best Answer

I configured Zabbix on a virtual machine at Slicehost and have been quite pleased with the solution. Since it's physically separate from our production servers it will alert me even if the production network has issues. The virtual machine at Slicehost is cheap and easy to backup.

Zabbix is great because it can monitor website response time and also CPU, disk, and just about anything else. Zabbix will store historical data so you can see how statistics trend over time. I also prefer Zabbix over Nagios because Zabbix has a powerful web based configuration interface.

Related Solutions

Mysql – Easiest way to sync a dev MySQL db to a production MySQL db

A master/slave setup could work if you ran "stop slave" on the production box. That would stop all syncing between the two boxes. You would then only need to start the slave whenever management give the go ahead to sync the two up. Just don't forget to run "stop slave" on it when you are done.

I'm assuming that shutting down production is not an option, but if it were able to, you have other options. One option is to shutdown both mysql servers and copy the files from staging to production. That is the easiest way to guarantee that both servers are completely in sync.

Monit: check process without pidfile

In monit, you can use a matching string for processes that do not have a PID. Using the example of a process named "myprocessname",

check process myprocessname
        matching "myprocessname"
        start program = "/etc/init.d/myproccessname start"
        stop program = "/usr/bin/killall myprocessname"
        if cpu usage > 95% for 10 cycles then restart

Maybe if you check to see if CPU load is at a certain level for 10 monitoring cycles (of 30-seconds each), then restart or kill, that could be an option. Or you could use monit's timestamp testing on a file related to the process.

Best Answer

Related Solutions

Mysql – Easiest way to sync a dev MySQL db to a production MySQL db

Monit: check process without pidfile

Related Topic