Problem with HA configuration

I followed this guide to setup my HA server

http://library.linode.com/linux-ha/ip-f … untu-10.04">http://library.linode.com/linux-ha/ip-failover-heartbeat-pacemaker-drbd-mysql-ubuntu-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

1 Reply

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.)

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct