4 # Bi-directional mutiple cache node test
5 # Two Cache Node and t1 and t2 table to be cached
6 # Update in Target database
8 input
=${PWD}/cache
/Bidirectional
/mysqlcreatelogtable.sql
13 REL_PATH
=${PWD}/cache
/Bidirectional
17 cp $REL_PATH/csql.conf
/tmp
18 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
19 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
20 DS
="$DSN $DBUSER $PASSWORD"
21 rm -f /tmp
/csql
/csqlds.conf
22 touch /tmp
/csql
/csqlds.conf
23 $CSQL_INSTALL_ROOT/bin
/csqlds
-U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
28 if [ "$DSN" = "myodbc3" ]
30 LOG_FILE
=$REL_PATH/mysqlcreatelogtable.sql
31 TRI_FILE1
=$REL_PATH/trigger.sql
32 TRI_FILE2
=$REL_PATH/trigger1.sql
33 elif [ "$DSN" = "psql" ]
35 LOG_FILE
=$REL_PATH/psqlcreatelogtable.sql
36 TRI_FILE1
=$REL_PATH/trigger.psql
37 TRI_FILE2
=$REL_PATH/trigger1.psql
38 elif [ "$DSN" = "oracle" ]
40 LOG_FILE
=$REL_PATH/oraclecreatelogtable.sql
41 TRI_FILE1
=$REL_PATH/triggermul.oracle
42 TRI_FILE2
=$REL_PATH/trigger1mul.oracle
43 elif [ "$DSN" = "sybase" ]
45 LOG_FILE
=$REL_PATH/sybasecreatelogtable.sql
46 TRI_FILE1
=$REL_PATH/trigger.sybase
47 TRI_FILE2
=$REL_PATH/trigger1.sybase
48 elif [ "$DSN" = "db2" ]
50 LOG_FILE
=$REL_PATH/db2createlogtable.sql
51 TRI_FILE1
=$REL_PATH/trigger.db2
52 TRI_FILE2
=$REL_PATH/trigger1.db2
61 isql
$DS < $LOG_FILE >/dev
/null
2>&1
64 echo "DSN is not set for target db"
68 echo table csql_log_int is created with records
in target db
69 isql
$DS < $REL_PATH/create.sql
>/dev
/null
2>&1
70 rm -f /tmp
/csql
/csqltable.conf
71 touch /tmp
/csql
/csqltable.conf
72 isql
$DS < $TRI_FILE1 >/dev
/null
73 isql
$DS < $TRI_FILE2 >/dev
/null
76 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
79 echo "server 1 started"
82 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t
$a -d $DSN
85 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
88 isql
$DS < ${REL_PATH}/mysqldeletelogtable.sql
>/dev
/null
2>&1
89 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
95 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/select.sql
98 echo "unable to locate cache 1"
99 isql
$DS < $REL_PATH/mysqldeletelogtable.sql
>/dev
/null
2>&1
100 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
102 ipcrm
-M 4000 -M 4500
105 mkdir
/tmp
/csql1
>/dev
/null
2>&1
106 rm -f /tmp
/csql
1/csqltable.conf
107 touch /tmp
/csql
1/csqltable.conf
109 rm -f /tmp
/csql1.conf
110 cp $REL_PATH/conf
/csql.conf
/tmp
/csql1.conf
111 export CSQL_CONFIG_FILE
=/tmp
/csql1.conf
112 echo DSN
=$DSN >>$CSQL_CONFIG_FILE
113 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
116 echo "server 2 started"
120 $CSQL_INSTALL_ROOT/bin
/cachetable
-t t
$a -d $DSN
123 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
125 ipcrm
-M 4000 -M 4500 -M 5000 -M 5500
126 isql
$DS < ${REL_PATH}/mysqldeletelogtable.sql
>/dev
/null
2>&1
127 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
134 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/select.sql
137 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
139 ipcrm
-M 4000 -M 4500
140 echo "unable to locate cache 1"
141 isql
$DS < $REL_PATH/mysqldeletelogtable.sql
>/dev
/null
2>&1
144 echo "update some record in target database"
145 isql
$DS < ${REL_PATH}/update.sql
> /dev
/null
2>&1
148 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/select.sql
149 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
151 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/select.sql
153 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drop.sql
> /dev
/null
2>&1
154 isql
$DS < ${REL_PATH}/drop.sql
>/dev
/null
2>&1
155 rm -f /tmp
/csql
/csqltable.conf
156 touch /tmp
/csql
/csqltable.conf
157 rm -f /tmp
/csql
1/csqltable.conf
158 touch /tmp
/csql
1/csqltable.conf
159 isql
$DS < $REL_PATH/mysqldeletelogtable.sql
>/dev
/null
2>&1
160 kill `ps -ef | grep csqlcacheserver | awk -F" " '{ print $2 }'`
162 ipcrm
-M 4000 -M 4500 -M 5000 -M 5500