replica_reduce32.sim 3.7 KB
Newer Older
S
slguan 已提交
1
system sh/stop_dnodes.sh
S
slguan 已提交
2 3 4 5

system sh/deploy.sh -n dnode1 -i 1
system sh/deploy.sh -n dnode2 -i 2
system sh/deploy.sh -n dnode3 -i 3
S
slguan 已提交
6

S
scripts  
slguan 已提交
7 8 9
system sh/cfg.sh -n dnode1 -c wallevel -v 2
system sh/cfg.sh -n dnode2 -c wallevel -v 2
system sh/cfg.sh -n dnode3 -c wallevel -v 2
10 11 12
system sh/cfg.sh -n dnode1 -c numOfMnodes -v 1
system sh/cfg.sh -n dnode2 -c numOfMnodes -v 1
system sh/cfg.sh -n dnode3 -c numOfMnodes -v 1
S
Shengliang Guan 已提交
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
S
slguan 已提交
16 17 18 19 20
system sh/cfg.sh -n dnode1 -c numOfTotalVnodes -v 4
system sh/cfg.sh -n dnode2 -c numOfTotalVnodes -v 4
system sh/cfg.sh -n dnode3 -c numOfTotalVnodes -v 4

print ========= start dnodes
S
Shengliang Guan 已提交
21
system sh/exec.sh -n dnode1 -s start
S
slguan 已提交
22
sql connect
S
slguan 已提交
23
sql create dnode $hostname2
S
Shengliang Guan 已提交
24
system sh/exec.sh -n dnode2 -s start
S
slguan 已提交
25
sql create dnode $hostname3
S
Shengliang Guan 已提交
26
system sh/exec.sh -n dnode3 -s start
S
slguan 已提交
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
sleep 3000

print ======== step1 
sql create database d1 replica 3
sql create database d2 replica 3
sql create database d3 replica 3
sql create database d4 replica 3

sql create table d1.t1 (ts timestamp, i int)
sql create table d2.t2 (ts timestamp, i int)
sql create table d3.t3 (ts timestamp, i int)
sql create table d4.t4 (ts timestamp, i int)

sql insert into d2.t2 values(now, 1)
sql insert into d1.t1 values(now, 1)
sql insert into d3.t3 values(now, 1)
sql insert into d4.t4 values(now, 1)

sql select * from d1.t1
if $rows != 1 then
	return -1
endi

sql select * from d2.t2
if $rows != 1 then
	return -1
endi

sql select * from d3.t3
if $rows != 1 then
	return -1
endi

sql select * from d4.t4
if $rows != 1 then
	return -1
endi

print ========= step2 alter db
sql alter database d1 replica 2
sql alter database d2 replica 2
sql alter database d3 replica 2
S
slguan 已提交
69
sql alter database d4 replica 2
S
slguan 已提交
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
sleep 12000

print ========= step3
sql insert into d1.t1 values(now, 2)
sql insert into d2.t2 values(now, 2)
sql insert into d3.t3 values(now, 2)
sql insert into d4.t4 values(now, 2)

sql select * from d1.t1
if $rows != 2 then
	return -1
endi

sql select * from d2.t2
if $rows != 2 then
	return -1
endi

sql select * from d3.t3
if $rows != 2 then
	return -1
endi

sql select * from d4.t4
if $rows != 2 then
	return -1
endi

S
slguan 已提交
98 99 100
sql reset query cache
sleep 1000

S
slguan 已提交
101
print ========= step4
S
Shengliang Guan 已提交
102
system sh/exec.sh -n dnode2 -s stop -x SIGINT
S
slguan 已提交
103
sleep 5000
S
slguan 已提交
104

S
scripts  
Shengliang Guan 已提交
105 106 107 108
sql_error insert into d1.t1 values(now, 3)
sql_error insert into d2.t2 values(now, 3)
sql_error insert into d3.t3 values(now, 3)
sql_error insert into d4.t4 values(now, 3)
S
slguan 已提交
109

S
scripts  
Shengliang Guan 已提交
110 111 112 113
sql_error select * from d1.t1
sql_error select * from d2.t2
sql_error select * from d3.t3
sql_error select * from d4.t4
S
slguan 已提交
114 115

print ========= step5
S
Shengliang Guan 已提交
116
system sh/exec.sh -n dnode2 -s start
S
slguan 已提交
117

S
slguan 已提交
118
sleep 5000
S
Shengliang Guan 已提交
119
system sh/exec.sh -n dnode3 -s stop -x SIGINT
S
slguan 已提交
120 121 122 123
sleep 5000

sql reset query cache
sleep 1000
S
slguan 已提交
124

S
scripts  
Shengliang Guan 已提交
125 126 127 128
sql_error insert into d1.t1 values(now, 3)
sql_error insert into d2.t2 values(now, 3)
sql_error insert into d3.t3 values(now, 3)
sql_error insert into d4.t4 values(now, 3)
S
slguan 已提交
129 130

print ========= step6
S
Shengliang Guan 已提交
131
system sh/exec.sh -n dnode3 -s start
S
slguan 已提交
132 133 134 135 136 137 138 139
sleep 5000

sql insert into d1.t1 values(now, 5)
sql insert into d2.t2 values(now, 5)
sql insert into d3.t3 values(now, 5)
sql insert into d4.t4 values(now, 5)

sql select * from d1.t1
S
slguan 已提交
140
print d1.t1 $rows
S
slguan 已提交
141 142

sql select * from d2.t2
S
slguan 已提交
143
print d2.t2 $rows
S
slguan 已提交
144 145

sql select * from d3.t3
S
slguan 已提交
146
print d3.t3 $rows
S
slguan 已提交
147 148

sql select * from d4.t4
S
slguan 已提交
149
print d4.t4 $rows
S
scripts  
slguan 已提交
150

S
Shengliang Guan 已提交
151 152 153 154 155 156 157 158
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