Winston wrote: ↑July 18th, 2022, 9:59 am
@publicduende: I don't think you read my post correctly. We've been on VPS since 2014 or so. It's been nothing but trouble. The forum crashed far less on SHARED hosting with Godaddy. So VPS has been a lot of trouble with no benefits. What's the benefit of paying 10 times more for less hosting space and more problems and no free backup like with shared hosting? I can't see any logical reason. Can you? It's not like we have millions of people on here that would require dedicated hosting. Premium shared hosting has plenty of backup resources and I don't have to manage any server. Why do I need to manage the server if admins can manage it? As long as it's running why would I need to manage it? I don't get that.
So basically I don't need to control my server on a VPS or have control over aspects of the server. All I want is for the forum and site to run smoothly and for the process to be as automated as possible. Shared hosting should be enough for that. I don't see why having control over aspects of a server is necessary at all. I prefer to focus on content creation, not managing a server.
@Winston LOL touche'...I didn't read the post well and thought that you were offered VPS as a solution. VPS means HA is hosted on some dedicated virtual (hardware) resources but doesn't say how much resources you have available. No offense, I don't think the traffic to this site is higher than it used to be a 4 or 5 years ago. Assuming their VPS offering has never changed or degraded over time, the simplest explanation for the MySQL failures can only be the continuously growing size of the database and its impact on the storage (filesystem).
I think it makes sense that you ask BlueHost or, better, a trusted party to survey the current size of the HA phpBB database and give you some honest advice as to what configuration you need to run it smoothly. My gut feeling is that BlueHost is hinting at the fact that you need a beefier VPS solution (more RAM and more storage space), yet they are trying to lure you into getting (and paying for!) much more than what you need!
Also, I agree that BlueHost might not be (or no longer be) the best or the cheapest solution on the market. You may wanna start shopping around. This one, for example.
https://www.a2hosting.com/phpbb-hosting