Skip to main content

Recurring MySQL Connection Issues on AlmaLinux Server with cPanel and CloudLinux

edilsonlsouza

Hello,

I am experiencing a recurring issue on my server running AlmaLinux with cPanel and CloudLinux. From time to time, all websites and systems using MySQL lose their database connection, as if the databases or tables were deleted. However, after restarting MySQL, everything returns to normal.

Issue details:

  • Environment: AlmaLinux + cPanel + CloudLinux

  • Symptom: MySQL connection error affecting all websites

  • Temporary solution: Restarting MySQL temporarily resolves the issue

  • Recovery time: Sometimes the service returns on its own after 2 hours, but not always

What has already been done:

  • Basic log checks and resource usage analysis

  • Integrity tests on tables and databases

  • Configuration adjustments in my.cnf

I am looking for a definitive solution to this issue, as these outages directly impact the availability of hosted services. I would like to know if there are any known bugs, incompatibilities, or specific configurations recommended for this environment.

I look forward to your guidance and appreciate your attention!

Best regards

Comments

1 comment

Date Votes
  • cPRex Jurassic Moderator

    Hey there!  When this issue happens, before you restart MySQL, you'll want to check the following two things:

    -the MySQL error log, which is located at /var/log/mysqld.log by default
    and
    -the current activity on the MySQL server with the "mysqladmin proc status" command

    I would expect one of those things to get you more details about what is happening on the machine.

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post