Creating Your First Database

These instructions assume that you have installed the NuoDB software and chosen to automatically start the NuoDB services. If you have not started NuoDB services, it is necessary to do so manually. See Starting and Stopping NuoDB Services.

To create a single host database, sign in to the NuoDB Automation Console. On Windows, you can access the Automation Console from the NuoDB system tray.

Alternatively, you can enter an address such as http://server:8888 in a browser, for example, http://localhost:8888.

If you are not already signed in then the Automation Console prompts you to enter a domain username and password. If you specified a password during installation then specify that password here with the default username domain. If you specified a password during installation but you have forgotten it then you can obtain the password from the $NUODB_HOME/etc/default.properties file. The domainPassword property specifies the password. If you already created an administrative user account then you can enter the username and password for that account. See Creating the First Domain Administrator Account.

A blank Automation Console opens. In the left panel, select Databases and then in the top right corner select Actions | Add Database, as shown below:

The Create Managed Database dialog appears:

Enter the database Name test, DBA User dba, and DBA Password dba. Leave the defaults for everything else. Click Submit when finished. You now have a NuoDB database called test running on your machine:

This NuoDB database includes one broker, one storage manager (SM), one transaction engine (TE) and one storage group. It currently has no user data in it. Take some time to explore the NuoDB Automation Console. For example, you can click on the test database to get a description of it:

Database test is running in one region, with two processes on one host. It is using the Single Host template and is actively running. Click 2 Processes to display information about the database's processes:

There are two processes running. One process is a storage manager (SM) and one process is a transaction engine (TE).

In the top right corner, click the yellow disk icon to create the nuodb_system database. The familiar Create Managed Database dialog appears. Enter the password you entered during installation. If you have forgotten this password then you can obtain it from the NUODB_HOME/etc/default.properties file. In that file, the setting of the domainPassword property is the password you need to enter. After the nuodb_system database is created, it stores metrics for all hosts, databases and processes in the domain. To view these metrics, click Dashboard in the upper left side of the Automation Console. You can see data for CPU and memory. For details, see Obtaining Metrics for the Domain, Hosts and Processes.