MySQL8 Stopped responding - Restored , up and running now - resolved

We rebooted the node, but it was not a node issue. MySQL8 is still having an issue and we are going to run a FSCK on it now.
 
We have done fsck it fixed a few errors, mysql is starting but it doesn't seem to be responding, we are looking at making it on a new node now and bringing live from there.
 
We have found the core issue seems to be in some database tables and looks they may need to be restored, so we are going with a dual process on restoring to a new server and working on fixing on the current. This issue cropped up quite suddenly but upgrades were just done in Hsphere and we're verifying there was no issue there to cause this as well.
 
Mysql-8 is giving read-only file system, we're trying run file system check once again to repair it and see if that helps.

On the other side, we're in process of preparing a new server with restoring all dbs'.
 
Restoration process is running currently on the new server which is done approx 20% on it.
Old mysql-8 is completely down and working on it.
 
Mysql server restored completely and mysql service is running fine on it from last 30 min.

In case you'll face any issues with mysql then please come on live and raise support ticket.
 
You must log in or register to reply here.
Back
Top