Skip to main content

Can I create multiple databases on one cluster?

  • April 15, 2014
  • 3 replies
  • 17 views

Wayne_1
Forum|alt.badge.img
Can I create multiple databases on one cluster (3 nodes)? I already have one dev database on that cluster. But I want to create a new dev database there for different project. is it okay or Vertica does NOT recommend multiple database on one cluster? thnaks.

3 replies

R_McKeon
Forum|alt.badge.img
  • Participating Frequently
  • April 15, 2014
Hello Wayne,

We do NOT support multiple databases in Production environments. You can, however, create multiple databases on Development/QA clusters.

Thanks,
Rory

Navin_C
Forum|alt.badge.img+2
  • Participating Frequently
  • April 15, 2014
Hi Wayne,

You can create multiple databases, but you can run only one database at a time.

So suppose you want to run another database

1. Stop currently running database
2. Start the new database.

Hope this helps

Wayne_1
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • April 16, 2014
thanks!!