{question}

How can I check the storage group serviced by each of my databases in the domain and their status?

{question}

{answer}

The information is available by the following command:

$NUODB_HOME/bin/nuodbmgr --broker <host> --password <password> --command "show storageGroups"

Here is an example of output:

Database: cmc
[id=1] ALL Available
No Leader Candidates.
[id=2] UNPARTITIONED Available
Leader Candidates:
[SM] nuosm1a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us/nuosm1a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us:48005 (DC-A) [ pid = 22113 ] [ nodeId = 1 ] RUNNING
[SM] nuosm2a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us/nuosm2a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us:48005 (DC-A) [ pid = 14751 ] [ nodeId = 2 ] RUNNING
[SM] nuosm3a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us/nuosm3a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us:48005 (DC-A) [ pid = 1827 ] [ nodeId = 3 ] RUNNING
[SM] nuosm4a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us/nuosm4a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us:48005 (DC-A) [ pid = 708 ] [ nodeId = 4 ] RUNNING
[id=10] SG0 Available
Leader Candidates:
[SM] nuosm1a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us/nuosm1a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us:48005 (DC-A) [ pid = 22113 ] [ nodeId = 1 ] RUNNING
[id=11] SG1 Available
Leader Candidates:
[SM] nuosm2a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us/nuosm2a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us:48005 (DC-A) [ pid = 14751 ] [ nodeId = 2 ] RUNNING
[id=12] SG2 Available
Leader Candidates:
[SM] nuosm3a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us/nuosm3a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us:48005 (DC-A) [ pid = 1827 ] [ nodeId = 3 ] RUNNING
[id=13] SG3 Available
Leader Candidates:
[SM] nuosm4a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us/nuosm4a.neverest-long-8x8-k.ca-central-1.ndbtest-02.us:48005 (DC-A) [ pid = 708 ] [ nodeId = 4 ] RUNNING

You may find more information here.

{answer}