Hi,
Is it possible to run two different databases in Vertica on the same cluster if the databases are running on different ports?
Running more than one Database
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Running more than one Database
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!!!
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!
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.
#
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
-
- Beginner
- Posts: 42
- Joined: Thu Apr 19, 2012 9:03 pm
Re: Running more than one Database
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 Is there a way I can switch back to 5433 (the default)?
But now my admintools is stuck using port 5437 for every new database Is there a way I can switch back to 5433 (the default)?
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Running more than one Database
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Running more than one Database
> 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.
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
Vertica Consultant, Zazz Technologies LLC
Re: Running more than one Database
Nice hack Jim.
I had heard about this being possible, but never knew how you do it.
I had heard about this being possible, but never knew how you do it.
-
- Beginner
- Posts: 42
- Joined: Thu Apr 19, 2012 9:03 pm
Re: Running more than one Database
Thanks Jim! Changing the last_port parameter worked!
Scutter, thanks for the advice about the general pool sizing.
Scutter, thanks for the advice about the general pool sizing.