MySQL Directory Files Corrupt on Node

9 views
Skip to first unread message

Dean McDowell

unread,
Sep 23, 2019, 4:17:50 AM9/23/19
to Percona Discussion

Hi oracles I hope everyone is well!

 

I have a situation with a Galera Cluster I have running (master-master-master) and I hope someone has the answer.  At this point I must apologise, this is my first Percona XtraDB cluster so I am treading carefully at every turn. 

 

The issue I have is that the cluster is running with 2 nodes at the minute as one of the nodes ran into an issue and subsequently the MySQL directory has been emptied.

 

SO!  MySQL directory is completely empty now (all files had been manually deleted as there were corrupted (this didn't affect the clusters data, thankfully).

 

Am I right in saying that I can go ahead and just start this node with the standard "systemctl start mysql" and the Cluster will take care of the rest, IE. the newly added node will get all required files from the cluster before it is fully synced and writable?

 

Any advice or pointers would be great.

 

Thanks heroes!

Reply all
Reply to author
Forward
0 new messages