Configuration values

This appendix provides an example of how to configure a typical shared-disk cluster using sybcluster. See Table C-1for the configuration values used in the example session.

NoteThis example assumes a primary and secondary network. If you do not specify a primary network, sybcluster asks for a beginning port number and calculates the number of port numbers needed for communication among the instances. Ensure that the number you provide, and the following required port numbers, are not in use by another application. For information on about how sybcluster calculates the number of required ports, see “Creating the cluster using sybcluster”.

Table C-1: sybcluster prompts and configuration values entered for sample session

Parameter

Value

Cluster name

mycluster

Number of instances

Maximum number of nodes

Cluster node ID

1

Quorum Device

Full path and name for the quorum device

/dev/rhdisk11

Master device

Full path and name for the master device

/dev/rhdisk12

Size of master device [80MB]

80MB

Size of master database [60MB]

60MB

Instance page size in kilobytes [4]

2KB

Sybase system procedure device

Full path and name for sybsystemprocs device

/dev/rhdisk13

Size of sybsystemprocs device (MB)

150MB

Size of sybsystemprocs database (135)

135MB

System database device

Full path and name of system database device

/dev/rhdisk14

Size of system database device (MB)

12MB

Size of system database (MB)

12MB

----------

Does this cluster have a secondary network [Y]

Yes

Verify file locations

The location of the SYBASE home directory

/remote/var/sybase/

Full path to environment variable script

/remote/var/sybase/SYBASE.sh

Path to $SYBASE_ASE

/remote/var/sybase/ASE-15_0

Path to interfaces file directory

/remote/var/sybase

Path to the dataserver configuration file

/remote/var/sybase/mycluster.cfg

Instance information

Node name

blade1

sybcluster displays: Cluster: mycluster - Node: blade1 - Agent blade1:9999

Instance name

ase1

Query port number for ase1

19786

Primary protocol address for ase1

000.000.001.001

Secondary protocol address for ase1

000.000.001.002

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.) You must use a shared disk for local system temporary database devices.

mycluster1_tempdb

Path to local system temporary database device

/dev/rhdisk15

Local system temporary database device size (MB)

40MB

Local system temporary database name

mycluster_tdb_1

Local system temporary database size (MB)

40MB

----------

Do you want to add another instance (Y or N)

Yes

Node name

blade 2

sybcluster displays: Cluster: mycluster - Node: blade2 - Agent blade2:9999

Instance name

ase2

Query port number for ase2

19786

Primary protocol address for ase2

000.000.002.001

Secondary protocol address for ase2

000.000.002.002

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.) You must use a shared disk for local system temporary database devices.

mycluster2_tempdb

Path to local system temporary database device

/dev/rhdisk16

Local system temporary database device size (MB)

40MB

Local system temporary database name

mycluster_tdb_2

Local system temporary database size (MB)

40MB

----------

Do you want to add another instance (Y or N)

Yes

Node name

blade3

sybcluster displays: Cluster: mycluster - Node: blade3 - Agent blade3:9999

Instance name

ase3

Query port number

19786

Primary protocol address for ase3

000.000.003.001

Secondary protocol address for ase3

000.000.003.002

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.) You must use a shared disk for local system temporary database devices.

mycluster3_tempdb

Path to local system temporary database device

/dev/rhdisk17

Local system temporary database device size (MB)

40MB

Local system temporary database name

mycluster_tdb_3

Local system temporary database size (MB)

40MB

----------

Do you want to add another instance (Y or N)

N

Save configuration information in a file [Y]

Yes

Full path for configuration file

/remote/var/sybase/mycluster.xml

Create the cluster now [Y]

Yes

Check whether each cluster device has IO fencing capability? [Y]