Cluster Server 8.0 Agent for Sybase Installation and Configuration Guide - Solaris

Sample main.cf for a basic Sybase ASE CE cluster configuration under VCS control with shared mount point on CFS for Sybase binary installation

This sample main.cf is for a single site with a basic cluster configuration with shared mount point on CFS for Sybase binary installation.

include "types.cf"
include "CFSTypes.cf"
include "CVMTypes.cf"
include "SybaseTypes.cf"

cluster cluster101 (
	   UserNames = { admin = HopHojOlpKppNxpJom }
	   Administrators = { admin }
	   HacliUserLevel = COMMANDROOT
    UseFence=SCSI3
	   )

system system1 (
	   )

system system2 (
	   )

// binmounts group for configuring CFS mounts for Sybase binaries.

group binmnt (
	   SystemList = { system1 = 0, system2 = 1 }
	   Parallel = 1
	   AutoStartList = { system1, system2 }
				OnlineRetryLimit = 3 
	   OnlineRetryInterval = 120
	   )

	   CFSMount sybbindg_101_sybbinvol_mnt (  
		       MountPoint = "/sybase"
		       BlockDevice = "/dev/vx/dsk/sybbindg_101/sybbin_vol"
	       	)

	   CVMVolDg sybbindg_101_voldg (
		       CVMDiskGroup = sybbindg_101
		       CVMVolume = { sybbin_vol }
		       CVMActivation = sw
		       )

	requires group cvm online local firm
	sybbindg_101_sybbinvol_mnt requires sybbindg_101_voldg


	// resource dependency tree
	//
	//	group binmnt
	//	{
	//	CFSMount sybbindg_101_sybbinvol_mnt
	//	    {
	//	    CVMVolDg sybbindg_101_voldg
	//	    }
	//	}

// cvm group for CVM and CFS specific agents.

group cvm (
	   SystemList = { system1 = 0, system2 = 1 }
	   AutoFailOver = 0
	   Parallel = 1
	   AutoStartList = { system1, system2 }
	   )

	   CFSfsckd vxfsckd (
	      	)

	   CVMCluster cvm_clus (
		      CVMClustName = sfsyb_90
	   	   CVMNodeId = { system1 = 0, system2 = 1 }
		      CVMTransport = gab
		      CVMTimeout = 200
		      )

	   CVMVxconfigd cvm_vxconfigd (
		      Critical = 0
		      CVMVxconfigdArgs = { syslog }
		      )

	cvm_clus requires cvm_vxconfigd
	vxfsckd requires cvm_clus


	// resource dependency tree
	//
	//	group cvm
	//	{
	//	CFSfsckd vxfsckd
	//	    {
	//	    CVMCluster cvm_clus
	//	        {
	//	        CVMVxconfigd cvm_vxconfigd
	//	        }
	//	    }
	//	}

// sybasece group for:
// 1. CVM volumes for Sybase database and quorum device
// 2. CFS mount for Sybase database and quorum device
// 3. Process agent for vxfend process.
// 4. Sybase database instance.

group sybasece (
	   SystemList = { system1 = 0, system2 = 1 }
	   Parallel = 1
	   AutoStartList = { system1, system2 }
				OnlineRetryLimit = 3 
	   OnlineRetryInterval = 120
	   )

	   CFSMount quorum_101_quorumvol_mnt (
	      	MountPoint = "/quorum"
		      BlockDevice = "/dev/vx/dsk/quorum_101/quorumvol"
		      )

	   CFSMount sybdata_101_sybvol_mnt (
	      	MountPoint = "/sybdata"
		      BlockDevice = "/dev/vx/dsk/sybdata_101/sybvol"
	      	)

	   CVMVolDg quorum_101_voldg (
		      CVMDiskGroup = quorum_101
	      	CVMVolume = { quorumvol }
	      	CVMActivation = sw
		      )

	   CVMVolDg sybdata_101_voldg (
		      CVMDiskGroup = sybdata_101
		      CVMVolume = { sybvol }
	      	CVMActivation = sw
	      	)

	  Process vxfend (
	      	PathName = "/sbin/vxfend"
	      	Arguments = "-m sybase -k /var/VRTSvcs/log/tmp/vcmp_socket"
	      	)

	  Sybase ase (
		      Server @system1 = ase1
		      Server @system2 = ase2
		      Owner = sybase
		      Home = "/sybase"
		      Version = 15
		      SA = sa
		      Quorum_dev = "/quorum/q.dat"
		      )

	requires group binmnt online local firm
	ase requires quorum_101_quorumvol_mnt
	ase requires sybdata_101_sybvol_mnt
	ase requires vxfend
	quorum_101_quorumvol_mnt requires quorum_101_voldg
	sybdata_101_sybvol_mnt requires sybdata_101_voldg


	// resource dependency tree
	//
	//	group sybasece
	//	{
	//	Sybase ase
	//	    {
	//	    CFSMount quorum_101_quorumvol_mnt
	//	        {
	//	        CVMVolDg quorum_101_voldg
	//	        }
	//	    CFSMount sybdata_101_sybvol_mnt
	//	        {
	//	        CVMVolDg sybdata_101_voldg
	//	        }
	//	    Process vxfend
	//	    }
	//	}