[Pacemaker] ocf:heartbeat:mysql RA: op monitor

[Oscar Remí­rez de Ganuza Satrústegui]

Hello!

I have one question regarding the ocf:heartbeat:mysql RA.

I supposed that the following params defined on the resource were to 
being used by the monitor operation to check the status of the mysql 
service: test_passwd="password" test_table="ldirectord.connectioncheck" 
test_user="servicecheck"
And that's what the crm is telling me:

* test_user (string, [root]): MySQL test user
    MySQL test user
* test_passwd (string): MySQL test user password
    MySQL test user password
* test_table (string, [mysql.user]): MySQL test table
    Table to be tested in monitor statement (in database.table notation)

But in my tests, they are not working as expected: they are always 
telling me that the service is ok, even if i do not have the user 
"servicecheck" defined on the database, and also if I "stop" (kill 
-SIGSTOP) the mysql process.

How can they be used to check the status of the mysql service?

Thanks very much again!!

---
Oscar Remírez de Ganuza
Servicios Informáticos
Universidad de Navarra
Ed. de Derecho, Campus Universitario
31080 Pamplona (Navarra), Spain
tfno: +34 948 425600 Ext. 3130
http://www.unav.es/SI

Oscar Remí­rez de Ganuza Satrústegui escribió:
>
> Darren.Mansell at opengi.co.uk escribió:
>> Hello Oscar.
>>
>> We use the OCF RA for MySQL and have not had any problems. Our config 
>> is:
>>
>> primitive MySQL ocf:heartbeat:mysql \
>>         params binary="/usr/bin/mysqld_safe" config="/etc/my.cnf" 
>> datadir="/data/mysql" user="mysql" pid="/var/lib/mysql/mysql.pid" 
>> socket="/var/lib/mysql/mysql.sock" test_passwd="password" 
>> test_table="ldirectord.connectioncheck" test_user="servicecheck" \
>>         op monitor interval="20s" timeout="10s" \
>>         meta migration-threshold="10" target-role="Started"
>>
>> LSB RA's are always a last resort IMO.
>>
>> Regards
>> Darren
>>
>> -----Original Message-----
>> From: Oscar Remírez de Ganuza Satrústegui [mailto:oscarrdg at unav.es] 
>> Sent: 09 February 2010 10:29
>> To: pacemaker at clusterlabs.org
>> Subject: [Pacemaker] problem: mysql service duplicated due to 
>> existing pidfile
>>
>> Hello everybody,
>>
>>
>>   

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 4422 bytes
Desc: S/MIME Cryptographic Signature
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20100209/b67cf60c/attachment-0004.bin>