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:
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:
Thank you in advance for your replies.- 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.
Last edited by a moderator: