Automatic reboot Apache and Mysql every x min, possible?

[DoctorX]

Hello,
Is it possible to automatic restart Apache and Mysql every x min to prevent server overload?

Thanks

DoctorX Reviewed by DoctorX on 8th Jul 2011. Automatic reboot Apache and Mysql every x min, possible? Hello, Is it possible to automatic restart Apache and Mysql every x min to prevent server overload? Thanks Rating: 5

[accyuklad]

i dont think you can but not fully sure but then your site would be down for a few sec if you kept doing that

[madaboutlinux]

It is, using simple commands but sometimes it will kill the connections from clients even if the load is normal and if the time difference between the restarts is high, the server may become non-responsive and the restart command won't work.

The better idea is to trace out the exact problem and eradicate it.
If you think there isn't a problem and legitimate traffic increases the load, you should look to upgrade your server.
If you don't want to upgrade the server, write a script in a way which will monitor the load average every minute and will restart the services if load average reaches a certain limit stated in the script.

Here is a shell script to monitor load average on linux server but you need to add a code in it to restart the apache/mysql services.

[DoctorX]

@accyuklad: yes, but just 2-5 seconds, not more.

@madaboutlinux: thank you mate for the info.yes, i will upgrade the server soon.
i will try to use that script for now and monitor the result.

[l0calh0st]

You can do it using cron jobs.

Example, restart apache and mysql every hour:

Create a .sh file in this directory: /etc/cron.hourly

with the following code:

service httpd restart
service mysqld restart

But trust me, this won't help reducing the server load.

[DoctorX]

Hello, Thank you localhost.
I have created this file /etc/cron.hourly/automatic.sh with this code:

/etc/init.d/apache2 restart
service mysql restart

is there a way to know that this file is working correctly?

[madaboutlinux]

Run it manually and you will see the output

/bin/sh /etc/cron.hourly/automatic.sh

You can also add these restart commands in the script given above.

[DoctorX]

madaboutlinux, thank you very much.

it works:

root@server:/etc/cron.hourly# /bin/sh /etc/cron.hourly/automatic.sh
* Restarting web server apache2 ... waiting [ OK ]
mysql start/running, process 32127

[Not_Responding]

to reduce server load, it'd be better if you switch from apache to nginx or lighttpd. or maybe reversing nginx as a proxy to apache

restarting it over and over again will not help you much.

[masterb56]

^ totally agree with Not_Responding. Especially if your using Kloxo - takes too much ram