Restart Database

This is a NuoDB Manager command. See NuoDB Manager.

Description

Restart a database based on a captured database configuration file. (See Capture Database.)

Note: To stop and restart a database, simply use the NuoDB Manager shutdown database and restart database commands.

Note: Even when a TE process host is unreachable, it will be skipped and the Restart command will still restart the database as long as all SM processes specified in the capture file are reachable.

See the following:

Syntax

restart database dbFile file_name [timeout timeout_value] [incremental false]

Parameters

Useful Properties

restartTimeout

See NuoDB Manager Properties.

Interactive Example

Restart database test based on a capture file called mydb.cfg. This database has 1 TE and 1 SM.

nuodb [domain/test15] > restart database
Database Description File: mydb.cfg
Timeout (ms/s/m/h/d/w) (optional): 
 
Re-starting database: test
Started: [SM] ip-172-31-14-171/52.24.143.83:48007 (us-west-2) [ pid = 4720 ] [ db = test15 ] [ nodeId = 1 ] ACTIVE
Started: [TE] ip-172-31-14-171/52.24.143.83:48008 (us-west-2) [ pid = 4740 ] [ db = test15 ] [ nodeId = 2 ] ACTIVE

Scripting Example

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

nuodbmgr --broker host --password password \
    --command "restart database dbFile mydb.cfg"
   database test \
    host localhost \
    options '--dba-user dba --dba-password goalie'"