[ClusterLabs] detecting MySQL database corruption

[john tillman]

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

Thank you very much!

Best regards,
John


>> 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/
>>
>
> _______________________________________________
> Manage your subscription:
> https://lists.clusterlabs.org/mailman/listinfo/users
>
> ClusterLabs home: https://www.clusterlabs.org/
>
>