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 # after mnode support, del sleep 2000, and check dnode status sleep 2000 sql connect #$loop_cnt = 0 #check_dnode_ready: # $loop_cnt = $loop_cnt + 1 # sleep 200 # if $loop_cnt == 10 then # print ====> dnode not ready! # return -1 # endi #sql show dnodes #print ===> $rows $data00 $data01 $data02 $data03 $data04 $data05 #if $data00 != 1 then # return -1 #endi #if $data04 != ready then # goto check_dnode_ready #endi #sql connect # select */column from information_schema.xxxx; xxxx include: # dnodes, mnodes, modules, qnodes, # user_databases, user_functions, user_indexes, user_stables, user_streams, # user_tables, user_table_distributed, user_users, vgroups, print =============== add dnode2 into cluster sql create dnode $hostname port 7200 sql create database db vgroups 3 sql use db sql create table stb (ts timestamp, c int) tags (t int) sql create table t0 using stb tags (0) sql show dnodes if $rows != 2 then return -1 endi sql show mnodes if $rows != 1 then return -1 endi #sql show modules #sql show qnodes sql show databases if $rows != 2 then return -1 endi #sql show functions #sql show indexes sql show stables if $rows != 1 then return -1 endi #sql show streams, sql show tables if $rows != 1 then return -1 endi #sql show user_table_distributed sql show users if $rows != 1 then return -1 endi sql show vgroups if $rows != 3 then return -1 endi #sql select * from information_schema.dnodes #if $rows != 2 then # return -1 #endi #sql select * from information_schema.mnodes #if $rows != 1 then # return -1 #endi #sql select * from information_schema.modules #sql select * from information_schema.qnodes sql select * from information_schema.user_databases if $rows != 2 then return -1 endi #sql select * from information_schema.user_functions #sql select * from information_schema.user_indexes sql select * from information_schema.user_stables if $rows != 1 then return -1 endi #sql select * from information_schema.user_streams sql select * from information_schema.user_tables if $rows != 1 then return -1 endi #sql select * from information_schema.user_table_distributed sql select * from information_schema.user_users if $rows != 1 then return -1 endi #sql select * from information_schema.vgroups #if $rows != 3 then # return -1 #endi print ==== stop dnode1 and dnode2, and restart dnodes 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 dnode1 -s start system sh/exec.sh -n dnode2 -s start $loop_cnt = 0 check_dnode_ready: $loop_cnt = $loop_cnt + 1 sleep 200 if $loop_cnt == 10 then print ====> dnode not ready! return -1 endi sql show dnodes print ===> $rows $data00 $data01 $data02 $data03 $data04 $data05 if $data00 != 1 then return -1 endi if $data04 != ready then goto check_dnode_ready endi print ==== again run show / select of above #system sh/exec.sh -n dnode1 -s stop -x SIGINT