Quiesce Database

This is a NuoDB Manager command. See NuoDB Manager.

Description

Causes transaction engines (TEs) in the specified database to cease operations. This command does not shut down the database. Quiescing requests wait for all syncing NuoDB storage managers to finish before the request is processed. Depending on the number of storage managers and the state of the archive directories, this could take some time.

Syntax

quiesce database database_name [timeout timeout_value]

Parameters

Useful Properties

quiesceTimeout

See NuoDB Manager Properties.

Interactive Example

nuodb [domain/test] > show domain processes
 
Database: test
[SM] local/10.1.37.172:51370 (DEFAULT_REGION) [ pid = 22652 ] [ nodeId = 1 ] RUNNING
[TE] local/10.1.37.172:51371 (DEFAULT_REGION) [ pid = 22654 ] [ nodeId = 2 ] RUNNING
 
nuodb [domain/test] > quiesce database test
Timeout (duration ms/s/m/h/d/w) (optional): 
nuodb [domain/test] > show domain processes
 
Database: test
[SM] local/10.1.37.172:51370 (DEFAULT_REGION) [ pid = 22652 ] [ nodeId = 1 ] QUIESCED
[TE] local/10.1.37.172:51371 (DEFAULT_REGION) [ pid = 22654 ] [ nodeId = 2 ] QUIESCED

Scripting Example

The same quiesce database command can be executed with --command as follows:

nuodbmgr --broker host --password password --command "quiesce database test"