REstartng MySQL automatically on Linux VPS

[srchild]

Twice I have had to restart MySQL on my VPS Hosting - dynamic website hostings showing no connection to database, resolved by restarting.

If I am watching the website hostings I can do this manually from WHM, but this is no good for longerterm use - I can't be checking my website hostings every half hour for the rest of my life

1. Is there some command line way that I can test if MySQL is responding?

2. What is the command line command for restarting MySQL (not via WHM but via command line)?

Given both the above I could run a script from a cron job every 15mins or so which would restart MySQL if it is not responding.

Anyone got any ideas?

Thanks

[eUKShane]

Hello,

1. You can give "mysql" command on the shell and if it shows following output (mysql prompt) then Mysql is working fine.
----------------------------------
root@test [~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 317435 to server version: 4.1.21-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
----------------------------------

2. You can restart MySql using following commands :
# service MySQL Server restart
# /scripts/restartsrv mysql

Even you can add MySQL Server from "WHM >> Service Configuration >> Service Manager" which will monitor MySQL Server service and automatically restart it if it goes down.

Let us know if you need any further assistance. We will be glad to assist you.

Best Regards,
eUKShane
http://www.eukhost.com

[srchild]

Originally Posted by eUKShane

Hello,
Even you can add MySQL Server from "WHM >> Service Configuration >> Service Manager" which will monitor MySQL Server service and automatically restart it if it goes down.

Ah, that sounds like the easiest answer!

Any other services you recommend for monitoring, i.e. does it add much load or risk any problems if I set it to monitor httpd as well?

[eUKShane]

Hello,

We have a script which will monitor MySQL Server service and will automatically restart it if it goes down.

You can check the script at http://www.eukhost.com/forums/showth...=5744#post5744

Does it add much load or risk any problems if I set it to monitor httpd as well?

Well, enabling the httpd service for monitoring won't create any Load or Risk anything on your VPS Hosting.


Best Regards,
eUKShane
http://www.eukhost.com

[srchild]

Originally Posted by eUKShane

Hello,

We have a script which will monitor MySQL Server service and will automatically restart it if it goes down.

You can check the script at http://www.eukhost.com/forums/showth...=5744#post5744

Thanks

I notice that your script does email notification and so on, but other than that what is the difference between running that script and setting up monitoring of MySQL through WHM? i.e. which will be the more reliable way to keep MySQL running? And will there be a conflict if I do both?

[eUKShane]

Hello,

Their is no exact difference between the script and setting up monitoring of MySQL through WHM, both will send you an email notification of the service restart attempt. As you were asking something from Shell (command prompt) that's why I had given you that script.

Yes, you can use both options at a time and their will be no conflict in between them. Just enable monitoring of MySQL through WHM as this facility is given by cPanel so we can say that it's more reliable way to keep MySQL running.


Best Regards,
eUKShane
http://www.eukhost.com