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ó:
[email protected] 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:[email protected]] Sent: 09 February 2010 10:29To: [email protected]Subject: [Pacemaker] problem: mysql service duplicated due to existing pidfileHello everybody,
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Pacemaker mailing list [email protected] http://oss.clusterlabs.org/mailman/listinfo/pacemaker
