pkgacct - Check load & MySQL to prevent MySQL timeouts.

[driverC]

Hi,

a problem I experience on a regular basis is that when I create a backup the server's load gets high and then when the pkgacct script tries to backup MySQL databases I get a timeout or the MySQL server is just down. Then you have to do the entire backup all over.

I would be so glad if you could rewrite the script to check the load prior to backing up MySQL databases and also check if MySQL is actually functional.

Grabbing mysql dbs..........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Timeout: Alarm at /usr/local/cpanel/bin/mysqladmin line 24.

Like one time we lost a hard drive and then ran into a large amount of issues with missing MySQL content since the backup was missing MySQL databases that had timed out during the backup process was operating.

Thanks !

[cPanelDon]

Hi,

a problem I experience on a regular basis is that when I create a backup the server's load gets high and then when the pkgacct script tries to backup MySQL databases I get a timeout or the MySQL server is just down. Then you have to do the entire backup all over.

I would be so glad if you could rewrite the script to check the load prior to backing up MySQL databases and also check if MySQL is actually functional.

Grabbing mysql dbs..........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Timeout: Alarm at /usr/local/cpanel/bin/mysqladmin line 24.

Like one time we lost a hard drive and then ran into a large amount of issues with missing MySQL content since the backup was missing MySQL databases that had timed out during the backup process was operating.

Thanks !

The extra CPUs load threshold may be adjusted to account for issues involving higher than normal load; this may be configured via the Tweak Settings page in WHM, as seen at the following menu path:
WHM: Main >> Server Configuration >> Tweak Settings >> Stats and Logs

• The load average above the number of CPUs at which logs file processing should be suspended (default 0)

Have you tried adjusting the aforementioned configuration option? The setting will also apply to the automated cPanel backup ("cpbackup") process. Using the stock-default value of zero ("0") should help avoid the described issue during backups, but in cases where high load is often expected a lower extra CPUs threshold may delay cpbackup completion and or delay cpanellogd processing of logs (e.g., for stats).

Regarding the request to see if MySQL is functional, is there a certain way you would like to see the feature implemented, and is there any special criteria that you would like checked when testing MySQL?

If MySQL is determined to be unavailable, what specific action(s) would you like to have occur?

Please note that recurring issues with MySQL timeouts should be investigated and corrected by the appropriate Systems Administration personnel to ensure MySQL remains responsive as it is abnormal to have this type of issue frequently occurring.

[driverC]

The load check in pkgacct appears to be quite unreliable probably because it does not check the load frequently enough.

So my idea was to implement a load check right before it does the MySQL backup. If the load is too high wait for the load to go down to continue.

To check the MySQL status you could do a simple "service mysql status" and see if it returns an "OK". If not wait for a few seconds. Then retry. If it does not work after a certain amount of retries skip the MySQL backup and add a note to the logfile.