What kind of maintenance tasks should I be thinking about on a LAMP server?
Hi everyone, I recently set up a new LAMP server for two moderately trafficked blogs in my content network. The performance so far has been great and my 1 gig server still has plenty of RAM and processing speed available. This is the first time I've hosted a server on my own. The first 48 hours were smoother than I expected but I did have a MySQL database lockup that brought my sites down until I cycled the process. So my question is - what kind of maintenance tasks should I be doing on the server? Should I set up a cron to restart my database and apache services or reboot the droplet on some regular basis? Any other maintenance tasks I should be doing beyond offsite backups to ensure reliability?