Ubuntu server failing daily
- by deanvz
Symptoms:
Server becomes unresponsive - Increase in load, all services stop
Loss of connectivity - Ping/SSH
Flush MySQL hosts after reboot - As MySQL refuses new connections
Intermittent Apache crashes
Generally happens early morning hours - 2 days of the week are however excluded
Changes made:
Updated the OS - to Ubuntu 10.04.4 LTS
Not sure if the MySQL server was also updated in the process
Current MySQL version - mysql Ver 14.14 Distrib 5.1.63, for debian-linux-gnu (x86_64) using readline 6.1
Updated Plesk from 10.4.4 Update #47 to 11.0.9 Update #23
Rebooted on almost daily basis
All crons stopped for the times corresponding to the server crashes
Created a MySQL log to monitor the lock times on queries
Possible causes:
Failing hardware
Incorrect software configuration (MySQL, Apache etc)
Responsibilities:
Small webserver
Runs our billing system - WHMCS
Responsible for CRONs
Bulk-email solution - No delivery times coincide with server crashes
Proposed solutions:
Move machine over to VM
Format and restore the Plesk server backup and take it from there?
Side notes:
Seems to be a general Apache failure across all our linux servers - Intermittent problem
Are we doing something fundamentally wrong in the Apache config? (I understand that this is a secondary question, just making sure that it isnt possibly holding any relevance)