>>> "john tillman" <[email protected]> schrieb am 29.06.2021 um 18:23 in Nachricht <[email protected]>: >> On 29.06.2021 18:14, john tillman wrote: >>> Hello All, >>> >>> I was wondering if there was a way I can move a resource in response to >>> a >>> corrupted MySQL innodb database? So, MySQL service would be running, >>> just >>> the database/table I need access to is corrupted. >> >> Define "corrupted". MySQL resource agent can be told to connect to >> database and query some table. If you need something more, you need to >> first describe how you are going to detect "corruption". >> > > Really?!?! That sounds like just what I need. Would you mind pointing me > to the documentation for how to do this? > > In my case, the corruption would be the result of a power failure of the > node. I presume that if that occurred there could be many possible ways
Sorry, this won't answer your question, but if your database is corrupted after a power failure, either the database has a bug, or yopur configuration is significantly broken (like using disk write caches). Would your configuration survive fencing via power off? Regards, Ulrich > the databases could be corrupted, ie. I can't read/write from/to a table. > > Thank you very much for pointing me to it! > > Best regards, > John > > >>> I've been scanning >>> through the documentation but I cannot find anything obvious. >>> >>> Best regards, >>> John >>> >>> _______________________________________________ >>> Manage your subscription: >>> https://lists.clusterlabs.org/mailman/listinfo/users >>> >>> ClusterLabs home: https://www.clusterlabs.org/ >>> >> >> _______________________________________________ >> Manage your subscription: >> https://lists.clusterlabs.org/mailman/listinfo/users >> >> ClusterLabs home: https://www.clusterlabs.org/ >> >> > > > _______________________________________________ > Manage your subscription: > https://lists.clusterlabs.org/mailman/listinfo/users > > ClusterLabs home: https://www.clusterlabs.org/ _______________________________________________ Manage your subscription: https://lists.clusterlabs.org/mailman/listinfo/users ClusterLabs home: https://www.clusterlabs.org/
