» Documentation

Create cluster 3

Install 6 stand-by nodes on 3 machines

Consider 3 machines (machine1, machine2, machine3):
1. On machine1 create folder: d:\scimoredb and d:\scimoredb\data ,d:\scimoredb\data1 (can be any drive)
2. Copy to the d:\scimoredb: scimoredb.exe,scimoreagent.exe,Scimore.Data.ScimoreClientNative.[x86/x64].dll.
3. Start commands prompt with admin rights and then execute installing instance/node command:

scimoredb.exe -startup/instance=0  -startup/console=1 -startup/mode=1 -db/cachepages=25000 -db/syslog="d:\scimoredb\data"  -db/systables="d:\scimoredb\data"  -db/data="d:\scimoredb\data" -net/endpoint="machine1:16250"

scimoredb.exe -startup/instance=1  -startup/console=1 -startup/mode=1 -db/cachepages=25000 -db/syslog="d:\scimoredb\data1"  -db/systables="d:\scimoredb\data1"  -db/data="d:\scimoredb\data1" -net/endpoint="machine1:16251" 

The command will create 2 distinct instances that will listen on 16250 and 16251 ports.

  1. Repeat the 3 for machine2 and machine3. (change machine name in "-net/endpoint...")
  2. start 6 scimoredb services on all 3 machines.

Create cluster

Start Scimore manager and connect to "machine1:16250". Open query window and execute following SQL:

create cluster endpoint('machine1:16250')
go;

add partition group
(
add endpoint('machine1:16250'),
add endpoint('machine2:16251')
)
go;
add partition group
(
add endpoint('machine2:16250'),
add endpoint('machine3:16251')
)
go;
add partition group
(
add endpoint('machine3:16250'),
add endpoint('machine1:16251')
)
go;
commit cluster; 

After executing, connect to either: machine1:16250,machine1:16251,machine2:16250,... Also, 3 partition groups mean that the data will be partitioned between 3 partitions and nodes belonging to the partition will share the same segment of the data.

NOTE: in the current example every insert/delete/update the modifications will be applied to 2 machines, the write sclability will suffer. Hence, reads will benefit nicelly the current cluster setup.