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:
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.