Droplet regularly but intermittently returning timeout and 'error establishing database connection' errors

Question

I have a simple Wordpress install on my droplet, and yet my website is so far pretty much unusable thanks to the regular (every few minutes or so) drop outs in service.

I don’t know how to approach this problem, as I don’t understand any of the solutions that come up if I search it. Are there any easy fixes to this? (clearly the site setup is working as I can connect to it. It just returns these errors regularly even when making no changes).

I admit I took on too much by deciding to use DigitalOcean for my site, but I didn’t expect it to be this unreliable, as I’ve set up Wordpress installs many times in the past. If it’s not easy to fix then I guess I’ll have to move elsewhere. Again.

https://lewisheriz.com/

KFSys · Answer

Hi @lewisshark , It’s possible your resources are not enough and your Droplet kills your Database just to say alive. Having said that, try adding SWAP to your Droplet to see if that would help with your problem - https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-20-04

alexdo · Answer

Heya, This crash is most likely due to your system running out of memory. I’d suggest that you add a swap file to give yourself a bit more of a buffer. Check out this tutorial: How To Add Swap on Ubuntu You will most definitely need to upgrade your droplet as you’re running out of memory and your application/website needs more resources in order to continue to operate. What you can also do is to use the MySQLTuner script. The MySQLTuner is a script written in Perl and allows you to quickly test your MySQL configuration and it gives you suggestions for adjustments to increase performance and stability. According to the official GitHub page, it supports 300 indicators for MySQL/MariaDB/Percona Server in this last version. To run the script you could do the following: SSH to your Droplet Download the script: wget http://mysqltuner.pl/ -O mysqltuner.pl Copy Then execute it: perl mysqltuner.pl Copy The script would run multiple checks against your MySQL instance, all checks done by MySQLTuner are documented here . Also as stated in the official documentation, it is still extremely important for you to fully understand each change you make to a MySQL database server. If you don’t understand portions of the script’s output, or if you don’t understand the recommendations, you should consult a knowledgeable DBA or system administrator that you trust. As a good practice make sure to always test your changes on staging environments before implementing them on your production database. On the same note, if you want to have a worry-free MySQL hosting and focus on your application, I would recommend trying out the DigitalOcean Managed Databases: https://www.digitalocean.com/products/managed-databases-mysql/ This was mini tutorial was posted from bobbyiliev in this question in our community: https://www.digitalocean.com/community/questions/how-to-tweak-mysql-mariadb-configuration-for-increased-performance-and-stability You can also create a simple bash script to check if MySQL is running and if not to restart it. #!/bin/bash # Check if MySQL is running sudo service mysql status > /dev/null 2>&1 # Restart the MySQL service if it's not running. if [ $? != 0 ]; then sudo service mysql restart fi Copy Run this script every 5 minutes using a cron job like this one: */5 * * * * /home/user/scripts/monitor.sh > /dev/null 2>&1 Copy Hope that this helps!

Become a contributor for community

DigitalOcean Documentation

Resources for startups and AI-native businesses

The developer cloud

Start building today

Report this

Droplet regularly but intermittently returning timeout and 'error establishing database connection' errors

Related questions

How can I reduce slow image loading on a WordPress website?

Best way to configure Nginx caching for a WordPress site on a DigitalOcean droplet?

How can I improve the loading speed of my WordPress travel website?

Problem on wordpress Digital Ocean Droplet One-Click

Website redirecting to another site on same droplet after moving droplets

Load and CPU Spikes

What’s the best way to secure a DigitalOcean Droplet running WordPress against brute-force attacks?

How to update PHP version to 8.3 on a droplet?

New cloud hosting solution

how to access droplet console for wordpress 1click install

Move DigitalOcean WP site to another DigitalOcean WP site

How do you set up a development and test server for staging production server changes?

Report this

Droplet regularly but intermittently returning timeout and 'error establishing database connection' errors

Related questions

How can I reduce slow image loading on a WordPress website?

Best way to configure Nginx caching for a WordPress site on a DigitalOcean droplet?

How can I improve the loading speed of my WordPress travel website?

Problem on wordpress Digital Ocean Droplet One-Click

Website redirecting to another site on same droplet after moving droplets

Load and CPU Spikes

What’s the best way to secure a DigitalOcean Droplet running WordPress against brute-force attacks?

How to update PHP version to 8.3 on a droplet?

New cloud hosting solution

how to access droplet console for wordpress 1click install

Move DigitalOcean WP site to another DigitalOcean WP site

How do you set up a development and test server for staging production server changes?