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 |
Good Luck!