InfoScale™ 9.0 Cluster Server Agent for Sybase Installation and Configuration Guide - Solaris

Last Published:
Product(s): InfoScale & Storage Foundation (9.0)
Platform: Solaris
  1. Introducing the Cluster Server for Sybase
    1.  
      About the Cluster Server for Sybase
    2.  
      Supported software for the VCS agent for Sybase
    3.  
      How the agent makes Sybase highly available
    4.  
      How the Sybase and SybaseBk agents support intelligent resource monitoring
    5. About the Sybase agent functions
      1.  
        Sybase agent functions
      2.  
        SybaseBk agent functions
      3.  
        Using the IPC Cleanup feature for the Sybase agent
    6. Monitoring options for the Sybase agent
      1.  
        Monitoring Sybase instances running in Solaris Containers
    7.  
      Action function for the VCS agent for Sybase
    8.  
      Typical Sybase configuration in a VCS cluster
  2. Installing and configuring Sybase
    1. VCS requirements for installing Sybase
      1.  
        Sybase installation directory
      2.  
        SYBASE directory on shared disks
      3.  
        System Group and User for Sybase home directory
      4.  
        Database dbspaces
      5.  
        Transparent TCP/IP failover
      6.  
        Language settings for the Sybase agent
    2.  
      Installing Sybase in a VCS environment
    3.  
      Configuring Sybase for detail monitoring
  3. Installing, upgrading, and removing the agent for Sybase
    1.  
      Before you install or upgrade the agent for Sybase
    2.  
      Installing the agent for Sybase
    3.  
      Disabling the agent for Sybase
    4.  
      Removing the agent for Sybase
    5.  
      Upgrading the agent for Sybase
  4. Configuring VCS service groups for Sybase
    1.  
      About configuring service groups for Sybase
    2. Before configuring the service group for Sybase
      1.  
        Importing the SybaseTypes.cf file
    3.  
      Configuring the service groups for Sybase
    4.  
      Configuring the service group for Sybase from Cluster Manager (Java console)
    5.  
      Configuring the service group for Sybase using the command line
    6.  
      Encrypting passwords for Sybase
    7. About setting up detail monitoring for the agent for Sybase
      1.  
        Enabling detail monitoring for the agent for Sybase
      2.  
        Disabling detail monitoring for the agent for Sybase
    8.  
      Enabling and disabling intelligent resource monitoring (IMF) for agents
    9.  
      Administering the AMF kernel driver
  5. Administering VCS service groups for Sybase
    1.  
      About administering service groups for Sybase
    2.  
      Bringing the Sybase service group online
    3.  
      Taking the Sybase service group offline
    4.  
      Switching the Sybase service group
    5.  
      Modifying the Sybase service group configuration
    6.  
      Viewing the agent log for Sybase
  6. Appendix A. Resource type definitions for Sybase
    1.  
      About the resource type and attribute definitions for Sybase
    2. Sybase resource type
      1.  
        Type definition for the Sybase agent
      2.  
        Attribute definitions for the Sybase agent
    3. SybaseBk resource type
      1.  
        Type definition for the SybaseBk agent
      2.  
        Attribute definitions for the SybaseBk agent
  7. Appendix B. Sample configurations for Sybase
    1.  
      About the sample configuration for the Sybase agent
    2. Resource dependency graph for the Sybase agent
      1.  
        Resource dependency for Sybase configured in Solaris zones
    3.  
      Sample configuration for agent for Sybase on Solaris systems
    4. Sample main.cf files for Sybase ASE CE configurations
      1.  
        Sample main.cf for a basic Sybase ASE CE cluster configuration under VCS control with shared mount point on CFS for Sybase binary installation
      2.  
        Sample main.cf for a basic Sybase ASE CE cluster configuration with local mount point on VxFS for Sybase binary installation
      3.  
        Sample main.cf for a primary CVM VVR site
      4.  
        Sample main.cf for a secondary CVM VVR site
    5.  
      Sample configuration for the Sybase agent in Solaris zones

Sample main.cf for a secondary CVM VVR site

This sample main.cf is for a secondary site in a CVM VVR configuration. It is the second of two sample main.cfs for replicating data between two clusters.

The following are the configuration details for this Sybase ASE CE configuration sample main.cf:

  • File name: sybasece_cvmvvr_secondary_main.cf

  • File location: /etc/VRTSagents/ha/conf/Sybase

This is main.cf for CVM VVR configuration on Secondary site.
--------------------------------------------------------------

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

cluster cluster102 (
	       UserNames = { admin = HopHojOlpKppNxpJom }
        ClusterAddress = "10.190.99.199"
	       Administrators = { admin }
	       HacliUserLevel = COMMANDROOT
        UseFence=SCSI3
	       )

remotecluster syb_cluster101 (
	       ClusterAddress = "10.180.88.188"
	       )

heartbeat Icmp (
       	ClusterList = { syb_cluster101 }
	       Arguments @syb_cluster101 = { "10.180.88.188" }
	       )

system system3 (
	       )

system system4 (
	       )

group ClusterService (
	       SystemList = { system3 = 0, system4 = 1 }
	       AutoStartList = { system3, system4 }
								OnlineRetryLimit = 3 
	       OnlineRetryInterval = 120
	       )

        Application wac (
                StartProgram = "/opt/VRTSvcs/bin/wacstart"
                StopProgram = "/opt/VRTSvcs/bin/wacstop"
                MonitorProcesses = { "/opt/VRTSvcs/bin/wac" }
                RestartLimit = 3
                )

        IP gcoip (
                Device = eth0
                Address = "10.190.99.199"
                NetMask = "255.255.255.0"
                )

        NIC csgnic (
                Device = eth0
                )

        gcoip requires csgnic
        wac requires gcoip

	// resource dependency tree
	//
	//	group ClusterService
	//	{
	//	Application wac
	//	    {
	//	    IP gcoip
	//	        {
	//	        NIC csgnic
	//	        }
	//	    }
	//	}


group RVGgroup (
        SystemList = { system3 = 0, system4 = 1 }
        Parallel = 1
        AutoStartList = { system3, system4 }
        )

        CVMVolDg sybdata_voldg (
                CVMDiskGroup = sybdata_101
                CVMActivation = sw
                )

        RVGShared sybdata_rvg (
                RVG = syb_rvg
                DiskGroup = sybdata_101
                )

        requires group binmnt online local firm
        sybdata_rvg requires sybdata_voldg


group binmnt (
        SystemList = { system3 = 0, system4 = 1 }
        Parallel = 1
        AutoStartList = { system3, system4 }
 							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

group cvm (
        SystemList = { system3 = 0, system4 = 1 }
        AutoFailOver = 0
        Parallel = 1
        AutoStartList = { system3, system4 }
        )

        CFSfsckd vxfsckd (
                )

        CVMCluster cvm_clus (
                CVMClustName = syb_cluster102
                CVMNodeId = { system3 = 0, system4 = 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
        //              }
        //          }
   

group logowner (
        SystemList = { system3 = 0, system4 = 1 }
        AutoStartList = { system3, system4 }
        )

        IP logowner_ip (
                Device = eth0
                Address = "10.11.9.102"
                NetMask = "255.255.255.0"
                )

        NIC nic (
                Device = eth0
                )

        RVGLogowner rvg_logowner (
                RVG = syb_rvg
                DiskGroup = sybdata_101
                )

        requires group RVGgroup online local firm
        logowner requires logowner_ip
        logowner_ip requires nic


	// resource dependency tree
	//
	//	group logowner
	//	{
	//	RVGLogowner rvg_logowner
	//	    {
	//	    IP logowner_ip
	//	        {
	//	        NIC nic
	//	        }
	//	    }
	//	}

group sybasece (
        SystemList = { system3 = 0, system4 = 1 }
        Parallel = 1
        ClusterList = { syb_cluster102 = 0, syb_cluster101 = 1 }
        AutoStartList = { system3, system4 }
 							OnlineRetryLimit = 3 
        OnlineRetryInterval = 120
        )

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

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

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

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

        RVGSharedPri syb_vvr_shpri (
                RvgResourceName = sybdata_rvg
                OnlineRetryLimit = 0
                )

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

requires group RVGgroup online local firm
sybdata_101_sybvol_mnt requires syb_vvr_shpri
ase requires vxfend
ase requires sybdata_101_sybvol_mnt
ase requires quorum_101_quorumvol_mnt
quorum_101_quorumvol_mnt requires quorum_101_voldg