We have a powerful Centos/Cpanel box with 16CPUs and 12GB memory. We have installed Amemberpro membership management software on this server with around 40K members in the mysql database.
The server is giving connection errors such as;
-MySQL Too many connections
-Web site is taking too long to load
-Has to restart apache or mysql to get server back online during high traffic
At weekends traffic could reach as high as 1000,000 users per day. About 10,000 to 5000 of those users will be heavy mysql site users. because we run free event on weekends.
-We want some one who is an expert in centos/mysql/apache tunning.
-All changes made to the server should also be logged (tasks)
-before we make the full payment server should be monitored during a weekend to test solution
-AmemberPro script experience is an asset but is not needed.
**Please do not copy and paste your design skills here - Serious server admins only**