system sh/stop_dnodes.sh system sh/deploy.sh -n dnode1 -i 1 system sh/deploy.sh -n dnode2 -i 2 system sh/exec.sh -n dnode1 -s start system sh/exec.sh -n dnode2 -s start sql connect print =============== step1 create dnode2 sql create dnode $hostname port 7200 sql create dnode $hostname port 7300 $x = 0 step1: $ = $x + 1 sleep 1000 if $x == 10 then print ====> dnode not online! return -1 endi sql select * from information_schema.ins_dnodes print ===> $data00 $data01 $data02 $data03 $data04 $data05 print ===> $data10 $data11 $data12 $data13 $data14 $data15 if $rows != 3 then return -1 endi if $data(1)[4] != ready then goto step1 endi if $data(2)[4] != ready then goto step1 endi if $data(3)[4] != offline then goto step1 endi print =============== step2 drop dnode 3 sql_error drop dnode 1 sql drop dnode 3 sql select * from information_schema.ins_dnodes print ===> $data00 $data01 $data02 $data03 $data04 $data05 print ===> $data10 $data11 $data12 $data13 $data14 $data15 if $rows != 2 then return -1 endi if $data(1)[4] != ready then goto step1 endi if $data(2)[4] != ready then goto step1 endi print =============== step3: create mnode on dnode 2 sql create mnode on dnode 2 $x = 0 step3: $x = $x + 1 sleep 1000 if $x == 10 then return -1 endi sql show mnodes -x step3 print $data[0][0] $data[0][1] $data[0][2] $data[0][3] $data[0][4] print $data[1][0] $data[1][1] $data[1][2] $data[1][3] $data[1][4] if $data(1)[2] != leader then goto step3 endi if $data(2)[2] != follower then goto step3 endi print =============== step4: drop dnode 2 sql_error drop dnode 1 sql drop dnode 2 print select * from information_schema.ins_dnodes; sql select * from information_schema.ins_dnodes; print $data[0][0] $data[0][1] $data[0][2] $data[0][3] $data[0][4] print $data[1][0] $data[1][1] $data[1][2] $data[1][3] $data[1][4] if $rows != 1 then return -1 endi if $data00 != 1 then return -1 endi print show mnodes; sql show mnodes print $data[0][0] $data[0][1] $data[0][2] $data[0][3] $data[0][4] print $data[1][0] $data[1][1] $data[1][2] $data[1][3] $data[1][4] if $rows != 1 then return -1 endi if $data(1)[2] != leader then return -1 endi system sh/exec.sh -n dnode1 -s stop -x SIGINT system sh/exec.sh -n dnode2 -s stop -x SIGINT