I'm running a DigitalOcean.com Virtual Server with the typical Ubuntu LAMP Stack for a few WordPress sites. Of course, every week or two the MySQL service seems to crash. If I restart MySQL or the Server, it's fine. I assume I'm getting hit hard by some hackers that is causing the MySQL connection issue.
Does anyone know a way to automate the restarting of the MySQL service? I was thinking of using a nightly CRON job to restart MySQL, but it seems like there should be a better way. Perhaps I don't have MySQL configured correctly? I'll have to find the MySQL config/ini file.
Edit: I'll dig up the error logs soon. Perhaps it's as simple as a configuration change.