ASE CE Cluster Startup with XML file

[javier_barthe]

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 clusterStartup the unified agente for each node that its going to be part of the cluster:

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

sybase@db1(/sybase/ASE-15_0/bin)$. sybcluster -Uuafadmin -P -C dbcluster -F “db1,db2″
> create cluster dbcluster file /sybase/dbcluster.xml
……….
The cluster dbcluster was successfully created.

Dbcluster.xml Details

<?xml version=”1.0″ encoding=”UTF-8″?>
<sybase>
<ase_sdc>
<cluster name=”dbcluster” max_instances=”2″ version=”6″ status=”0″>
<traceflags />
<devices page_size=”2″ units=”k”>
<device type=”quorum” name=”quorum” path=”/sybase/devices/rquorum” />
<device type=”master” name=”master” path=”/sybase/devices/rmaster” size=”150″ units=”m”>
<database name=”master” size=”100″ units=”m” />
</device>
<device type=”sybsystemprocs” name=”sysprocsdev” path=”/sybase/devices/rsybprocs” size=”250″ units=”m”>
<database name=”sybsystemprocs” size=”250″ units=”m” />
</device>
<device type=”system” name=”systemdbdev” path=”/sybase/devices/rsybsystemdb” size=”80″ units=”m”>
<database name=”sybsystemdb” size=”80″ units=”m” />
</device>
<device name=”localsystempdb1″ path=”/sybase/devices/rlocalsystempdb1″ size=”950″ units=”m” />

<device name=”localsystempdb2″ path=”/sybase/devices/rlocalsystempdb2″ size=”950″ units=”m” />
</devices>
<installation mode=”private” />
<nodes primary_protocol=”udp” secondary_protocol=”udp” first_port=”15100″>
<config_path value=”/sybase/dbcluster.cfg” />
<addl_run_params value=”” />
<sybase_home value=”/sybase” />
<ase_home value=”/sybase/ASE-15_0″ />
<env_shell_path value=”/sybase/SYBASE.sh” type=”sh” />
<node name=”db1″ public_address=”db1″ primary_address=”interlinkA1″ secondary_address=”interlinkB1″ uaf_port=”9999″>
<instance id=”1″ name=”db1″>
<interface port=”4100″ transport=”tcp” />
<protocol_spec>
<primary_spec port_start=”15100″ />
<secondary_spec port_start=”15121″ />
</protocol_spec>
<database device=”localsystempdb1″ type=”stdb” name=”dbcluster_tdb_1″ size=”950″ units=”m” />
<logfile path=”/sybase/ASE-15_0/install/db1.log” />
<config_path value=”/sybase/dbcluster.cfg” />
<sybase_home value=”/sybase” />
<ase_home value=”/sybase/ASE-15_0″ />
<env_shell_path value=”/sybase/SYBASE.sh” type=”sh” />
</instance>
</node>
<node name=”db2″ public_address=”db2″ primary_address=”interlinkA2″ secondary_address=”interlinkB2″ uaf_port=”9999″>
<instance id=”2″ name=”db2″>
<interface port=”4101″ transport=”tcp” />
<protocol_spec>
<primary_spec port_start=”15110″ />
<secondary_spec port_start=”15131″ />
</protocol_spec>
<database device=”localsystempdb2″ type=”stdb” name=”dbcluster_tdb_2″ size=”950″ units=”m” />
<logfile path=”/sybase/ASE-15_0/install/db2.log” />
<config_path value=”/sybase/dbcluster.cfg” />
<sybase_home value=”/sybase” />
<ase_home value=”/sybase/ASE-15_0″ />
<env_shell_path value=”/sybase/SYBASE.sh” type=”sh” />
</instance>
</node>
</nodes>
</cluster>
</ase_sdc>
</sybase>

Javier E. Barthe