Problem with HA configuration
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
1 Reply
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.)