1. Some global checks

Log in with Sybase User to Unix and check this enviromental variables:

  • SYBASE_JRE6=/sybase/shared/JRE-6_0_SR1_64BIT
  • SYBASE_UA=/sybase/UAF-2_5

Then check the sybcluster utility:

sybcluster -v

  • Sybase sybcluster Command Line Utility/15.5/Cluster Edition/S/jdk1.4.2/ase155ce/400/Mon Nov 23 09:12:16 PST 2009

2. Startup Agents and create cluster

Startup the unified agente for each node that its going to be part of the cluster:

  • sybase@nodo1(/sybase/UAF-2_5/bin)$. uafstartup.sh &
  • sybase@nodo2(/sybase/UAF-2_5/bin)$. uafstartup.sh &



sybase@nodo1(/sybase/ASE-15_0/bin)$. sybcluster -Uuafadmin -P -C dbcluster -F “nodo1,nodo2”

> create cluster dbcluster

Cluster dbcluster – Enter the maximum number of instances: [ 4 ] 2

How many agents will participate in this cluster: [ 4 ] 2

Verifying the supplied agent specifications…

1) nodo1 9999 2.5.0 AIX

2) nodo2 9999 2.5.0 AIX

Enter the number representing the cluster node 1: [ 2 ] 1

2) nodo1 9999 2.5.0 AIX

Enter the number representing the cluster node 2: [ 2 ] 2

Will this cluster be configured using private SYBASE installations? (Y/N) : [ N ] y

—————— Quorum Device ———————

The quorum device is used to manage a cluster. It contains information shared between instances and nodes.

Enter the full path to the quorum disk: /sybase/devices/rquorum

Enter any traceflags:

————— Master Database Device —————-

The master database device controls the operation of the Adaptive Server and sto res information about all user databases and their associated database devices.

Enter the full path to the master device: /sybase/devices/rmaster

Enter the size the Master Device (MB): [ 80 ] 150

Enter the size the Master Database (MB): [ 60 ] 100

Enter the page size in kilobytes: [ 2 ] 2

———— Sybase System Procedure Device ——–

Sybase system procedures (sybsystemprocs) are stored on a device

Enter the System Procedure Device path: /sybase/devices/rsybprocs

Enter System Procedure Device size (MB): [ 152 ] 250

Enter the System Procedure Database size (MB): [ 152 ] 250

————– System Database Device ——————

The system database (sybsystemdb) stores information about distributed transactions.

Enter the System Database Device path: /sybase/devices/rsybsystemdb

Enter the System Database Device size (MB): [ 12 ] 80

Enter the System Database size (MB): [ 12 ] 80

————— PCI Device —————-

Pluggable Component Interface (PCI) provides support for Java in database by loa ding off-the-shelf JVMs from any vendor. If you want to use JVM, create a device for it.

Enable PCI in Adaptive Servier (Y/N): [ N ] n

——————————————————–

Does this cluster have a secondary network: [ Y ] Y

——————————————————–

——————————————————–

You will now be asked for the instance information on a node by node basis.

— Cluster: dbcluster- Node: nodo1 – Agent: nodo1:9999 —

Enter the name of the cluster instance: nodo1

Enter the Sybase installation directory on dbcluster: [ /sybase ] /sybase

Enter the environment shell script path on dbcluster: [ /sybase/SYBASE.sh ] <enter>

Enter the ASE home directory on dbcluster: [ /sybase/ASE-15_0 ] <enter>

Enter path to the dataserver config file: [ /sybase/dbcluster.cfg ] <enter>

Enter the interface file query port number for instance nodo1: 4100

Enter the primary protocol address for nodo1: [ nodo1 ] interlinkA1

Enter the secondary protocol address for nodo1: [ nodo1 ] interlinkB1

————— Local System Temporary Database ———

The Local System Temporary Database Device contains a database for each instance in the cluster.

Enter the LST device name: localsystempdb1

Enter the LST device path: /sybase/devices/rlocalsystempdb1

Enter LST device size (MB): 950

Enter the LST database name: [ dbcluster_tdb_1 ] dbcluster_tdb_1

Enter the LST database size (MB): [ 1000 ] 950

— Cluster: dbcluster – Node: nodo2 – Agent: nodo2:9999 —

Enter the name of the cluster instance: nodo2

Enter the Sybase installation directory on dbcluster: [ /sybase ] /sybase

Enter the environment shell script path on dbcluster: [ /sybase/SYBASE.sh ] <enter>

Enter the ASE home directory on dbcluster: [ /sybase/ASE-15_0 ] <enter>

Enter path to the dataserver config file: [ /sybase/dbcluster.cfg ] <enter>

Enter the interface file query port number for instance nodo2: 4101

Enter the primary protocol address for nodo2: [ nodo2 ] interlinkA2

Enter the secondary protocol address for nodo2: [ nodo2] interlinkB2

————— Local System Temporary Database ———

The Local System Temporary Database Device contains a database for each instance in the cluster.

Enter the LST device name: localsystempdb2

Enter the LST device path: /sybase/devices/rlocalsystempdb2

Enter LST device size (MB): 950

Enter the LST database name: [ dbcluster_tdb_2 ] dbcluster_tdb_2

Enter the LST database size (MB): [ 1000 ] 950

Would you like to save this configuration information in a file? [ Y ] Y

Enter the name of the file to save the cluster creation information: [ /sybase/dbcluster.xml ]

——————————————————–

Create the cluster now? [ Y ] Y

INFO  – Creating the Cluster Agent plugin on host address nodo1 using agent: nodo1:9999

2012-02-20 10:53:11,843 INFO  [RMI TCP Connection(38)-10.0.0.1] Plugin registered. Updating lookup info…


[You may have an stack trace here, its not a problem]


INFO  – Creating the Cluster Agent plugin on host address nodo2 using agent: nodo2:9999

Enter the path to the Interfaces file on nodo1:  [ /sybase ]

Enter the path to the Interfaces file on nodo2:  [ /sybase ]

Would you like to check whether this device supports IO fencing capability (Y/N)?  [ Y ] Y

Validating the device /sybase/devices/rmaster for IO Fencing Capabilities.

Validating the device /sybase/devices/rsybprocs for IO Fencing Capabilities.

Validating the device /sybase/devices/rsybsystemdb for IO Fencing Capabilities.

INFO  – Cluster “dbcluster” creation in progress.

INFO  – Choosing the first instance to be created using the connected agent…

INFO  – The Sybase home directory is /sybase.

INFO  – The ASE home directory is /sybase/ASE-15_0.

INFO  – Retrieving environment variables from /sybase/SYBASE.sh.

INFO  – The first instance created will be nodo1.

INFO  – Port number ‘4100’ is being reserved or currently in use by a running server.

INFO  – Building Adaptive Server ‘nodo1’:

INFO  – Writing entry into directory services…

INFO  – Directory services entry complete.

INFO  – Building master device…

INFO  – Master device complete.

INFO  – Starting server…

INFO  – Server started.

INFO  – Building sysprocs device and sybsystemprocs database…

INFO  – sysprocs device and sybsystemprocs database created.

INFO  – Running installmaster script to install system stored procedures…

INFO  – installmaster: 10% complete.

INFO  – installmaster: 20% complete.

INFO  – installmaster: 30% complete.

INFO  – installmaster: 40% complete.

INFO  – installmaster: 50% complete.

INFO  – installmaster: 60% complete.

INFO  – installmaster: 70% complete.

INFO  – installmaster: 80% complete.

INFO  – installmaster: 90% complete.

INFO  – installmaster: 100% complete.

INFO  – installmaster script complete.

INFO  – Creating two-phase commit database…

INFO  – Two phase commit database complete.

INFO  – Installing common character sets (Code Page 437, Code Page 850, ISO Latin-1,

INFO  – Macintosh and HP Roman-8)…

INFO  – Character sets installed.

INFO  – Server ‘nodo1’ was successfully created.

INFO  – Connecting to the dataserver using the host and query port nodo1:4100.

INFO  – Creating the Local System Temporary device localsystemdb1 at /sybase/devices/rlocalsystemdb1 of size 950M.

INFO  – Creating the Local System Temporary device localsystemdb2 at /sybase/devices/rlocalsystemdb2 of size 950M.

INFO  – nodo1: Creating the Local System Temporary database p7cluster_tdb_1 on localsystemdb1 of size 950M.

INFO  – nodo2: Creating the Local System Temporary database p7cluster_tdb_2 on localsystemdb2 of size 950M.

INFO  – The cluster is now configured. Shutting down this first instance.

The cluster p7cluster was successfully created.

>

In later documents I will post the pre startup tasks.

Javier E. Barthe.

Sybase ASE Specialist.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply