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. For an example of a completed worksheet, see “A sybcluster Sample Session”.
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 |
||
Size of master database |
60MB |
||
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 secondary 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.) Device for a local system temporary database must be a shared disk. |
|||
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.) Device for a local system temporary database must be a shared disk. |
|||
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 |
|||
Primary protocol address for instance3 |
|||
Secondary protocol address for instance3 |
|||
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.) Device for a local system temporary database must be a shared disk |
|||
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 |
|||
Primary network interface address for instance4 |
|||
Secondary network interface address for instance4 |
|||
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.) Device for a local system temporary database must be a shared disk |
|||
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) |
|||
|
|||
Save configuration information in a file |
Y |
||
Check each cluster device for IO fencing capability? |
Y |
||
