Install Vertica Management Console

Vertica_User

Hi,
we have 36 node Vertica cluster (7.2) running. Would like to install MC 9.0x.
We have 30% space in all the 36 nodes.
Please let me know whether can we install in any one of the node.
Will it affect the disk space drastically?
While installing MC, can all nodes be up & running?

Jim_Knicely

Hi,

You can install MC on any of the nodes. I have had MC running for a while and the disk space needed is relatively low, but that depends on the number of MC users.

[dbadmin@s18384357 opt]$ du -h vconsole --summarize
1.2G vconsole

When you install MC all Vertica nodes can be up and running.

Note that MC will use resources on the server you install it, so it could cause a performance hit on the cluster, especially if there are many MC users.

Also, you mentioned that you currently have 30% disk free. For best performance/results, Vertica recommends to have at least 40% free...

See:
https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AdministratorsGuide/ConfiguringTheDB/DiskSpaceRequirementsForHPVertica.htm

Vertica_User

Thanks Jim. I am planning to install MC outside of cluster . Hope we need 5450 port needs to be opened

Jim_Knicely

The ports you need to open for MC are 5444 and 5450.

See:
https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/InstallationGuide/BeforeYouInstall/EnsurePortsAreAvailable.htm

Vertica_User

When I installed MC, port 5450 is open and I got a timeout error while accessing MC URL.
However 5444 is not available. I am sure that we can change the port.
Could you please help

Jim_Knicely

Are you sure 5450 is open?

Try running: telnet [your MC host name] 5450

If the port is open you will see a "Connected to [your MC host name]" msg. If it's not open, you'l see a time out or deny msg.

Vertica_User

Hi Jim,
Yes, it is open.

Jim_Knicely

Hi,

Port 5444 provides MC-to-node and node-to-node (agent) communications for database create/import and monitoring activities.

If you can't open 5444, you can change the port used by the MC agent!

See:
https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/ManagementConsole/ChangingPorts/HowToChangeTheAgentPort.htm

Vertica_User

Thanks Jim.
I am planning to choose a port which is not open now and try to change the port for MC agent. (alternative for 5444).

As port 5450 is open and some Java process using this port.
Can I still use this port?
If yes, why the URL is not working?
If no, will find some unused port & change the MC port with new one.

Please let me know your thoughts

Jim_Knicely

Some other service might already be listening on port 5450. What do you see if you run this command on the MC node?

netstat -plnt | grep 5450

Vertica_User

raplz-po-a02 -LZ2 ~> sudo netstat -plnt | grep 5450
tcp 0 0 0.0.0.0:5450 0.0.0.0:* LISTEN 32823/java

Jim_Knicely

For TCP, typically there is only one application that listens on a single port at any given time. However, there are options available to change that behavior. But if I were you, since your Java app is already listening on 5450, I'd pick another port for MC.

Vertica_User

ok.. thanks .. let me pick two ports one for agent & MC ..