Create an Empty Database Using MC

You can create a new database on an existing Vertica cluster through the Management Console interface.

Database creation can be a long-running process, lasting from minutes to hours, depending on the size of the target database. You can close the web browser during the process and sign back in to MC later; the creation process continues unless an unexpected error occurs. See the Notes section below the procedure on this page.

You currently need to use command line scripts to define the database schema and load data. Refer to the topics in Configuration Procedure. You should also run the Database Designer, which you access through the Administration Tools, to create either a comprehensive or incremental design. Consider using the Tutorial in Getting Started to create a sample database you can start monitoring immediately.

How to Create an Empty Database on an MC-managed Cluster

  1. If you are already on the Databases and Clusters page, skip to the next step; otherwise:

    1. Connect to MC and sign in as an MC administrator.
    2. On the Home page, click Existing Infrastructure to view the Databases and Clusters page.
  2. If no databases exist on the cluster, continue to the next step; otherwise:

    1. If a database is running on the cluster on which you want to add a new database, select the database and click Stop.
    2. Wait for the running database to have a status of Stopped.
  3. Click the cluster on which you want to create the new database and click Create Database.
  4. The Create Database wizard opens. Provide the following information:

    • Database name and password. See Creating a Database Name and Password for rules.
    • Optionally click Advanced to open the advanced settings and change the port, catalog path, and data path. By default the MC application/web server port is 5450 and paths are /home/dbadmin, or whatever you defined for the paths when you ran the Cluster Creation Wizard or the install_vertica script. Do not use the default agent port 5444 as a new setting for the MC port. See MC Settings > Configuration for port values.
  5. Click Continue.
  6. Select nodes to include in the database.

    The Database Configuration window opens with the options you provided and a graphical representation of the nodes appears on the page. By default, all nodes are selected to be part of this database (denoted by a green check mark). You can optionally click each node and clear Include host in new database to exclude that node from the database. Excluded nodes are gray. If you change your mind, click the node and select the Include check box.

  7. Click Create in the Database Configuration window to create the database on the nodes.

    The creation process takes a few moments, after which the database starts and a Success message appears on the interface.

  8. Click OK to close the success message.

The Manage page opens and displays the database nodes. Nodes not included in the database are colored gray, which means they are standby nodes you can include later. To add nodes to or remove nodes from your Vertica cluster, which are not shown in standby mode, you must run the install_vertica script.

Notes