求高手解！heartbeat+mysql问题

[ml_yin]

我按照网上常用的方式配置heartbeat+mysql，主主复制已经配置成功，heartbeat监听也没问题，主服务器网线被我拔掉，能够切换到从服务器进行操作，主服务器正常之后，heartbeat切换也能够正常切换回去，但是，这时候我的从服务器mysql就已经停止了 需要手动start开启，请问怎么解.

[ml_yin]

哎 只能自己写个启动脚本

[ACMAIN_CHM]

检查一下从机上的错误日志，看看有什么信息可供分析？

[ml_yin]

mysql.err中的log

100702 10:14:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
100702 10:14:24 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100702 10:14:24 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.
100702 10:14:24 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=slave-relay-bin' to avoid this problem.
100702 10:14:24 [Note] Event Scheduler: Loaded 0 events
100702 10:14:24 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.47-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
100702 10:14:24 [Note] Slave SQL thread initialized, starting replication in log 'updatelog.000012' at position 4, relay log './slave-relay-bin.000017' position: 149
100702 10:14:24 [Note] Slave I/O thread: connected to master 'digital@10.0.0.1:3306',replication started in log 'updatelog.000012' at position 106
100702 10:19:44 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

100702 10:19:44 [Note] Slave I/O thread killed while reading event
100702 10:19:44 [Note] Slave I/O thread exiting, read up to log 'updatelog.000012', position 435
100702 10:19:44 [Note] Event Scheduler: Purging the queue. 0 events
100702 10:19:44 [Note] Error reading relay log event: slave SQL thread was killed
100702 10:19:46 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

100702 10:19:46 mysqld_safe mysqld from pid file /usr/local/mysql/var/slave.digital.com.pid ended
100702 10:20:44 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
100702 10:20:44 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100702 10:20:44 [Warning] 'for replication startup options' is deprecated and will be removed in a future release. Please use ''CHANGE MASTER'' instead.
100702 10:20:44 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=slave-relay-bin' to avoid this problem.
100702 10:20:44 [Note] Slave SQL thread initialized, starting replication in log 'updatelog.000012' at position 435, relay log './slave-relay-bin.000019' position: 580
100702 10:20:44 [Note] Event Scheduler: Loaded 0 events
100702 10:20:44 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.47-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
100702 10:20:44 [Note] Slave I/O thread: connected to master 'digital@10.0.0.1:3306',replication started in log 'updatelog.000012' at position 435