I followed this guide to setup my HA server
http://library.linode.com/linux-ha/ip-f ... untu-10.04

Everything looks OK until I put ha-1 on standby. It seems mysql would not start on ha-1. Can you let me know what probably went wrong?

============
Last updated: Thu Mar 22 17:54:19 2012
Stack: Heartbeat
Current DC: ha-1 (d358e59e-f135-408f-ab22-007ea41a372d) - partition with quorum
Version: 1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd
2 Nodes configured, 1 expected votes
4 Resources configured.
============

Node ha-1 (d358e59e-f135-408f-ab22-007ea41a372d): standby
Online: [ ha-2 ]

Resource Group: MySQLDB
fs_mysql (ocf::heartbeat:Filesystem): Started ha-1 (unmanaged) FAILED
mysql (ocf::heartbeat:mysql): Stopped
Master/Slave Set: ms_drbd_mysql
Masters: [ ha-1 ]
Slaves: [ ha-2 ]
Master/Slave Set: ms_drbd_webfs
Masters: [ ha-2 ]
Stopped: [ drbd_webfs:0 ]

Failed actions:
fs_mysql_stop_0 (node=ha-1, call=52, rc=1, status=complete): unknown error
ip1_monitor_5000 (node=ha-1, call=25, rc=7, status=complete): not running

Thanks,
Chunan

I know this is a really old thread, but if it's helpful to anyone, I tracked this down in the syslog to an issue with InnoDB tables and DRBD. I don't use InnoDB so I disabled it in /etc/mysql/my.cnf:

ignore_builtin_innodb
default_storage_engine=MyISAM

Now MySQL starts just fine on failover. (I have an ongoing issue I'm still troubleshooting where the IP doesn't fail over, but at least this appears to be working.)