ASE Cluster Edition Startup with Sybcluster Utility
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.