Worksheet for creating a cluster

Use Table 3-1 to help you plan your cluster. It lists all the information you need to create a cluster using the Adaptive Server plug-in or sybcluster. Default values are in square brackets. For an example of a completed worksheet, see “A sybcluster Sample Session”.

Table 3-1: Configuration values for creating a cluster

Parameter

Default value

Value

Cluster name

Number of instances

Maximum number of instances

4

Master Device

Full path and name for the master device

Size of master device [80MB]

60MB

Size of master database [60MB]

30MB

Instance page size in kilobytes

2

Sybase System Procedure Device

Full path and name for sybsystemprocs device

Size of sybsystemprocs device (MB)

150

Size of sybsystemprocs database

132

System Database Device

Full path and name of system database device

Size of system database device (MB)

6MB

Size of system database (MB)

6MB

Does this cluster have a private network

Y

Does this cluster have a secondary private network

Y

Quorum Device

Full path and name for the quorum device

Trace flags

Verify file locations

The location of the home directory

$SYBASE

Full path to environment variable script

$SYBASE/SYBASE.sh

Path to $SYBASE_ASE

Path to interfaces file directory

$SYBASE

Path to the dataserver configuration file

$SYBASE/cluster_name.cfg

Instance Information

Node name

Instance name

Query port number for instance1

Primary protocol address for instance1

Secondary protocol address for instance1

Local System Temporary Database

Local system temporary database device name (Enter the name of the Adaptive Server database device for the local system temporary database.)

Path to local system temporary database device

Local system temporary database device size (MB)

Local system temporary database name

Local system temporary database size (MB)

Node name

Instance name

Query port number for instance2

Primary protocol address for instance2

Secondary protocol address for instance2

Local System Temporary Database

Local system temporary database device name (Enter the name of the Adaptive Server database device for the local system temporary database.)

Path to local system temporary database device

Local system temporary database device size (MB)

Local system temporary database name

Local system temporary database size (MB)

Node name

Instance name

Query port number for instance 3

Primary protocol address for instance3

Secondary protocol address for instance3