[Pacemaker] Upgraded mysql from 5.0 to 5.1

[Raoul Bhatia [IPAX]]

On 07/02/2010 11:18 PM, Jake Bogie wrote:
> Receiving this error when running crm status...the only thing I can
> think of is that since the upgrade to MySQL 5.1 the service name was
> changed from mysqld to mysql.
> 
> Any thoughts on how to correct it?

what i would do:

1. crm resource stop mysqld
2. crm resource cleanup mysqld

3. crm configure edit mysqld
-> rename from lsb:mysqld to lsb:mysql

4. crm resource start mysqld

actually, i would not do 3 but would switch over to the ocf script
that is provided by heartbeat/pacemaker:

primitive mysql-server ocf:heartbeat:mysql \
        op monitor interval="30s" timeout="30s" \
        op start interval="0" timeout="120" \
        op stop interval="0" timeout="120" \
        params config="/etc/mysql/my.cnf" datadir="/data/db/mysql/data/"
socket="/var/run/mysqld/mysqld.sock" binary="/usr/sbin/mysqld"
pid="/var/run/mysqld/mysqld.pid"

(the "params line" should be one single line)

cheers,
raoul
-- 
____________________________________________________________________
DI (FH) Raoul Bhatia M.Sc.          email.          r.bhatia at ipax.at
Technischer Leiter

IPAX - Aloy Bhatia Hava OG          web.          http://www.ipax.at
Barawitzkagasse 10/2/2/11           email.            office at ipax.at
1190 Wien                           tel.               +43 1 3670030
FN 277995t HG Wien                  fax.            +43 1 3670030 15
____________________________________________________________________