MYSQL keeps breaking down after restore.
This is probably the strangest of all issues I have ever seen:
My MYSQL database on my node keeps breaking down for apparently no reason. It begun about a week ago. I went to check my site and got a:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
Now, I have an Aegir (Drupal) system that has been running for a year without issues and that requires for the bind setting in the my.cnf to be disabled.
Well, I restore it using reinstalling MYSQL using:
dpkg -l | awk '{print $2}' | grep mysql > installed_packages.txt
apt-get remove cat installed_packages.txt
apt-get install cat installed_packages.txt
and it was all fine. Aegir was back up and all looked fine.
24 hours later, the MYSQL server is down again.
I am at a lost as of why this is suddenly happening, specially why it all seems fine and then breaks down again.
Anyone with any tips or suggestions or hints as why this maybe happening?
Thanks.
7 Replies
Thanks for the help people.