The Adaptive Server plug-in includes a wizard that steps you through the process of creating, starting and stopping a cluster. For complete instructions for using the Adaptive Server plug-in to configure and manage the cluster see “Administering Clusters with Adaptive Server plug-in” in the Users Guide to Clusters. Adaptive Server plug-in and sybcluster provide upgrade support. If you are upgrading to the Cluster Edition see Chapter 7, “Upgrading from an Earlier Version.”
To start the Create Cluster wizard:
Select the Adaptive Server Enterprise icon in the left pane.
Select the Utilities tab in the right pane.
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.
Follow the instructions in the Create Cluster wizard. Complete these steps using the values you indicated on Table 3-1.
Enter the name of the cluster.
Select the platform from the drop-down list.
Select the maximum number of instances you plan to use for this cluster.
Click Next.
Discovery settings – you can change the settings the Adaptive Server plug-in uses to find cluster nodes to use in the cluster. For more information see “Administering Clusters” in the Users Guide to Clusters.
Select the hosts that participate in the cluster.
Enter the unified agent user name and password.
Select Next.
Quorum device path – enter the full path to the quorum device. Click Next.
Enter:
Sybase home – the Adaptive Server release directory (also the value of $SYBASE).
ASE 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.
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.
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.
Enter the system procedures (sybsystemprocs) information:
System procedures device – enter the 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.
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).
Click Next.
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.
There is an option to have a secondary network if it is available.
Check the box if you have a secondary network available.
Click Validate Ports to make sure the ports are not currently in use, then click Next.
Specify the instances for the cluster. Click Add to add instances to the list.
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 errorlog for this instance.
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.
Select Next to accept the cluster instance properties.
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.
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.
Click Next.
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.
Click Next to create this cluster.
Adaptive Server plug-in displays another window showing the server messages as it creates the cluster.
