Adding a Storage Group Using NuoDB Manager

Adding a storage group in nuodbmgr is done with the add storageGroup command which associates the storage group with a specific SM. This command takes three arguments: the name of the storage group, the host on which the SM is running, and the process ID (pid) of the SM on that host.

By default, when no storage groups have been added, only the UNPARTITIONED storage group is available.

nuodb [domain] > show storageGroups
Database: test
  [id=2] UNPARTITIONED Available
    Serviced by:
    [SM] ip-172-31-14-56/52.25.88.188:48005 (us-west-2) [ pid = 13274 ] [ nodeId = 1 ] RUNNING
    [SM] ip-172-31-14-171/52.24.143.83:48006 (us-west-2) [ pid = 6535 ] [ nodeId = 3 ] RUNNING
 
  [id=1] ALL Available
    Serviced by:

The following example adds the storage group SG1 to one of the two available SMs and then adds the storage group SG2 to the other SM. This means one SM will service SG1 and the other will service SG2.

nuodb [domain] > add storageGroup
Storage group name: sg1
Host: 52.25.88.188
Process ID: 13274
Success
nuodb [domain] > add storageGroup
Storage group name: sg2
Host: 52.24.143.83
Process ID: 6535
Success
nuodb [domain] > show storageGroups
Database: test
  [id=2] UNPARTITIONED Available
    Serviced by:
    [SM] ip-172-31-14-56/52.25.88.188:48005 (us-west-2) [ pid = 13274 ] [ nodeId = 1 ] RUNNING
    [SM] ip-172-31-14-171/52.24.143.83:48006 (us-west-2) [ pid = 6535 ] [ nodeId = 3 ] RUNNING
 
  [id=10] SG1 Available
    Serviced by:
    [SM] ip-172-31-14-56/52.25.88.188:48005 (us-west-2) [ pid = 13274 ] [ nodeId = 1 ] RUNNING
 
  [id=11] SG2 Available
    Serviced by:
    [SM] ip-172-31-14-171/52.24.143.83:48006 (us-west-2) [ pid = 6535 ] [ nodeId = 3 ] RUNNING
 
  [id=1] ALL Available
    Serviced by: