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
-
If you are already on the Databases and Clusters page, skip to the next step; otherwise:
-
If no databases exist on the cluster, continue to the next step; otherwise:
- If a database is running on the cluster on which you want to add a new database, select the database and click Stop.
- Wait for the running database to have a status of Stopped.
- Click the cluster on which you want to create the new database and click Create Database.
-
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 theinstall_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.
- Click Continue.
-
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.
-
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.
- 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
-
If warnings occur during database creation, nodes will be marked on the UI with an Alert icon and a message.
- Warnings do not prevent the database from being created, but you should address warnings after the database creation process completes by viewing the database Message Center from the MC Home page.
- Failure messages display on the database Manage page with a link to more detailed information and a hint with an actionable task that you must complete before you can continue. Problem nodes are colored red for quick identification.
- To view more detailed information about a node in the cluster, double-click the node from the Manage page, which opens the Node Details page.
- To create MC users and grant them access to an MC-managed database, see About MC Users and Creating an MC User.