Stopping and Restarting Databases

Stopping a database means shutting it down. The database will be completely recoverable by restarting it again. Generally, no interaction with the database is allowed when the database is stopped. However, you can still edit the database in the Automation Console when the database is stopped. To stop a database in the Automation Console, click the stop button.

To stop a database in NuoDB Manager, we use the shutdown database command.

nuodb [domain] > show domain summary
 
Hosts:
[broker] * ec2-54-173-96-113.compute-1.amazonaws.com/172.31.14.118:48004 (us-east-1)
[broker] ip-172-31-46-122/54.165.58.157:48004 (us-east-1)
 
Database: test, template [Minimally Redundant] MET, processes [2 TE, 2 SM], ACTIVE
[SM] ip-172-31-14-118/54.173.96.113:48005 (us-east-1) [ pid = 21793 ] [ nodeId = 3 ] RUNNING
[TE] ip-172-31-14-118/54.173.96.113:48006 (us-east-1) [ pid = 21821 ] [ nodeId = 4 ] RUNNING
[SM] ip-172-31-46-122/54.165.58.157:48005 (us-east-1) [ pid = 17596 ] [ nodeId = 1 ] RUNNING
[TE] ip-172-31-46-122/54.165.58.157:48006 (us-east-1) [ pid = 17613 ] [ nodeId = 2 ] RUNNING
 
nuodb [domain] > shutdown database test
Timeout (ms/s/m/h/d/w) (optional): 
Remote process shutdown timeout (ms/s/m/h/d/w) (optional): 
Shutdown database test
nuodb [domain] > show domain summary
 
Hosts:
[broker] * ec2-54-173-96-113.compute-1.amazonaws.com/172.31.14.118:48004 (us-east-1)
[broker] ip-172-31-46-122/54.165.58.157:48004 (us-east-1)
 
Database: test, template [Minimally Redundant] UNMET STOPPED