Vertica Analytics Platform Version 9.2.x Documentation

Create a Database on a Cluster

After you use the MC Cluster Installation Wizard to create a Vertica cluster, you can create a database on that cluster through the MC interface. You can create the database on all cluster nodes or on a subset of nodes.

If a database had been created using the Administration Tools on any of the nodes, MC detects (autodiscovers) that database and displays it on the Manage (Cluster Administration) page so you can import it into the MC interface and begin monitoring it.

MC allows only one database running on a cluster at a time, so you might need to stop a running database before you can create a new one.

The following procedure describes how to create a database on a cluster that you created using the MC Cluster Installation Wizard. To create a database on a cluster that you created by running the install_vertica script, see Creating an Empty Database.

Create a Database on a Cluster

To create a new empty database on a new 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.
  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, and 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. Do not use the default agent port 5444 as a new setting for the MC application/web server 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 and then the database is started and a Success message appears.

  8. Click OK to close the success message.

    The Database Manager page opens and displays the database nodes. Nodes not included in the database are gray.