Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Can two database share a cluster? Can two clusters be on the same machines?
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
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.