cPanel routinely restarting MySQL?

[JBES]

Hi,

I have been having ongoing discussions with my host regarding MySQL restarts extremely frequently - 8 times in the past 5 weeks - causing about 6 minutes of downtime resulting in multiple MySQL Error 2002 each time. Obviously this in turn leads to pages that don't load, transactions that don't go through, lost clients, etc. Add to this how incompetent it makes both myself and them look.

Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (2002)

As MySQL is a mission critical database service and is designed to run for months or years between restarts, obviously I do not consider this reasonable when I am paying large sums for reliable always-on hosting and due to this I opened a ticket with them shortly after this starting happening.

After these 5 weeks of them doing just about all they can to avoid the issue, they have directly blamed CPanel for this with the statement below. It is possibly they are even confusing CPanel with WHM but could I simply have clarification as to whether it actually is CPanel or WHM doing this, and if so, briefly why?

Here is their response to me, quoted:

- MySQL Restarts
We've reviewed this matter with our System Administrators, and the MySQL restarts are being triggered by cPanel. Newer versions of cPanel are requiring MySQL restarts to complete various functions, which include the creation or termination of a cPanel account. This restart period would be instant unless a crashed table would need to be repaired, then it would take maybe 5-10 seconds. You may wish to contact cPanel about this and why it's required, however it is part of it's normal operation.

Thank you in advance for your replies.

 

[cPanelMichael]

Hello

Are you able to open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

Thank you.

 

[JBES]

Hi,

Thank you for your reply.

Unfortunately I am unable to do this as I don't have the required information regarding the hosting server for opening a ticket.

Rather than needing to be specific, my query is a general query regarding the behaviour of CPanel as my host has bluntly refused to look into the matter from the outset. I highly suspect the problem is with them and, of course, they have pointed their finger at CPanel.

 

[Infopro]

As MySQL is a mission critical database service and is designed to run for months or years between restarts, obviously I do not consider this reasonable when I am paying large sums for reliable always-on hosting

While MySQL is up on that server it might be time to grab a proper backup and go find a more reliable Hosting Provider. I just happen to know where you can start your search, too:
cPanel Hosting Partner Directory

Good luck!