Create Database

This is a NuoDB Manager command. See NuoDB Manager.

Description

Create a new managed databaseWhen a NuoDB-provided template is used to create a database then that database is a managed database. Databases created from the Automation Console are always managed databases. You can also use the NuoDB Manager command line tool to create a managed database..

Syntax

create database 
    dbname database_name
    template template_name
    dbaUser dba_username
    dbaPassword dba_password
    [options option_list]
    [variables variable_list]
    [groupOptions:groupName option_list]...
    [tagConstraints:groupName constraint_list]...
    [timeout timeout_value]

Parameters

Useful Properties

createTimeout

See NuoDB Manager Properties.

Interactive Examples

Scripting Example

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

nuodbmgr --broker host --password password \
    --command "create database \
    dbname test \
    template 'Single Host' \
    dbaUser dba \
    dbaPassword dba \
    variables 'HOST ec2-54-200-117-181.us-west-2.compute.amazonaws.com' "
nuodbmgr --broker host --password password \
    --command "create database \
    dbname test2 \
    template 'Minimally Redundant' \
    dbaUser dba \
    dbaPassword dba \
    variables 'REGION us-west-2 SM_MAX 2' \
    groupOptions:SMs 'journal-max-directory-entries 500' \
    tagConstraints:SMs 'HOST_FOR_SM ex:' \
    tagConstraints:TEs 'HOST_FOR_TE ex:' "