maxvnodes.sim 2.3 KB
Newer Older
S
slguan 已提交
1
system sh/stop_dnodes.sh
S
slguan 已提交
2 3

system sh/deploy.sh -n dnode1 -i 1
S
scripts  
slguan 已提交
4 5
system sh/cfg.sh -n dnode1 -c walLevel            -v 0
system sh/cfg.sh -n dnode1 -c maxtablesPerVnode   -v 100
S
slguan 已提交
6 7 8 9 10 11 12
system sh/cfg.sh -n dnode1 -c numOfTotalVnodes    -v 256
system sh/cfg.sh -n dnode1 -c maxVnodeConnections -v 100000
system sh/cfg.sh -n dnode1 -c maxMeterConnections -v 100000
system sh/cfg.sh -n dnode1 -c maxShellConns       -v 100000
system sh/cfg.sh -n dnode1 -c maxMgmtConnections  -v 100000

print ==========  prepare data
S
scripts  
Shengliang Guan 已提交
13 14
system sh/exec_up.sh -n dnode1 -s start
sleep 3000
S
slguan 已提交
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
sql connect 
sql create database db
sql use db

print ==========  step1
sql create table mt (ts timestamp, tbcol int) TAGS(tgcol int)

$x = 0
while $x < 25600
  $tb = t . $x
  sql create table $tb using mt tags( $x )
  sql insert into $tb values (now, $x ) 
  $x = $x + 1
endw 

print ========== step2
sql select * from mt
if $rows != 25600 then
  return -1
endi  

sql select count(*) from mt
if $data00 != 25600 then
  return -1
endi  

S
slguan 已提交
41 42

system sh/deploy.sh -n dnode2 -i 2
S
scripts  
slguan 已提交
43 44
system sh/cfg.sh -n dnode2 -c walLevel            -v 0
system sh/cfg.sh -n dnode2 -c maxtablesPerVnode   -v 100
S
slguan 已提交
45 46 47 48 49 50 51
system sh/cfg.sh -n dnode2 -c numOfTotalVnodes    -v 256
system sh/cfg.sh -n dnode2 -c maxVnodeConnections -v 100000
system sh/cfg.sh -n dnode2 -c maxMeterConnections -v 100000
system sh/cfg.sh -n dnode2 -c maxShellConns       -v 100000
system sh/cfg.sh -n dnode2 -c maxMgmtConnections  -v 100000

print ==========  step2
S
slguan 已提交
52
sql create dnode $hostname2
S
scripts  
Shengliang Guan 已提交
53
system sh/exec_up.sh -n dnode2 -s start
S
slguan 已提交
54 55 56 57 58 59 60 61 62 63

$x = 0
show3: 
	$x = $x + 1
	sleep 3000
	if $x == 1000 then 
		return -1
	endi
	
sql show dnodes
S
slguan 已提交
64 65
print dnode1 freeVnodes $data3_192.168.0.1
print dnode2 freeVnodes $data3_192.168.0.2
S
slguan 已提交
66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82
if $data3_192.168.0.1 != 126 then
	goto show3
endi
if $data3_192.168.0.2 != 130 then
	goto show3
endi

print ========== step4
sql select * from mt
if $rows != 25600 then
  return -1
endi  

sql select count(*) from mt
if $data00 != 25600 then
  return -1
endi  
guanshengliang's avatar
scripts  
guanshengliang 已提交
83 84 85 86 87 88 89 90 91

system sh/exec_up.sh -n dnode1 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode2 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode3 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode4 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode5 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode6 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode7 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode8 -s stop  -x SIGINT