Skip to main content
We are aware of an issue after updating to cPanel versions 11.110.0.65, 11.126.0.21, or 11.128.0.11, some cPanel plugins or features are no longer functioning properly including WP Toolkit. Please see the following article for more information and updates:
Update to latest cPanel 110, 126, or 128 versions removes "addonfeatures" directory.

Auto routine check database connection

LotusBlossom
All websites on my server this morning were reporting "Error establishing a database connection". I rebooted the server through WHM and everything came back online - I assumed it was caused by an automatic update to WHM version 96.0.13 - 2021-07-19 [security] TSR-2021-0004. Is there a setting or method for the server to automatically restart MySQL when this happens? And sends me an email when a website loses database connection? Here's the server software: CloudLinux, Apache 2.4, PHP 7.4 (All PHP Opts, and mod_hostinglimits), and Ruby 2.7, OpCache. MySQL 5.7 (I will be updating this to MariaDB 10.3 this evening).

Comments

4 comments

Date Votes
  • cPRex Jurassic Moderator
    Hey there! You can ensure the MySQL service is being monitored in WHM >> Service Manager, as that performs a check to the database service to ensure things are working well. If you have both boxes selected it will attempt a restart of the service if it detects an issue.
    0
  • LotusBlossom
    Hey there! You can ensure the MySQL service is being monitored in WHM >> Service Manager, as that performs a check to the database service to ensure things are working well. If you have both boxes selected it will attempt a restart of the service if it detects an issue.

    Thank you for the suggestion, unfortunately I already had that enabled and this problem still occured. From the reports received from my customers, my server was showing this database error message for several hours.
    0
  • cPRex Jurassic Moderator
    The Service Monitoring tool just tests the connection to MySQL itself - it's not advanced enough to see if there are issues with user connections or table problems, but just does a check to see if the service is up and running. While I'm sure they exist, I'm not personally aware of any more advanced monitoring tools for the database system. If this happens again it would be useful to run the "mysqladmin proc status" command to see what state the database server was in. You could also try checking the MySQL error log in the system to see if there are any helpful details from around that time period.
    0
  • LotusBlossom
    Thank you for your support. I wasn't able to find anything helpful in the MySQL error logs. I will make a note of the command you provided and I will look into a service for auto checking the status of web pages.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post