Chinaunix首页 | 论坛 | 博客
  • 博客访问: 902399
  • 博文数量: 584
  • 博客积分: 2293
  • 博客等级: 大尉
  • 技术积分: 3045
  • 用 户 组: 普通用户
  • 注册时间: 2006-03-28 11:15
文章分类

全部博文(584)

文章存档

2012年(532)

2011年(47)

2009年(5)

我的朋友

分类: Mysql/postgreSQL

2011-12-27 23:26:45

At MySQL/Sun we do a lot of high availability setup using Heartbeat but recently I was involved, along with Harold Mayfield (a VCS expert), in project using Symantec VCS on Solaris. Of course, MySQL works perfectly well with VCS, here are a few highlights of the installation.

Apart from the share store resources and the IP resources, MySQL is configured as the following:

Application insiderDB-app ( StartProgram = "/san/mysql/bin/mysqld --defaults-file=/etc/my.cnf &" StopProgram = "/san/mysql/bin/mysqladmin -u root shutdown" MonitorProgram = "/san/vcs_scripts/mysql_monitor" )

and the mysql_monitor script is the following:

#!/bin/ksh STATUS=$(/usr/bin/echo status | /san/mysql/bin/mysql -u root 2>/dev/null |/usr/bin/grep -c Uptime) if [ "$STATUS" -eq "1" ] then exit 110 else exit 100 fi
About Yves TrudeauI work as a senior consultant in the MySQL professional services team at Sun. My main areas of expertise are DRBD/Heartbeat and NDB Cluster. I am also involved in the WaffleGrid project.
阅读(1611) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~