[ClusterLabs] detecting MySQL database corruption

[Andrei Borzenkov]

On 29.06.2021 19:23, john tillman wrote:
>> 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?
> 

mysql agent help output or source code.

<parameter name="test_table" unique="0" required="0">
<longdesc lang="en">
Table to be tested in monitor statement (in database.table notation)
</longdesc>
<shortdesc lang="en">MySQL test table</shortdesc>
<content type="string" default="${OCF_RESKEY_test_table_default}" />
</parameter>

Additionally you need to set OCF_CHECK_LEVEL to non-zero value.

> 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
> 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/
>