Behavior of Storage Groups

Storage groups are serviced by zero or more Storage Managers (SMs). For a storage group to be available, it must be serviced by at least one SM.

A storage group is created using the add storageGroup command in nuodbmgr. The storage group assignment to an SM can also be managed by the database option, storage-group, when initializing an archive.

The following rules apply to storage groups:

Note: In a database with multiple storage groups, a SM may service more than one storage group (more than one logical partition has the same physical location) and a storage group may be serviced by more than one SM (for redundancy and availability).