These are the rules you must follow: a. A given host can only be included in one cluster. The cluster is created when you supply the list of cluster hosts to the install_vertica script. b. You can create any number of databases on a cluster, but can only run one database at a time on any given host of the cluster. c. When you create a new database on a set of cluster hosts, Vertica must not be running already on any of the hosts in the set. These common scenarios work according to the above rules:
Create a Vertica database on all hosts in the cluster (database starts).
Stop the first database.
Create a second database on all hosts in the cluster (second database starts).
Stop the second database.
Start the first database. and:
Create a Vertica database on nodes 1 - M of an N-Node cluster (M < N).
Create a second Vertica database on nodes M+1 - N of the cluster.
Both databases are running. You can connect to one or the other, according to which cluster host you connect to.
Stop and restart each database independently of the other.
Notes: Vertica expects to use all host resources when it is running. Thus, if you need to run two databases at the same time, you must either have two clusters, or else create the databases on disjoint subsets hosts of one cluster. If different databases run at different times on the same set of hosts (scenario 1), take care when connecting to supply the database identification to avoid accidents.
![[Deleted User]](http://wa.vanillicon.com/v2/a5bf2a0de91cbd14b54340477d4a7a54.svg)
Comments
- Create a Vertica database on all hosts in the cluster (database starts).
- Stop the first database.
- Create a second database on all hosts in the cluster (second database starts).
- Stop the second database.
- Start the first database. and:
- Create a Vertica database on nodes 1 - M of an N-Node cluster (M < N).
- Create a second Vertica database on nodes M+1 - N of the cluster.
- Both databases are running. You can connect to one or the other, according to which cluster host you connect to.
- Stop and restart each database independently of the other.
Notes: Vertica expects to use all host resources when it is running. Thus, if you need to run two databases at the same time, you must either have two clusters, or else create the databases on disjoint subsets hosts of one cluster. If different databases run at different times on the same set of hosts (scenario 1), take care when connecting to supply the database identification to avoid accidents.