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/exec.sh -n dnode1 -s start system sh/exec.sh -n dnode2 -s start system sh/exec.sh -n dnode3 -s start sql connect sql create dnode $hostname port 7200 sql create dnode $hostname port 7300 $x = 0 step1: $x = $x + 1 sleep 1000 if $x == 10 then print ====> dnode not ready! return -1 endi sql show dnodes print ===> $data00 $data01 $data02 $data03 $data04 $data05 print ===> $data10 $data11 $data12 $data13 $data14 $data15 print ===> $data20 $data21 $data22 $data23 $data24 $data25 print ===> $data30 $data31 $data32 $data33 $data34 $data35 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] != ready then goto step1 endi print ============= create database with all options #database_option: { # | BUFFER value [3~16384, default: 96] # | PAGES value [64~16384, default: 256] # | PAGESIZE value [1~16384, default: 4] # | CACHEMODEL value ['node', 'last_row', 'last_value', 'both', default: 'node'] # | COMP [0 | 1 | 2, default: 2] # | DURATION value [60m ~ min(3650d,keep), default: 10d, unit may be minut/hour/day] # | WAL_FSYNC_PERIOD value [0 ~ 180000 ms, default: 3000] # | MAXROWS value [200~10000, default: 4096] # | MINROWS value [10~1000, default: 100] # | KEEP value [max(1d ~ 365000d), default: 1d, unit may be minut/hour/day] # | PRECISION ['ms' | 'us' | 'ns', default: ms] # | REPLICA value [1 | 3, default: 1] # | WAL_LEVEL value [1 | 2, default: 1] # | VGROUPS value [default: 2] # | SINGLE_STABLE [0 | 1, default: ] # #$data0_db : name #$data1_db : create_time #$data2_db : vgroups #$data3_db : ntables #$data4_db : replica #$data6_db : duration #$data7_db : keep #$data10_db : minrows #$data11_db : maxrows #$data12_db : wal_level #$data13_db : fsync #$data14_db : comp #$data15_db : cachelast #$data16_db : precision print ====> create database db, with default sql create database db sql select * from information_schema.ins_databases print rows: $rows print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $rows != 3 then return -1 endi if $data0_db != db then # name return -1 endi if $data2_db != 2 then # vgroups return -1 endi if $data3_db != 0 then # ntables return -1 endi if $data4_db != 1 then # replica print expect 1, actual: $data4_db return -1 endi if $data5_db != off then # strict return -1 endi if $data6_db != 14400m then # duration return -1 endi if $data7_db != 5256000m,5256000m,5256000m then # keep return -1 endi if $data8_db != 96 then # buffer return -1 endi if $data9_db != 4 then # pagesize return -1 endi if $data10_db != 256 then # pages return -1 endi if $data11_db != 100 then # minrows return -1 endi if $data12_db != 4096 then # maxrows return -1 endi if $data13_db != 2 then # comp return -1 endi if $data14_db != ms then # precision return -1 endi if $data18_db != none then # cachelast return -1 endi if $data20_db != 1 then # wal_level return -1 endi if $data21_db != 3000 then # wal_fsync_period return -1 endi sql drop database db #print ====> BLOCKS value [3~1000, default: 6] #sql create database db BLOCKS 3 #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $data9_db != 3 then # return -1 #endi #sql drop database db #sql create database db BLOCKS 1000 #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $data9_db != 1000 then # return -1 #endi #sql drop database db #sql_error create database db BLOCKS 2 #sql_error create database db BLOCKS 0 #sql_error create database db BLOCKS -1 #print ====> CACHE value [default: 16] #sql create database db CACHE 1 #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $data8_db != 1 then # return -1 #endi #sql drop database db #sql create database db CACHE 128 #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $data8_db != 128 then # return -1 #endi #sql drop database db print ====> CACHEMODEL value [0, 1, 2, 3, default: 0] sql create database db CACHEMODEL 'last_row' sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data18_db != last_row then return -1 endi sql drop database db sql create database db CACHEMODEL 'last_value' sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data18_db != last_value then return -1 endi sql drop database db sql create database db CACHEMODEL 'both' sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data18_db != both then return -1 endi sql drop database db sql_error create database db CACHEMODEL 'other' sql_error create database db CACHEMODEL '-1' print ====> COMP [0 | 1 | 2, default: 2] sql create database db COMP 1 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data13_db != 1 then return -1 endi sql drop database db sql create database db COMP 0 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data13_db != 0 then return -1 endi sql drop database db sql_error create database db COMP 3 sql_error create database db COMP -1 #print ====> DURATION value [60m ~ min(3650d,keep), default: 10d, unit may be minut/hour/day] #print ====> KEEP value [max(1d ~ 365000d), default: 1d, unit may be minut/hour/day] #sql create database db DURATION 60m KEEP 60m #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $data6_db != 60 then # return -1 #endi #if $data7_db != 60,60,60 then # return -1 #endi #sql drop database db #sql create database db DURATION 60m KEEP 1d #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $data6_db != 60 then # return -1 #endi #if $data7_db != 1440,1440,1440 then # return -1 #endi #sql create database db DURATION 3650d KEEP 365000d #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $data6_db != 5256000 then # return -1 #endi #if $data7_db != 525600000,525600000,525600000 then # return -1 #endi #sql drop database db #sql_error create database db DURATION -59m #sql_error create database db DURATION 59m #sql_error create database db DURATION 5256001m #sql_error create database db DURATION 3651d #sql_error create database db KEEP -59m #sql_error create database db KEEP 14399m #sql_error create database db KEEP 525600001m #sql_error create database db KEEP 365001d print ====> WAL_FSYNC_PERIOD value [0 ~ 180000 ms, default: 3000] sql create database db WAL_FSYNC_PERIOD 0 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data21_db != 0 then return -1 endi sql drop database db sql create database db WAL_FSYNC_PERIOD 180000 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data21_db != 180000 then return -1 endi sql drop database db sql_error create database db WAL_FSYNC_PERIOD 180001 sql_error create database db WAL_FSYNC_PERIOD -1 print ====> MAXROWS value [200~10000, default: 4096], MINROWS value [10~1000, default: 100] sql create database db MAXROWS 10000 MINROWS 1000 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data11_db != 1000 then return -1 endi if $data12_db != 10000 then return -1 endi sql drop database db sql create database db MAXROWS 200 MINROWS 10 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data11_db != 10 then return -1 endi if $data12_db != 200 then return -1 endi sql drop database db sql_error create database db MAXROWS -1 sql_error create database db MAXROWS 0 sql_error create database db MAXROWS 199 sql_error create database db MAXROWS 10001 sql_error create database db MINROWS -1 sql_error create database db MINROWS 0 sql_error create database db MINROWS 9 sql_error create database db MINROWS 1001 sql_error create database db MAXROWS 500 MINROWS 1000 print ====> PRECISION ['ms' | 'us' | 'ns', default: ms] sql create database db PRECISION 'us' sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data14_db != us then return -1 endi sql drop database db sql create database db PRECISION 'ns' sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data14_db != ns then return -1 endi sql drop database db sql_error create database db PRECISION 'as' sql_error create database db PRECISION -1 print ====> QUORUM value [1 | 2, default: 1] 3.0 not support this item #sql_error create database db QUORUM 2 #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $data5_db != 2 then # return -1 #endi #sql drop database db #sql create database db QUORUM 1 #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $data5_db != 1 then # return -1 #endi #sql drop database db sql_error create database db QUORUM 1 sql_error create database db QUORUM 2 sql_error create database db QUORUM 3 sql_error create database db QUORUM 0 sql_error create database db QUORUM -1 print ====> REPLICA value [1 | 3, default: 1] sql create database db REPLICA 3 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data4_db != 3 then return -1 endi sql drop database db sql create database db REPLICA 1 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data4_db != 1 then return -1 endi sql drop database db sql_error create database db REPLICA 2 sql_error create database db REPLICA 0 sql_error create database db REPLICA -1 sql_error create database db REPLICA 4 #print ====> TTL value [1d ~ , default: 1] #sql create database db TTL 1 #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $dataXX_db != 1 then # return -1 #endi #sql drop database db #sql create database db TTL 10 #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $dataXX_db != 10 then # return -1 #endi #sql drop database db #sql_error create database db TTL 0 #sql_error create database db TTL -1 print ====> WAL_LEVEL value [1 | 2, default: 1] sql create database db WAL_LEVEL 2 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data20_db != 2 then return -1 endi sql drop database db sql create database db WAL_LEVEL 1 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data20_db != 1 then return -1 endi sql drop database db sql_error create database db WAL_LEVEL 3 sql_error create database db WAL_LEVEL -1 sql_error create database db WAL_LEVEL 0 print ====> VGROUPS value [1~4096, default: 2] sql create database db VGROUPS 1 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data2_db != 1 then return -1 endi sql drop database db sql create database db VGROUPS 16 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $data2_db != 16 then return -1 endi sql drop database db sql_error create database db VGROUPS 4097 sql_error create database db VGROUPS -1 sql_error create database db VGROUPS 0 print ====> SINGLE_STABLE [0 | 1, default: ] sql create database db SINGLE_STABLE 1 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $dataXXXX_db != 1 then # return -1 #endi sql drop database db sql create database db SINGLE_STABLE 0 sql select * from information_schema.ins_databases print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $dataXXXX_db != 0 then # return -1 #endi sql drop database db sql_error create database db SINGLE_STABLE 2 sql_error create database db SINGLE_STABLE -1 #print ====> STREAM_MODE [0 | 1, default: ] #sql create database db STREAM_MODE 1 #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $dataXXX_db != 1 then # return -1 #endi #sql drop database db #sql create database db STREAM_MODE 0 #sql select * from information_schema.ins_databases #print $data0_db $data1_db $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db #if $dataXXX_db != 0 then # return -1 #endi #sql drop database db #sql_error create database db STREAM_MODE 2 #sql_error create database db STREAM_MODE -1 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