MySQL High availability with VCS cluster

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 Trudeau

I 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.
This entry was posted in HA, mysql, yves. Bookmark the permalink.

Comments are closed.