Creating a Cluster Using ASE Plug-in

The Adaptive Server plug-in includes a wizard that steps you through the process of creating, and starting a cluster.

1. Register the Adaptive Server plug-in.
2. Start Sybase Central.
3. Select the Adaptive Server Enterprise icon in the left pane.
4. Select the Utilities tab in the right pane.
5. Double click or right click on Create Cluster and select open to open the Create Cluster wizard. Or you can select Tools > Adaptive Server Enterprise > Create Cluster to start the Create Cluster wizard.
6. Enter the name of the cluster.
7. Select the platform from the drop-down list.
8. Select whether you are creating a Shared or Private installation.
9. Select the maximum number of instances you plan to use for this cluster. Click Next.
10. Discovery settings – you can change the settings the Adaptive Server plug-in uses to find nodes to use for the cluster. For more information see “Administering Clusters” in the Users Guide to Clusters.
11. Select the hosts that participate in the cluster. You can also click on Specify Node to specify a node that does not appear in the list of hosts.
12. Enter the unified agent user name and password. Select Next.
13. Quorum device path – enter the full path to the quorum device. Click Next.
14. If you are installing a private installation this step is skipped until you specify the instances in the cluster. If this is a shared installation you are prompted at this time to enter:
    
    • Sybase home – the Adaptive Server release directory (also the value of $SYBASE).
    • Adaptive Server Enterprise home – the full path to the ASE-15_0 directory (the value of $SYBASE/$SYBASE_ASE).
    • Interfaces directory – path to the directory containing the interfaces file.
    • Cluster configuration file – full path to the cluster configuration file.
    • Sybase environment script – full path to the script that you use to set the environment variables.
    • Start parameters – list any startup parameters for the cluster.
    • Trace flags – list any trace flags you want used at startup.
    Click Next
15. Enter the master device information:
    
    • Master device path – full path to the master device.
    • Device size – size in megabytes (MB), gigabytes (GB), or terabytes (TB).
    • Database size – size in megabytes (MB), gigabytes (GB), or terabytes (TB).
    • Page size – page size of the instance; 2-, 4-, 8-, or 16K (the default is 2K).
    Click Next.
16. If the device you specify does not include SCSI-3 PGR capability, Adaptive Server plug-in asks if you wish to continue. If you select No, the plug-in does not move to the next screen.
17. Enter the system procedures (sybsystemprocs) information:
    
    • System procedures device – full path to the sybsystemprocs device.
    • Device size – size in megabytes (MB), gigabytes (GB), or terabytes (TB).
    • Database size – size in megabytes (MB), gigabytes (GB), or terabytes (TB).
    Click Next.
18. If the device you specify does not include SCSI-3 PGR capability, Adaptive Server plug-in asks if you wish to continue. If you select No, the plug-in does not move to the next screen.
19. Enter the system database (sybsystemdb) information:
    
    • System database device – full path to the sybsystemdb device.
    • Device size – size in megabytes (MB), gigabytes (GB), or terabytes (TB).
    • Database size – size in megabytes (MB), gigabytes (GB), or terabytes (TB).
    If the device you specify does not include SCSI-3 PGR capability, Adaptive Server plug-in asks if you wish to continue. If you select No, the plug-in does not move to the next screen. Click Next.
20. Select the checkbox to enter a PCI device. Enter the full path to the PCI device and enter the device and database size. Click Next. See Java in Adaptive Server Enterprise for more information about PCI devices.
21. If the device you specify does not include SCSI-3 PGR capability, Adaptive Server plug-in asks if you wish to continue. If you select No, the plug-in does not move to the next screen.
22. Verify the following or change to appropriate values:
    
    • Network Protocol – select the UDP network protocol.
    • Starting Port – select a starting port number for the cluster’s network interconnects. Make certain this port number is not already in use.
    • Check the box if you have a secondary network available.
23. Click Validate Port to make sure the ports are not currently in use, then click Next.
24. Specify the instances for the cluster. Click Add to add instances to the list.
25. In the Define Server Instance dialog, enter the following under the General tab for each instance you are adding to the cluster:
    
    • Instance name – the name of the instance.
    • Node – select the node.
    • Query port – select the port number for the query port entry in the interfaces file.

      Select Validate Port to make sure this port is available.

    • Log file – full path to the error log for this instance.
    1. Enter the following in the Advanced tab:
       
       • Primary – Select address from the dropdown.
       • Secondary – enabled if you specified that a secondary address is available. Select host name or protocol address for the secondary connect.
       • Start parameters – list any startup parameters for the instance.
       • Traceflags – list any trace flags you want used for the instance at startup.
    2. If it is available, enter the following in the Private configuration tab:
       
       • Sybase home – the Adaptive Server release directory (also the value of $SYBASE).
       • Adaptive Server Enterprise home – the full path to the ASE-15_0 directory (also the value of $SYBASE/$SYBASE_ASE).
       • Interfaces directory – path to the directory containing the interfaces file.
       • Sybase environment script – full path to the script that you use to set the environment variables.
       • Cluster configuration file – full path to the cluster configuration file.
    3. Click Next to accept the cluster instance properties.
26. If there is more than one device on the node that supports IO fencing, the plug-in asks you to confirm the selection.
27. Specify the local system temporary databases and devices. You must create local system temporary database on a shared disk. The plug-in lists the default values for the local temporary databases. Accept the defaults or select each table cell to change its value.
28. To add more devices, click Create Device. Enter:
    
    • Device name – name of the device.
    • Device path – full path to the database device.
    • Device size – size in megabytes (MB), gigabytes (GB), or terabytes (TB).
    Click OK then click Next.
29. Review the information at the Summary page to be sure it is correct. To automatically start the cluster after the wizard completes, check the appropriate box when the cluster is created. If this option is not selected the cluster will be left in a shutdown state after the Create Cluster wizard completes.
30. Click Next to create this cluster.
    Adaptive Server plug-in displays another window showing the server messages as it creates the cluster.

• Starting and Stopping Sybase Central
  Learn how to start and stop Sybase Central.
• Registering the Adaptive Server Plug-in
  The Adaptive Server plug-in is registered in Sybase Central as part of the server installation. However, if the Adaptive Server plug-in is not correctly registered, you can manually register the Adaptive Server plug-in.
• Adding an Instance to a Cluster
  To add an instance, the max instances parameter must be greater than the current number of instances, and a cluster-supported agent must run on the node on which you are creating the instance. You must know the host name and port number of the unified agent (UA).
• Adding Logical Clusters
  The logical cluster is an abstract representation of one or more instances in a physical shared-disk cluster used to manage workload, failover and client application access to the cluster.
• Connecting to a Cluster
  When starting Sybase Central, the main window opens, displaying the ASE plug-in, with the list of icons of the clusters and instances to which you have previously connected. If the cluster is running, a green triangle appears inside the icon next to the cluster name.
• Changing Server Discovery Settings
  Learn how to change the discovery settings.