So I have had Sentora running on a new server I created through digitalOcean for about 2 months now. I recently moved from shared web hosting on GoDaddy using cpanel.
All was working well up until recently. Basically, it seems about every 1-2 days mysql crashes on my server. I will notice it when I try to open one of my websites and I will see the Drupal server connection error page. This is very bad obviously, as I don't notice the site being down until I check it, which means it can be done for several hours with me knowing (any idea how to get notified of when the mysql server is down? Maybe some cron job I can run to run a .sh script to check if Mysql is actively running?)
A simply service mysql restart command fixes the situation. So basically I know that my issue is mysql is crashing.
root@panel:~# service mysql restart
stop: Unknown instance:
mysql start/running, process 10715
root@panel:~#
I am hoping someone here can help me figure out why mysql is crashing and how I can prevent it. My guess is it's a memory error, such as the server is running out of available memory. But why is that crashing Mysql, shouldn't the site just become less responsive? I don't understand why it's bringing the service down. Is this normal?
Thank you for any help you can all provide?
All was working well up until recently. Basically, it seems about every 1-2 days mysql crashes on my server. I will notice it when I try to open one of my websites and I will see the Drupal server connection error page. This is very bad obviously, as I don't notice the site being down until I check it, which means it can be done for several hours with me knowing (any idea how to get notified of when the mysql server is down? Maybe some cron job I can run to run a .sh script to check if Mysql is actively running?)
A simply service mysql restart command fixes the situation. So basically I know that my issue is mysql is crashing.
root@panel:~# service mysql restart
stop: Unknown instance:
mysql start/running, process 10715
root@panel:~#
I am hoping someone here can help me figure out why mysql is crashing and how I can prevent it. My guess is it's a memory error, such as the server is running out of available memory. But why is that crashing Mysql, shouldn't the site just become less responsive? I don't understand why it's bringing the service down. Is this normal?
Thank you for any help you can all provide?
