replica_part.sim 3.3 KB
Newer Older
S
slguan 已提交
1
system sh/stop_dnodes.sh
S
slguan 已提交
2 3 4 5 6 7



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 已提交
8

S
slguan 已提交
9 10 11 12 13 14
system sh/cfg.sh -n dnode1 -c clog -v 2
system sh/cfg.sh -n dnode2 -c clog -v 2
system sh/cfg.sh -n dnode3 -c clog -v 2
system sh/cfg.sh -n dnode1 -c numOfMPeers -v 2
system sh/cfg.sh -n dnode2 -c numOfMPeers -v 2
system sh/cfg.sh -n dnode3 -c numOfMPeers -v 2
S
slguan 已提交
15 16 17 18 19 20 21 22
system sh/cfg.sh -n dnode1 -c mgmtEqualVnodeNum -v 4
system sh/cfg.sh -n dnode2 -c mgmtEqualVnodeNum -v 4
system sh/cfg.sh -n dnode3 -c mgmtEqualVnodeNum -v 4
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
slguan 已提交
23
system sh/exec_up.sh -n dnode1 -s start
S
slguan 已提交
24
sql connect
S
slguan 已提交
25
sql create dnode $hostname2
S
slguan 已提交
26
system sh/exec_up.sh -n dnode2 -s start
S
slguan 已提交
27
sql create dnode $hostname3
S
slguan 已提交
28
system sh/exec_up.sh -n dnode3 -s start
S
slguan 已提交
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
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
S
slguan 已提交
68
system sh/exec_up.sh -n dnode2 -s stop -x SIGINT
S
slguan 已提交
69
sleep 5000
S
slguan 已提交
70 71 72 73
sql alter database d1 replica 2
sql alter database d2 replica 2
sql alter database d3 replica 2
sql alter database d4 replica 2
S
slguan 已提交
74
sleep 5000
S
slguan 已提交
75 76

print ========= step3
S
slguan 已提交
77
system sh/exec_up.sh -n dnode2 -s start
S
slguan 已提交
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
sleep 10000

print ========= step4
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

print ========= step5
S
slguan 已提交
107
system sh/exec_up.sh -n dnode2 -s stop -x SIGINT
S
slguan 已提交
108
sleep 5000
S
slguan 已提交
109

S
slguan 已提交
110 111
sql reset query cache
sleep 1000
S
slguan 已提交
112

S
slguan 已提交
113 114 115 116 117 118 119 120
sql insert into d1.t1 values(now, 3) -x s1
s1:
sql insert into d2.t2 values(now, 3) -x s2
s2:
sql insert into d3.t3 values(now, 3) -x s3
s3:
sql insert into d4.t4 values(now, 3) -x s4
s4:
S
slguan 已提交
121 122

print ========= step6
S
slguan 已提交
123
system sh/exec_up.sh -n dnode2 -s start
S
slguan 已提交
124
sleep 5000
S
slguan 已提交
125
system sh/exec_up.sh -n dnode3 -s stop -x SIGINT
S
slguan 已提交
126
sleep 5000
S
slguan 已提交
127

S
slguan 已提交
128 129 130 131 132 133 134 135
sql insert into d1.t1 values(now, 4) -x s5
s5:
sql insert into d2.t2 values(now, 4) -x s6
s6:
sql insert into d3.t3 values(now, 4) -x s7
s7:
sql insert into d4.t4 values(now, 4) -x s8
s8:
S
slguan 已提交
136 137

print ========= step7
S
slguan 已提交
138
system sh/exec_up.sh -n dnode3 -s start
S
slguan 已提交
139 140 141 142 143 144 145 146 147 148 149
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
sql select * from d2.t2
sql select * from d3.t3
sql select * from d4.t4
新手
引导
客服 返回
顶部