添加主机到集群
检查新增主机符合 主机配置要求 。
[root@vertica1 ~]# cd /opt/vertica/sbin/ [root@vertica1 sbin]# ./install_vertica --add-hosts 192.168.56.203 Vertica Analytic Database 10.0.0-0 Installation Tool >> Validating options... Mapping hostnames in --add-hosts (-A) to addresses... >> Starting installation tasks. >> Getting system information for cluster (this may take a while)... Enter password for root@192.168.56.203 (3 attempts left): Default shell on nodes: 192.168.56.203 /bin/bash 192.168.56.201 /bin/bash 192.168.56.202 /bin/bash >> Validating software versions (rpm or deb)... >> Beginning new cluster creation... successfully backed up admintools.conf on 192.168.56.203 successfully backed up admintools.conf on 192.168.56.201 successfully backed up admintools.conf on 192.168.56.202 >> Creating or validating DB Admin user/group... Successful on hosts (3): 192.168.56.203 192.168.56.201 192.168.56.202 Provided DB Admin account details: user = dbadmin, group = verticadba, home = /home/dbadmin Creating group... Group already exists Validating group... Okay Creating user... User already exists Validating user... Okay >> Validating node and cluster prerequisites... System prerequisites passed. Threshold = WARN >> Establishing DB Admin SSH connectivity... Installing/Repairing SSH keys for dbadmin >> Setting up each node and modifying cluster... Creating Vertica Data Directory... Updating agent... Creating node node0002 definition for host 192.168.56.203 ... Done >> Sending new cluster configuration to all nodes... Starting or restarting agent... >> Completing installation... Running upgrade logic Installation complete. Please evaluate your hardware using Vertica's validation tools: https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=VALSCRIPT To create a database: 1. Logout and login as dbadmin. (see note below) 2. Run /opt/vertica/bin/adminTools as dbadmin 3. Select Create Database from the Configuration Menu Note: Installation may have made configuration changes to dbadmin that do not take effect until the next session (logout and login). To add or remove hosts, select Cluster Management from the Advanced Menu.
从集群中移除主机
如果移除节点将会导致数据库当前K-safety级别下降,则不能移除。
如果必须要移除,需要首先降低数据库的K-safety级别。 变更K-safety level
在要移除的主机上,必须已经 移除数据库的节点 。否则不能移除该主机
[root@vertica1 ~]# cd /opt/vertica/sbin/ [root@vertica1 sbin]# ./install_vertica --remove-hosts 192.168.56.203 Vertica Analytic Database 10.0.0-0 Installation Tool >> Validating options... Mapping hostnames in --remove-hosts (-R) to addresses... >> Starting installation tasks. >> Getting system information for cluster (this may take a while)... Enter password for root@192.168.56.202 (3 attempts left): Default shell on nodes: 192.168.56.202 /bin/bash 192.168.56.201 /bin/bash >> Validating software versions (rpm or deb)... >> Beginning new cluster creation... successfully backed up admintools.conf on 192.168.56.202 successfully backed up admintools.conf on 192.168.56.201 >> Creating or validating DB Admin user/group... Successful on hosts (2): 192.168.56.202 192.168.56.201 Provided DB Admin account details: user = dbadmin, group = verticadba, home = /home/dbadmin Creating group... Group already exists Validating group... Okay Creating user... User already exists Validating user... Okay >> Validating node and cluster prerequisites... Skipping prerequiste checks because no hosts are being added >> Establishing DB Admin SSH connectivity... Installing/Repairing SSH keys for dbadmin >> Setting up each node and modifying cluster... Creating Vertica Data Directory... Removing node node0003 definition ... Done Updating agent... >> Sending new cluster configuration to all nodes... Starting or restarting agent... Stopping the agent on removed hosts ['192.168.56.203'] >> Completing installation... Running upgrade logic Installation complete. Please evaluate your hardware using Vertica's validation tools: https://www.vertica.com/docs/10.0.x/HTML/index.htm#cshid=VALSCRIPT To create a database: 1. Logout and login as dbadmin. (see note below) 2. Run /opt/vertica/bin/adminTools as dbadmin 3. Select Create Database from the Configuration Menu Note: Installation may have made configuration changes to dbadmin that do not take effect until the next session (logout and login). To add or remove hosts, select Cluster Management from the Advanced Menu.