Exploring the Automation Console

The Automation Console is the administration tool for NuoDB databases. It lets you create databases, manage their operation, monitor performance and view metrics and statistics. You can explore the functionality of the Automation Console by using the test database you created in the SQL QuickStart.

Click the Admin Center menu icon , which appears in the upper right corner of the SQL QuickStart page. In the top row, click Automation Console:

The Automation Console prompts you to enter a domain username and password. If you specified a password during installation then in the domain Username field enter domain and in the Password field 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 to sign in to the Automation Console.

If you already created an administrative user account then you can enter the username and password for that account. For information about creating a domain administrator account, see Creating the First Domain Administrator Account.

Click Sign In to display the Automation Console dashboard. The first thing you see are some metric widgets that as yet, show no data. In the left panel, click Databases.

This shows the test database you created in the SQL QuickStart. Click the database to display the following:

This shows that the database exists in one region and on one host. The database has two processes, which would be one transaction engine (TE) and one storage manager (SM). The database status is ACTIVE and the database was created with a Single Host template.

For more information, see Overview of Using the Automation Console.

In addition to the Automation Console, NuoDB provides the NuoDB Manager (nuodbmgr) command line tool, which you can also use to manage your domain and databases.

Next stop: SQL Explorer.