Running more than one Database

Moderator: NorbertKrupa

billykopecki
Beginner
Beginner
Posts: 42
Joined: Thu Apr 19, 2012 9:03 pm

Running more than one Database

Post by billykopecki » Mon Dec 08, 2014 2:45 pm

Hi,

Is it possible to run two different databases in Vertica on the same cluster if the databases are running on different ports?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Running more than one Database

Post by JimKnicely » Mon Dec 08, 2014 3:08 pm

It is possible to have two concurrently running databases if they use unique ports. If you launch admintools and include the –u switch, you will be able to create a new database on a unique port. The –u option causes newly created databases to get the next available port range.

Note that the -u switch comes with these caveats as describes in the admintools python script!!!

Code: Select all

#
# Super secret arguments (not in -h, not documented, and unknown users.)  Also
# known as instant technical debt.  Notice also that they need to be specified
# in order.
#
# Almost all of them are for internal testing.  If you are a customer reading
# this, please do not use these options.  We promise to break your work in the
# future.
#
Also, please heed HP’s warning that you should have only one concurrent active (i.e. UP) database. The results of running more than one database concurrently is highly unpredictable. There could be resource conflicts and users can potentially perform unintended operations in the wrong database!
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

billykopecki
Beginner
Beginner
Posts: 42
Joined: Thu Apr 19, 2012 9:03 pm

Re: Running more than one Database

Post by billykopecki » Mon Dec 08, 2014 4:31 pm

Thanks, I've tried the -u option and I see that Vertica will use a new port (i.e. 5437). And I can bring up two databases. Cool!

But now my admintools is stuck using port 5437 for every new database :cry: Is there a way I can switch back to 5433 (the default)?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Running more than one Database

Post by JimKnicely » Mon Dec 08, 2014 4:55 pm

Edit the /opt/vertica/config/admintools.conf file and change the last_port parameter value in the [Configuration] section from 5437 to 5433.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

scutter
Master
Master
Posts: 302
Joined: Tue Aug 07, 2012 2:15 am

Re: Running more than one Database

Post by scutter » Mon Dec 08, 2014 5:38 pm

> And I can bring up two databases.

As Jim stated earlier, you shouldn’t run two databases at the same time. If you do, you’ll need to adjust the resource pools so that at minimum memory isn’t overcommitted. If you do, you need to plan ahead. Give the general pool ~47% of memory instead of 95%. If you allow both dbs to use all of memory, the system will swap, and you’re likely to lose node connectivity.
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: Running more than one Database

Post by nnani » Mon Dec 08, 2014 10:26 pm

Nice hack Jim.
I had heard about this being possible, but never knew how you do it.
nnani........
Long way to go

You can check out my blogs at vertica-howto

billykopecki
Beginner
Beginner
Posts: 42
Joined: Thu Apr 19, 2012 9:03 pm

Re: Running more than one Database

Post by billykopecki » Tue Dec 09, 2014 1:51 pm

Thanks Jim! Changing the last_port parameter worked!

Scutter, thanks for the advice about the general pool sizing.

Post Reply

Return to “Vertica Database Administration”