Quiescing Databases

Quiescing a database means to bring it to a stage such that all database activity stops, such as ongoing non-DBA transactions, queries, fetches, or SQL statements. This is useful for performing certain DBA activities safely. To do this in the Automation Console click the quiesce button:

Quiescing a Database in NuoDB Manager

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 [Single Host] MET, processes [1 TE, 1 SM], ACTIVE
[SM] ip-172-31-46-122/54.165.58.157:48005 (us-east-1) [ pid = 20197 ] [ nodeId = 1 ] RUNNING
[TE] ip-172-31-46-122/54.165.58.157:48006 (us-east-1) [ pid = 20210 ] [ nodeId = 2 ] RUNNING
 
nuodb [domain] > quiesce 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 [Single Host] MET, processes [1 TE, 1 SM], INACTIVE
[SM] ip-172-31-46-122/54.165.58.157:48005 (us-east-1) [ pid = 20197 ] [ nodeId = 1 ] QUIESCED
[TE] ip-172-31-46-122/54.165.58.157:48006 (us-east-1) [ pid = 20210 ] [ nodeId = 2 ] QUIESCED