Hi all. I have been playing around with the wordpress one step installer on ubuntu at https://mpmilestogo.site. The site is very responsive most times but it seems to suffer with database connection failures at times. I just bumped up CPU, storage, and RAM because it seems to happen if I ask the site to take a photo or photos. I also run a few custom plugins like the ActivityPub plugin which federates my site and webmentions. The VPS can be reached by SSH when it claims there is a database connection issue. Are there other things I should be aware of to try with the VPS? I have run updates on the site and also upgraded wordpress to the latest.
One of the sites mentioned that this can occur with memory limits and I do use the site regularly to post blogs and also have comments. It is not a production or professional blog or anything. Its more of a hobbyist and entertainment thing to me but I enjoy making the site available because it covers my wandering around in retirement.
Thanks for reading!
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
As you are seeing a database connection error, what I could suggest is tweaking your MySQL installation for better performance and reliability as described here:
Also, as a side note, you could also add a swap file so that you could have some extra memory buffer in case that your server runs out of memory:
Hope that this helps!