2 2
metalslug

Too many connections ?

Recommended Posts

On 5/8/2021 at 5:13 PM, IanHarrop said:

Do you have the ability on the host to set a cron task? If so I found this:

To keep things up and running automatically after a crash, I use a simple cronjob to check and restart MySQL if it is down.
Load the crontab editor in the terminal with crontab -e and add the following line:
* * * * * service mysql status > /dev/null || service mysql start
This checks if MySQL is running every minute and redirects stdout to null.

https://mhagemann.medium.com/how-to-auto-restart-mysql-when-it-crashes-during-a-brute-force-attack-d7a03b726b7e

Unfortunately we're unable to do any individual MySQL work. The hosting company that we use are in the process of transitioning to another company, and they do not offer the ability to setup Crons, nor do they allow one to adjust the max_connections to the MySQL server.

At this point the only way for us to resolve it is to move the entire site to a different hosting provided, which is a bit of a pain. But we're looking into this now, as we do want to ensure there is no downtime from MySQL timeouts on the server side.

Share this post


Link to post
Share on other sites
On 5/6/2021 at 8:44 AM, Meso said:

  

... The issue is resolved after the mySQL server gets restarted, unfortunately we rely on our host to do that so there may be some delay. But we would like to get this resolved, of course.

It was down for quite a while on Friday, during the daytime in the US.

I fully understand that you are in a different time zone from the US, and maybe the host is too (don't know on that). I also understand that for either you or them to monitor the status of the site every minute of every day isn't realistic. 

Is there any way for a 'normal schmoe', or maybe a mod to alert the host that the server needs to be restarted?
I'd certainly be willing to shoot off a quick e-mail to let them know there's a problem if it's something that would get the site up sooner.

Share this post


Link to post
Share on other sites
On 5/17/2021 at 6:24 AM, Administrator said:

At this point the only way for us to resolve it is to move the entire site to a different hosting provided, which is a bit of a pain. But we're looking into this now, as we do want to ensure there is no downtime from MySQL timeouts on the server side.

It will be a pain, but unfortunately it seems necessary

On 5/17/2021 at 6:24 AM, Administrator said:

Unfortunately we're unable to do any individual MySQL work. The hosting company that we use are in the process of transitioning to another company, and they do not offer the ability to setup Crons, nor do they allow one to adjust the max_connections to the MySQL server.

This seems strange to me.

Running your own server on AWS or the like would give you all the flexibility you want, though it would also require the most expertise. I feel like that shouldn't be necessary for a simple forum with little traffic, but here we are. If you want to go that route, I'm willing to help.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

2 2