I am having an issue with my Ghost blog crashing every 5 days or so which causes a 502 Bad Gateway Error. To fix the issue, I just have to log in to Digital Ocean and cycle power to the server and everything boots back up and I can access my website again.
How can I prevent this intermittent shutdown behavior?
I have done some research on here and have a few ideas but am not sure where I should start, how to diagnose, and how to test.
Some articles suggest the Ghost mySQL instance causes the crash by triggering an out of memory error.
Another article I ready referred to Cloudflare cache causing hourly CPU spikes which could crash the ghost instance as well.
Possible fixes include: setting up a SWAP partition for memory, tuning the mySQL install using MySQLTuner, and playing with the cache settings in Cloudflare.
I tried to look at the mySQL error logs but I can only ssh to the server after restarting it, and the logs only show the shutdown and restart which I triggered.
I have very low traffic (less than 20 per day). I use ghost blog hosted by Digital Ocean VPS, domain from Namecheap, and Cloudflare for CDN.
These articles seem to describe the symptoms I am having:
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.