Mysql Goes Down

[amoloo7]

Helli i have E3 Server with CENTOS 6.4 x86_64 standard WHM 11.38.2 (build 7) I have one problem when server load is high mysql goes down dont know why ........ Can some one guide me how to auto restart mysql when it go down ???
i know there is a script in cpanel/whm which moniter sql after every 5 minute when it goes down but this time is long i want to moniter sql every second and restart when it goes down automatically can any one help me in this ??

 

[cecilianz]

I have one problem when server load is high mysql goes down dont know why

There are few scripts available to autorestart your mysql server when it is down. But to resolve this issue permanently, you would need to figure it out why there were load issues. Check why the mysql server went down. Mysql server's error log is your friend.

 

[amoloo7]

can you five me any one of the script i am really new to cpanel/whm please guide me

 

[Infopro]

...
i know there is a script in cpanel/whm which moniter sql after every 5 minute when it goes down but this time is long i want to moniter sql every second and restart when it goes down automatically
...

You should find out what the problem is instead of forcing it to stay up.

 

[amoloo7]

cpanel guys are on my server to check this issue will let you people know what exact problem is