2 # Testing Durability in MMAP architecture
4 # Testing All the operation in CSQl ((After Each Operation Kill the server and Restart the server again for Another Operation)
5 # set DURABILITY=true and MMAP=true in csql.conf
6 # Start csqlserver. Then create a table in CSQL Client.Insert 5 Records.
7 # kill the currently running Server.
8 # Again Restart the Server by setting DURABILITY=true and Open CSQL Client.
9 # Continue The same For All Operations in CSQL.
10 # All should work Fine
13 CSQL_CONF
=${PWD}/durability
/recovery
/csql.conf
15 if [ -s "$CSQL_CONF" ]
17 REL_PATH
=${PWD}/durability
/recovery
23 cp -f $REL_PATH/csql.conf
/tmp
24 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
25 echo USER_DB_KEY
=6666 >>/tmp
/csql.conf
26 echo "DURABILITY=true" >>/tmp
/csql.conf
27 echo "MMAP=true" >>/tmp
/csql.conf
28 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
30 echo "Durablity = TRUE"
32 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
36 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_10.sql
>/dev
/null
2>&1
44 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
50 echo "Durablity = TRUE"
51 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
53 echo "Checking Durability"
56 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
57 diff before.sql after.sql
>/dev
/null
2>&1
60 echo Durability Works Fine
63 echo "INSERTING INTO TABLE"
64 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/index_10.sql
>/dev
/null
2>&1
67 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
73 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
79 echo "Durablity = TRUE"
80 echo "Checking Durability"
81 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
85 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
86 diff before.sql after.sql
>/dev
/null
2>&1
89 echo Durability Works Fine
92 echo "INSERTING INTO TABLE"
93 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insert_10.sql
>/dev
/null
2>&1
96 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
102 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
108 echo "Durablity = TRUE"
109 echo "Checking Durability"
110 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
112 echo "Server Started"
114 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
115 diff before.sql after.sql
>/dev
/null
2>&1
118 echo Durability Works Fine
121 echo "UPDATING RECORDS IN TABLE"
122 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/update_10.sql
>/dev
/null
2>&1
125 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
131 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
137 echo "Durablity = TRUE"
138 echo "Checking Durability"
139 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
141 echo "Server Started"
143 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
144 diff before.sql after.sql
>/dev
/null
2>&1
147 echo Durability Works Fine
150 echo "DELETING RECORDS FROM TABLE"
151 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/delete_10.sql
>/dev
/null
2>&1
154 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
160 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
166 echo "Durablity = TRUE"
167 echo "Checking Durability"
168 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
170 echo "Server Started"
172 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
173 diff before.sql after.sql
>/dev
/null
2>&1
176 echo Durability Works Fine
179 echo "DROPPING TABLE"
180 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_10.sql
188 rm -f before.sql after.sql