Recover a Node
- On all your nodes, delete the .pem key information for the failed source node in the following locations:
/root/.ssh/known_hosts
/home/dbadmin/.ssh/known_hosts
- On your main node, run the install script
install_vertica
, specifying:- your own key file
- -Y option as point-to-point
- dba user password disabled
- dba user dbadmin:
sudo /opt/vertica/sbin/install_vertica -i ~/userkey.pem -Y -- point-to-point --dba-user-password-disabled --dba-user dbadmin
- Connect to your target node with SSH, and configure its storage to match your source cluster's storage.
- Configure your target node:
- Create an empty catalog and data directory matching the source node:
mkdir -p /vertica/data/VMart/v_vmart_node0003_catalog
- Change the owner of the catalog and data directory to verticadba:
sudo chown dbadmin:verticadba /vertica/data/VMart
- Restart the target node using admintools, specifying the IP address of your target node and your database name:
admintools -t restart_node -s 10.0.10.15 -d VMart
Your target node will now recover using data from its buddy, making your cluster K-safe once again. Depending on the size of your database, recovery may take some time.