[ClusterLabs] Antw: [EXT] Re: detecting MySQL database corruption

[Ulrich Windl]

>>> "john tillman" <johnt at panix.com> schrieb am 29.06.2021 um 18:23 in Nachricht
<96b920558fc9165cbd5351b091a483fc.squirrel at mail.panix.com>:
>>  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/