The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql Goes Down

Discussion in 'Database Discussions' started by amoloo7, Oct 7, 2013.

  1. amoloo7

    amoloo7 Member

    Joined:
    Jan 17, 2013
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    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 ??
     
  2. cecilianz

    cecilianz Registered

    Joined:
    Oct 7, 2013
    Messages:
    0
    Likes Received:
    0
    Trophy Points:
    0
    cPanel Access Level:
    Root Administrator
    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.
     
  3. amoloo7

    amoloo7 Member

    Joined:
    Jan 17, 2013
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    can you five me any one of the script i am really new to cpanel/whm please guide me
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,463
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    You should find out what the problem is instead of forcing it to stay up.
     
  5. amoloo7

    amoloo7 Member

    Joined:
    Jan 17, 2013
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    cpanel guys are on my server to check this issue will let you people know what exact problem is
     
Loading...

Share This Page