Running 2 databases on the same cluster/node

ssheikh

After speaking to customer support, I became aware that it is possible to run 2 databases concurrently on the same node and cluster and was wondering how I can actually do so.

 

Thanks!

[Deleted User]

You can run them in different ports (default 5433) but it is not supported and neither recommended.

What is your use case? Why you would like to do this?

Eugenia

Rahul_Choudhary

Hi 

 

Just for your information this is not officially recommended & neither supported & if you still wish to try the same it is at your own discretion Also as Eugenia said you can run them on different ports apart from 5433 which is default port for Vertica to run.

 

 

Regards

Rahul Choudhary

ssheikh

I understand that it is not supported - I was just looking to run one for development and the other for QA purposes. I was not planning on running both in the live deployment. 

ssheikh

And how exactly would I change the port for the other database?

Adrian_Oprea_1

You just need to alter you admintools.conf file. You will find it in the /opt/vertica/config/admintools.conf.

 

You actual database is running on the default port 5433, in your admintools.conf file you have an entry called last_port;

-make sure you alter this parameter and give it a different value"port number". 

 Make sure that this port is not in use.

netstat -antu | grep "port number here"

After you edit your admintools.conf create a new database, this new database will use the new port you entered in the last_port parameter in the admintools.conf file.

Finally the admintools.conf should look like this.

[dbadmin@DCG023 config]$ cat admintools.conf
[Configuration]
last_port = 5439 
default_base = /home/dbadmin
format = 3
install_opts = --update --rpm '/home/oracle/vertica-7.1.1-0.x86_64.RHEL5.rpm' --failure-threshold NONE
spreadlog = False
controlsubnet = default
controlmode = broadcast
tmp_dir = /tmp

[Cluster]
hosts = 127.0.0.1

[Nodes]
node0001 = 127.0.0.1,/home/dbadmin,/home/dbadmin
v_t_node0001 = 127.0.0.1,/home/dbadmin,/home/dbadmin
v_t2_node0001 = 127.0.0.1,/home/dbadmin,/home/dbadmin

[Database:t]
restartpolicy = ksafe
port = 5433
path = /home/dbadmin/t
nodes = v_t_node0001

[Database:t2]
restartpolicy = ksafe
port = 5439
path = /home/dbadmin/t2/v_t2_node0001_catalog
nodes = v_t2_node0001

  I don't need to say that this is not recomended and also that you need to backup you admintools.conf file before you try re-invent the wheel .

Hope this was helpfull. 

ssheikh

Thank you so much!