So I have a two-node failover cluster in WinServer 2008 R2, I also created a generic service which will manage my MySQL5.5 database (the database root is also in a iSCSI storage).
When the cluster carries to the other node, the MySQL generic service won't start, I have found somewhat a fix to the problem by deleting the 3 log_files in the database root then manually bringing the service online again, but when the cluster switches to the other node, I have to perform the process again.
Is there any permanent way which can fix this problem? I don't want to delete the files everytime the cluster failovers.
TIA!