分类： Mysql/postgreSQL
2007-06-21 08:41:27
管理节点的脚本: mgmd_keepalive.sh
1, ps afx | grep -w ndb_mgmd | grep -v grep &> /dev/null 中加-w是为了避免把mgmd_keepalive.sh 当作管理进程
2, $? 只针对上一个语句有效.
#!/bin/bash
#
# mgmd_keepalive.sh
#
echo "**********************************************************************" >> /var/log/mgmd-restart-log
echo "Check date: `date`" >> /var/log/mgmd-restart-log
ps afx | grep -w ndb_mgmd | grep -v grep &> /dev/null
if [ $? == 0 ] ; then
echo "mgmd is ok ">> /var/log/mgmd-restart-log
else
# NDBD is dead
echo "ERROR !----------------NDBD is dead!------------------" >>/var/log/mgmd-restart-log
/usr/local/bin/ndb_mgmd -f /var/lib/mysql-cluster/config.ini
wall "mgmd_keepalive.sh restarted mgmd">>/var/log/mgmd-restart-log
echo -n "mgmd_keepalive.sh restarted mgmd:" >> /var/log/mgmd-restart-log
fi
exit 0
数据节点的启动脚本:
[root@ls-db-10 meil]# vi ndbd_keepalive.sh
#!/bin/bash
#
# ndbd_keepalive.sh
#
# Checks that ndbd, the storage daemon for MySQL Cluster,
# is running. If it is not, start it with -n (nostart)
# to allow administrator to start it from within the
# management client
echo "**********************************************************************" >> /var/log/ndbd-restart-log
echo "Check date: `date`" >> /var/log/ndbd-restart-log
ps afx | grep -w ndbd | grep -v grep &> /dev/null
if [ $? == 0 ] ; then
echo "ndbd is ok ">> /var/log/ndbd-restart-log
else
# NDBD is dead
echo "ERROR !----------------NDBD is dead!------------------" >>/var/log/ndbd-restart-log
/usr/local/mysql/bin/ndbd -n
wall "ndbd_keepalive.sh restarted ndbd">>/var/log/ndbd-restart-log
echo -n "ndbd_keepalive.sh restarted ndbd:" >> /var/log/ndbd-restart-log
fi
exit 0
