flowctrl.sim 2.9 KB
Newer Older
S
Shengliang Guan 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131
system sh/stop_dnodes.sh

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/cfg.sh -n dnode1 -c numOfMnodes -v 3
system sh/cfg.sh -n dnode2 -c numOfMnodes -v 3
system sh/cfg.sh -n dnode3 -c numOfMnodes -v 3

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 dnode1 -c http -v 0
system sh/cfg.sh -n dnode2 -c http -v 0
system sh/cfg.sh -n dnode3 -c http -v 0

system sh/cfg.sh -n dnode1 -c maxTablesPerVnode -v 20000
system sh/cfg.sh -n dnode2 -c maxTablesPerVnode -v 20000
system sh/cfg.sh -n dnode3 -c maxTablesPerVnode -v 20000

system sh/cfg.sh -n dnode1 -c maxVgroupsPerDb -v 20
system sh/cfg.sh -n dnode2 -c maxVgroupsPerDb -v 20
system sh/cfg.sh -n dnode3 -c maxVgroupsPerDb -v 20

system sh/cfg.sh -n dnode1 -c replica -v 3
system sh/cfg.sh -n dnode2 -c replica -v 3
system sh/cfg.sh -n dnode3 -c replica -v 3

print ============== deploy

system sh/exec.sh -n dnode1 -s start 
sleep 5001
sql connect

sql create dnode $hostname2
sql create dnode $hostname3
system sh/exec.sh -n dnode2 -s start 
system sh/exec.sh -n dnode3 -s start 

print  =============== step1
$x = 0
show1: 
	$x = $x + 1
	sleep 2000
	if $x == 5 then
	  return -1
	endi
sql show mnodes -x show1
$mnode1Role = $data2_1
print mnode1Role $mnode1Role
$mnode2Role = $data2_2
print mnode2Role $mnode2Role
$mnode3Role = $data2_3
print mnode3Role $mnode3Role

if $mnode1Role != master then
  goto show1
endi
if $mnode2Role != slave then
  goto show1
endi
if $mnode3Role != slave then
  goto show1
endi

print  =============== step2

sql create database db replica 3
sql use db
sql create table tb (ts timestamp, test int)

$x = 0
while $x < 100
  $ms = $x . s
  sql insert into tb values (now + $ms , $x )
  $x = $x + 1
endw 

print  =============== step3
sleep 3000

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

print  =============== step4
sleep 5000
system sh/exec.sh -n dnode1 -s start 
system sh/exec.sh -n dnode2 -s start 
system sh/exec.sh -n dnode3 -s start 

print  =============== step5
sleep 8000
while $x < 200
  $ms = $x . s
  sql insert into tb values (now + $ms , $x )
  $x = $x + 1
endw 

print  =============== step6
system sh/exec.sh -n dnode2 -s stop  -x SIGINT
sleep 3000
while $x < 300
  $ms = $x . s
  sql insert into tb values (now + $ms , $x )
  $x = $x + 1
endw 

system sh/exec.sh -n dnode2 -s start 

sleep 6000
print  =============== step7
while $x < 400
  $ms = $x . s
  sql insert into tb values (now + $ms , $x )
  $x = $x + 1
  sleep 1
endw 

print  =============== step8
sql select * from tb
print rows $rows
if $rows != 400 then
  return -1
endi

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