After moving one of my node from Linode to DigitalOcean, I have experienced strange crash that appears to be random. After I reboot the process it works for about a week and fails suddenly.
Tools for checking the data in the database
After some research, I think it could be caused by the data inside the database, since I moved all data from the old VPS to the new node and now I’m using a newer version of MySQL (Actually MariaDB). It could run into some compatibility problem.
I strongly recommand you to backup the database before running any checks, upgrade, repairs and optimize actions. You can do so with the command:
# cd ~
# mysqldump -A -p > mysql-all-databases.sql
This would check the status of all databases in the DB:
# mysqlcheck -aA -u root -p
This would repair the databases and tables if anything go wrong:
# mysqlcheck -rA -uroot -p
This would upgrade the data if you have upgraded the Mysql version:
# mysql_upgrade -uroot -p