Part 12 - Start of Sybase ASE Cluster





Change interfaces file


Add master lines for hosts oralin11ext and oralin12ext

[sybase@oralin11 ~]$

sed -i '/master tcp ether oralin11 10011/ a\\tmaster tcp ether oralin11ext 10011' /opt/sybase/interfaces
sed -i '/master tcp ether oralin12 10012/ a\\tmaster tcp ether oralin12ext 10012' /opt/sybase/interfaces


Start Sybase cluster


Run sybcluster

[sybase@oralin11 ~]$

sybcluster -U uafadmin -P -C mycluster -F "oralin11,oralin12"

Type following command in sybcluster (except prompt as "sybcluster>" or "mycluster>")

Connect to cluster mycluster

sybcluster> 

connect

Result:

mycluster>

Show cluster status (and check it is Down)

mycluster> 

show cluster status

Result:

INFO  - Listening for the cluster heartbeat. This may take a minute. Please wait... (mycluster::AseProbe:434)                      

       Id   Name    Node    State  Heartbeat
       --  -----  --------  -----  ---------
        1  SYB11  oralin11   Down      No
        2  SYB12  oralin12   Down      No
       --  -----  --------  -----  ---------

Show cluster config

mycluster> 

show cluster config

Result:

** Cluster configuration for "mycluster" **
       Installation Mode  "shared"
       Interface Path "/opt/sybase"
       Trace Flags:
       There are no trace flags.
       Maximum Instances "4"
       Quorum "/dev/sybase/quorum"
       Master Device "/dev/sybase/master"
               logfile SYB11 /opt/sybase/ASE-15_0/install/SYB11.log
               run_parameters SYB11
               logfile SYB12 /opt/sybase/ASE-15_0/install/SYB12.log
               run_parameters SYB12
       Primary Interconnect "udp"
               Server[1] SYB11 oralin11 15100 15119
               Server[2] SYB12 oralin12 15120 15139

Start cluster

mycluster> 

start cluster

Result:

INFO  - Starting the cluster mycluster instance SYB11 using the operating system command:
/opt/sybase/ASE-15_0/bin/dataserver --quorum_dev=/dev/sybase/quorum --instance_name=SYB11
...
INFO  - 01:00:00000:00001:2011/07/17 00:51:45.13 server  ASE's default unicode sort order is 'binary'.
INFO  - 01:00:00000:00001:2011/07/17 00:51:45.13 server  ASE's default sort order is:
INFO  - 01:00:00000:00001:2011/07/17 00:51:45.13 server         'bin_iso_1' (ID = 50)
INFO  - 01:00:00000:00001:2011/07/17 00:51:45.13 server  on top of default character set:
INFO  - 01:00:00000:00001:2011/07/17 00:51:45.13 server         'iso_1' (ID = 1).
INFO  - 01:00:00000:00001:2011/07/17 00:51:45.13 server  Master device size: 30 megabytes, or 15360 virtual pages. (A virtual page is 2048 bytes.)

INFO  - Starting the cluster mycluster instance SYB12 using the operating system command:
/opt/sybase/ASE-15_0/bin/dataserver --quorum_dev=/dev/sybase/quorum --instance_name=SYB12
...
INFO  - 02:00:00000:00094:2011/07/17 00:52:25.94 kernel  instance 2 eventdone.
INFO  - 02:00:00000:00002:2011/07/17 00:52:25.94 server  ASE's default unicode sort order is 'binary'.
INFO  - 02:00:00000:00002:2011/07/17 00:52:26.02 server  ASE's default sort order is:
INFO  - 02:00:00000:00002:2011/07/17 00:52:26.02 server         'bin_iso_1' (ID = 50)
INFO  - 02:00:00000:00002:2011/07/17 00:52:26.02 server  on top of default character set:
INFO  - 02:00:00000:00002:2011/07/17 00:52:26.02 server         'iso_1' (ID = 1).
INFO  - 02:00:00000:00002:2011/07/17 00:52:26.04 server  Master device size: 30 megabytes, or 15360 virtual pages. (A virtual page is 2048 bytes.)

Show cluster status (and check it is Up)

mycluster> 

show cluster status

Result:

INFO  - Listening for the cluster heartbeat. This may take a minute. Please wait... (mycluster::AseProbe:434)

       Id   Name    Node    State  Heartbeat
       --  -----  --------  -----  ---------
        1  SYB11  oralin11    Up      Yes
        2  SYB12  oralin12    Up      Yes
       --  -----  --------  -----  ---------