balance3.sim 6.0 KB
Newer Older
S
slguan 已提交
1 2
system sh/stop_dnodes.sh

S
slguan 已提交
3 4 5 6 7 8
system sh/deploy.sh -n dnode1 -i 1
system sh/deploy.sh -n dnode2 -i 2
system sh/deploy.sh -n dnode3 -i 3
system sh/deploy.sh -n dnode4 -i 4
system sh/deploy.sh -n dnode5 -i 5
system sh/deploy.sh -n dnode6 -i 6
S
slguan 已提交
9

S
Shengliang Guan 已提交
10 11 12 13 14 15
system sh/cfg.sh -n dnode1 -c mnodeEqualVnodeNum -v 4
system sh/cfg.sh -n dnode2 -c mnodeEqualVnodeNum -v 4
system sh/cfg.sh -n dnode3 -c mnodeEqualVnodeNum -v 4
system sh/cfg.sh -n dnode4 -c mnodeEqualVnodeNum -v 4
system sh/cfg.sh -n dnode5 -c mnodeEqualVnodeNum -v 4
system sh/cfg.sh -n dnode6 -c mnodeEqualVnodeNum -v 4
S
slguan 已提交
16

S
scripts  
slguan 已提交
17 18 19 20 21 22
system sh/cfg.sh -n dnode1 -c wallevel -v 1
system sh/cfg.sh -n dnode2 -c wallevel -v 1
system sh/cfg.sh -n dnode3 -c wallevel -v 1
system sh/cfg.sh -n dnode4 -c wallevel -v 1
system sh/cfg.sh -n dnode5 -c wallevel -v 1
system sh/cfg.sh -n dnode6 -c wallevel -v 1
S
slguan 已提交
23 24

print ========== step1
S
Shengliang Guan 已提交
25
system sh/exec.sh -n dnode1 -s start
S
slguan 已提交
26 27
sql connect

S
slguan 已提交
28 29 30
sql create dnode $hostname2
sql create dnode $hostname3
sql create dnode $hostname4
S
Shengliang Guan 已提交
31 32 33
system sh/exec.sh -n dnode2 -s start
system sh/exec.sh -n dnode3 -s start
system sh/exec.sh -n dnode4 -s start
S
slguan 已提交
34 35
sleep 3000

S
scripts  
slguan 已提交
36
sql create database d1 replica 3  maxTables 4
S
slguan 已提交
37 38 39 40 41 42 43
sql create table d1.t1 (t timestamp, i int) 
sql insert into d1.t1 values(now+1s, 15) 
sql insert into d1.t1 values(now+2s, 14)
sql insert into d1.t1 values(now+3s, 13)
sql insert into d1.t1 values(now+4s, 12)
sql insert into d1.t1 values(now+5s, 11)

S
scripts  
slguan 已提交
44
sql create database d2 replica 3  maxTables 4
S
slguan 已提交
45 46 47 48 49 50 51 52
sql create table d2.t2 (t timestamp, i int) 
sql insert into d2.t2 values(now+1s, 25)
sql insert into d2.t2 values(now+2s, 24)
sql insert into d2.t2 values(now+3s, 23)
sql insert into d2.t2 values(now+4s, 22)
sql insert into d2.t2 values(now+5s, 21)

sql show dnodes
S
slguan 已提交
53 54 55 56
print dnode1 openVnodes $data2_1
print dnode2 openVnodes $data2_2
print dnode3 openVnodes $data2_3
print dnode4 openVnodes $data2_4
S
slguan 已提交
57

S
slguan 已提交
58
if $data2_1 != 0 then
S
slguan 已提交
59 60
	return -1
endi
S
slguan 已提交
61
if $data2_2 != 2 then
S
slguan 已提交
62 63
	return -1
endi
S
slguan 已提交
64
if $data2_3 != 2 then
S
slguan 已提交
65 66
	return -1
endi
S
slguan 已提交
67
if $data2_4 != 2 then
S
slguan 已提交
68 69 70 71
	return -1
endi

print ========== step2
S
slguan 已提交
72
sql drop dnode $hostname2
S
slguan 已提交
73 74 75 76 77 78 79 80 81 82

$x = 0
show2: 
	$x = $x + 1
	sleep 2000
	if $x == 20 then 
	  return -1
	endi

sql show dnodes
S
slguan 已提交
83 84 85 86
print dnode1 openVnodes $data2_1
print dnode2 openVnodes $data2_2
print dnode3 openVnodes $data2_3
print dnode4 openVnodes $data2_4
S
slguan 已提交
87

S
slguan 已提交
88
if $data2_1 != 2 then
S
slguan 已提交
89 90
	goto show2
endi
S
scripts  
Shengliang Guan 已提交
91
if $data2_2 != null then
S
slguan 已提交
92 93
	goto show2
endi
S
slguan 已提交
94
if $data2_3 != 2 then
S
slguan 已提交
95 96
	goto show2
endi
S
slguan 已提交
97
if $data2_4 != 2 then
S
slguan 已提交
98 99 100
	goto show2
endi

S
Shengliang Guan 已提交
101
system sh/exec.sh -n dnode2 -s stop -x SIGINT
S
slguan 已提交
102 103

print ========== step
S
slguan 已提交
104
sql create dnode $hostname5
S
Shengliang Guan 已提交
105
system sh/exec.sh -n dnode5 -s start
S
slguan 已提交
106 107 108 109 110 111 112 113 114 115

$x = 0
show3: 
	$x = $x + 1
	sleep 4000
	if $x == 15 then 
	  return -1
	endi
	
sql show dnodes
S
slguan 已提交
116 117 118 119 120
print dnode1 openVnodes $data2_1
print dnode2 openVnodes $data2_2
print dnode3 openVnodes $data2_3
print dnode4 openVnodes $data2_4
print dnode5 openVnodes $data2_5
S
slguan 已提交
121

S
slguan 已提交
122
if $data2_1 != 0 then
S
slguan 已提交
123 124
	goto show3
endi
S
scripts  
Shengliang Guan 已提交
125
if $data2_2 != null then
S
slguan 已提交
126 127
	goto show3
endi
S
slguan 已提交
128
if $data2_3 != 2 then
S
slguan 已提交
129 130
	goto show3
endi
S
slguan 已提交
131
if $data2_4 != 2 then
S
slguan 已提交
132 133
	goto show3
endi
S
slguan 已提交
134
if $data2_5 != 2 then
S
slguan 已提交
135 136 137 138
	goto show3
endi

print ========== step4
S
scripts  
slguan 已提交
139
sql create database d3 replica 3 maxTables 4
S
slguan 已提交
140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155
sql create table d3.t3 (t timestamp, i int) 
sql insert into d3.t3 values(now+1s, 35)
sql insert into d3.t3 values(now+2s, 34)
sql insert into d3.t3 values(now+3s, 33)
sql insert into d3.t3 values(now+4s, 32)
sql insert into d3.t3 values(now+5s, 31)

$x = 0
show4: 
	$x = $x + 1
	sleep 2000
	if $x == 20 then 
	  return -1
	endi

sql show dnodes
S
slguan 已提交
156 157 158 159 160
print dnode1 openVnodes $data2_1
print dnode2 openVnodes $data2_2
print dnode3 openVnodes $data2_3
print dnode4 openVnodes $data2_4
print dnode5 openVnodes $data2_5
S
slguan 已提交
161

S
slguan 已提交
162
if $data2_1 != 0 then
S
slguan 已提交
163 164
	goto show4
endi
S
scripts  
Shengliang Guan 已提交
165
if $data2_2 != null then
S
slguan 已提交
166 167
	goto show4
endi
S
slguan 已提交
168
if $data2_3 != 3 then
S
slguan 已提交
169 170
	goto show4
endi
S
slguan 已提交
171
if $data2_4 != 3 then
S
slguan 已提交
172 173
	goto show4
endi
S
slguan 已提交
174
if $data2_5 != 3 then
S
slguan 已提交
175 176 177 178
	goto show4
endi

print ========== step5
S
slguan 已提交
179 180
sql create dnode $hostname6
system sh/deploy.sh -n dnode6 -i 6
S
Shengliang Guan 已提交
181
system sh/exec.sh -n dnode6 -s start
S
slguan 已提交
182 183 184 185 186

$x = 0
show5: 
	$x = $x + 1
	sleep 2000
S
slguan 已提交
187
	if $x == 10 then 
S
slguan 已提交
188 189 190 191
	  return -1
	endi

sql show dnodes
S
slguan 已提交
192
print dnode1 openVnodes $data2_1
S
slguan 已提交
193
print dnode6 openVnodes $data2_6
S
slguan 已提交
194 195 196
print dnode3 openVnodes $data2_3
print dnode4 openVnodes $data2_4
print dnode5 openVnodes $data2_5
S
slguan 已提交
197

S
slguan 已提交
198
if $data2_1 != 0 then
S
slguan 已提交
199 200
	goto show5
endi
S
slguan 已提交
201
if $data2_6 != 2 then
S
slguan 已提交
202 203 204 205 206 207
	goto show5
endi

sleep 8000

print ========== step6
S
slguan 已提交
208
sql drop dnode $hostname3
S
slguan 已提交
209 210 211 212 213 214 215 216 217 218

$x = 0
show6: 
	$x = $x + 1
	sleep 2000
	if $x == 20 then 
	  return -1
	endi

sql show dnodes
S
slguan 已提交
219
print dnode1 openVnodes $data2_1
S
slguan 已提交
220
print dnode6 openVnodes $data2_6
S
slguan 已提交
221 222 223
print dnode3 openVnodes $data2_3
print dnode4 openVnodes $data2_4
print dnode5 openVnodes $data2_5
S
slguan 已提交
224

S
slguan 已提交
225
if $data2_1 != 0 then
S
slguan 已提交
226 227
	goto show6
endi
S
slguan 已提交
228
if $data2_6 != 3 then
S
slguan 已提交
229 230
	goto show6
endi
S
scripts  
Shengliang Guan 已提交
231
if $data2_3 != null then
S
slguan 已提交
232 233
	goto show6
endi
S
slguan 已提交
234
if $data2_4 != 3 then
S
slguan 已提交
235 236
	goto show6
endi
S
slguan 已提交
237
if $data2_5 != 3 then
S
slguan 已提交
238 239 240
	goto show6
endi

S
Shengliang Guan 已提交
241
system sh/exec.sh -n dnode3 -s stop -x SIGINT
S
slguan 已提交
242

S
slguan 已提交
243 244 245
sql reset query cache
sleep 1000

S
slguan 已提交
246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300
print ========== step7
sql select * from d1.t1 order by t desc
print $data01 $data11 $data21 $data31 $data41 
if $data01 != 11 then
  return -1
endi
if $data11 != 12 then
  return -1
endi
if $data21 != 13 then
  return -1
endi
if $data31 != 14 then
  return -1
endi
if $data41 != 15 then
  return -1
endi

sql select * from d2.t2 order by t desc
print $data01 $data11 $data21 $data31 $data41 
if $data01 != 21 then
  return -1
endi
if $data11 != 22 then
  return -1
endi
if $data21 != 23 then
  return -1
endi
if $data31 != 24 then
  return -1
endi
if $data41 != 25 then
  return -1
endi

sql select * from d3.t3 order by t desc
print $data01 $data11 $data21 $data31 $data41  
if $data01 != 31 then
  return -1
endi
if $data11 != 32 then
  return -1
endi
if $data21 != 33 then
  return -1
endi
if $data31 != 34 then
  return -1
endi
if $data41 != 35 then
  return -1
endi

S
Shengliang Guan 已提交
301 302 303 304 305 306 307 308
system sh/exec.sh -n dnode1 -s stop  -x SIGINT
system sh/exec.sh -n dnode2 -s stop  -x SIGINT
system sh/exec.sh -n dnode3 -s stop  -x SIGINT
system sh/exec.sh -n dnode4 -s stop  -x SIGINT
system sh/exec.sh -n dnode5 -s stop  -x SIGINT
system sh/exec.sh -n dnode6 -s stop  -x SIGINT
system sh/exec.sh -n dnode7 -s stop  -x SIGINT
system sh/exec.sh -n dnode8 -s stop  -x SIGINT