Storage Foundation for Sybase ASE CE 7.4.1 Configuration and Upgrade Guide - Linux

Sample main.cf for a basic Sybase ASE CE cluster configuration with local mount point on VxFS for Sybase binary installation

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

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

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

system system1 (
	   )

system system2 (
	   )

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

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

				DiskGroup sybbin_dg_voldg (
									DiskGroup = sybbindg
									)

	   Mount sybbin_dg_sybbin_vol_mnt (  
		       MountPoint = "/sybase"
		       BlockDevice = "/dev/vx/dsk/sybbin_dg/sybbin_vol"
									FSType = vxfs
									FsckOpt = "-y"
	       	)

	   Volume sybbin_dg_vol (
		       DiskGroup = sybbindg
		       Volume = sybbin_vol
		       )

	requires group cvm online local firm
	sybbin_dg_sybbin_vol_mnt requires sybbin_dg_vol
 sybbin_dg_vol requires sybbin_dg_voldgdg


	// resource dependency tree
	//
	//	group binlocalmnt
	//	{
	//	Mount sybbin_dg_sybbin_vol_mnt
	//	    {
	//	    Volume sybbindg_vol
 //         {
 //         DiskGroup sybbin_dg_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 = clus1
	   	   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_dg_quorum_vol_mnt (
	      	MountPoint = "/quorum"
		      BlockDevice = "/dev/vx/dsk/quorum_dg/quorum_vol"
		      )

	   CFSMount dbdata_dg_sybvol_mnt (
	      	MountPoint = "/sybdata"
		      BlockDevice = "/dev/vx/dsk/dbdata_dg/sybvol"
	      	)

	   CVMVolDg quorum_dg_voldg (
		      CVMDiskGroup = quorum_dg
	      	CVMVolume = { quorum_vol }
	      	CVMActivation = sw
		      )

	   CVMVolDg dbdata_dg_voldg (
		      CVMDiskGroup = dbdata_dg
		      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 binlocalmnt online local firm
	ase requires quorum_dg_quorum_vol_mnt
	ase requires dbdata_dg_sybvol_mnt
	ase requires vxfend
	quorum_dg_quorum_vol_mnt requires quorum_dg_voldg
	dbdata_dg_sybvol_mnt requires dbdata_dg_voldg


	// resource dependency tree
	//
	//	group sybasece
	//	{
	//	Sybase ase
	//	    {
	//	    CFSMount quorum_dg_quorum_vol_mnt
	//	        {
	//	        CVMVolDg quorum_dg_voldg
	//	        }
	//	    CFSMount dbdata_dg_sybvol_mnt
	//	        {
	//	        CVMVolDg dbdata_dg_voldg
	//	        }
	//	    Process vxfend
	//	    }
	//	}