Problem description:
We have a server on AlmaLinux with ISPManager installed, a MariaDB database, and online stores on the OpenCart platform, running on PHP 7.3. There are about 7 users on the server, each with several OpenCart sites. Currently, there is often a problem with the max_user_connections error due to a large number of simultaneous requests to the database, leading to server overload and crashes.
Task:
Problem analysis:
Evaluate the MariaDB configuration on the server.
Check the current settings for max_user_connections and other parameters that may lead to database overload.
Solutions to limit max_user_connections:
Develop a strategy to limit the number of simultaneous connections for each user separately to prevent server overload.
Configure MariaDB so that each user has individual connection limits, which will help avoid situations where one user can overload the entire server.
Optimization of MariaDB configuration:
Check and optimize the database configuration to improve its stability and efficiency under high loads.
Recommend changes to MariaDB settings if necessary for the stable operation of multiple online stores on OpenCart.
Monitoring and overload alerts:
Set up monitoring tools to track the status of the server and database to timely detect overloads or approaches to critical limits.
Configure alerts for high load thresholds to take timely action.
Improvement recommendations:
Provide recommendations for further steps to maintain high server availability and optimize the operation of online stores, including caching settings, improving database performance, etc.
Expected results:
Individual limits for max_user_connections for each user.
Optimized MariaDB settings to improve stability under high loads.
Configured monitoring of the server and database to prevent overloads.
Detailed recommendations for further optimization of the server infrastructure.
Additional requirements:
Experience with AlmaLinux, MariaDB, ISPManager, OpenCart.
Knowledge of optimization methods for server and basic settings for PHP and MariaDB.
Availability of a portfolio or experience in performing similar tasks.
If you have any questions or need further clarifications, please feel free to reach out!