How do I replace an auxiliary database station?

Purpose

Perform this procedure to replace an auxiliary database station with a station that has the same IP address, for example, after a hardware failure.

 

Log in as the root user on the replacement auxiliary database station.


Transfer the following auxiliary database installation files to an empty directory on the auxiliary database station:

Note: You must ensure that the directory is empty.

Note: In subsequent steps, the directory is called the software directory.

  • nspos-auxdb-R.r.p-rel.v.rpm

  • VerticaSw_PreInstall.sh

  • nspos-jre-R.r.p-rel.v.rpm

  • vertica-R.r.p-rel.tar

where

R.r.p is the NSP release identifier, in the form MAJOR.minor.patch

v is a version number


Open a console window.


Navigate to the software directory.

Note: The directory must contain only the installation files.


Enter the following:

chmod +x * ↵


Enter the following:

./VerticaSw_PreInstall.sh ↵

The script displays configuration messages like the following, and a prompt:

INFO: About to set kernel parameters in /etc/sysctl.conf...

INFO: Completed setting kernel parameters in /etc/sysctl.conf...

INFO: About to change the current values of the kernel parameters INFO:

Completed changing the current values of the kernel parameters

INFO: About to set ulimit parameters in /etc/security/limits.conf...

INFO: Completed setting ulimit parameters in /etc/security/limits.conf...

Checking Vertica DBA group samauxdb... 

Adding Vertica DBA group samauxdb... 

Checking Vertica user samauxdb... 

Adding samauxdb... 

Set password for samauxdb...

New password:


Enter the samauxdb password.

The following prompt is displayed:

Retype new password:


Re-enter the password.

Messages like the following are displayed:

Changing password for user samauxdb.

passwd: all authentication tokens updated successfully.

Changing ownership of the directory /opt/nsp/nfmp/auxdb to samauxdb:samauxdb.

Adding samauxdb to sudoers file.

Changing ownership of /opt/nsp/nfmp/auxdb files.

INFO: About to add setting to /etc/rc.d/rc.local...

INFO: Completed adding setting to /etc/rc.d/rc.local...


If the script instructs you to perform a restart, perform the following steps.

  1. Enter the following:

    systemctl reboot ↵

    The station reboots.

  2. When the reboot is complete, log in to the station as the root user.

  3. Open a console window.

  4. Navigate to the software directory.


10 

Enter the following:

tar xvf vertica-R.r.p-rel.tar $(tar tf vertica-R.r.p-rel.tar | sort -V | tail -1) ↵


11 

Enter the following:

dnf install *.rpm ↵

The dnf utility resolves any package dependencies, and displays the following prompt:

Total size: nn G

Installed size: nn G 

Is this ok [y/d/N]: 


12 

Enter y. The following and the installation status are displayed as each package is installed:

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

The package installation is complete when the following is displayed:

Complete!


13 

Perform the following steps on each auxiliary database station.

  1. Log in to the station as the root user.

  2. Open a console window.

  3. Enter the following:

    rm -f ~root/.ssh/known_hosts ↵

  4. Enter the following:

    rm -f ~samauxdb/.ssh/known_hosts ↵


14 

Log in to an existing auxiliary database station as the root user.

Note: The station must be an auxiliary database station other than the station that you are replacing.


15 

Open a console window.


16 

Open the /etc/security/limits.conf file for viewing.


17 

Copy the following lines:

# The following 1 line added by Vertica tools. timestamp

samauxdb - nice value

# The following 1 line added by Vertica tools. timestamp

samauxdb - nofile value


18 

Close the file.


19 

Transfer the copied lines to the new station.

  1. Log in as the root user on the replacement station.

  2. Open the /etc/security/limits.conf file using a plain-text editor such as vi.

  3. Paste in the lines copied in Step 17 at the end of the file.

  4. Close the file.

  5. Enter the following to reboot the replacement station:

    systemctl reboot ↵


20 

When the station reboot is complete, enter the following on an existing auxiliary database station:

/opt/nsp/nfmp/auxdb/install/bin/auxdbAdmin.sh recoverNode internal_IP

where internal_IP is the internal auxiliary database IP address of the failed station


21 

You are prompted to enter the auxiliary database dba password.

Enter the samauxdb password.


22 

You are prompted to enter the root user password for the replacement station.

Enter the password of the root user account on the replacement station.


23 

Log in to the replacement station as the root user.


24 

Open a console window.


25 

Enter the following:

# systemctl start nspos-auxdbproxy.service ↵

Messages like the following are displayed:

hh:mm:ss Day mm/dd/yy : Starting NFM-P Auxiliary DB Proxy ...

hh:mm:ss Day mm/dd/yy : Refer to log_file for startup status.

The replacement station initializes, and the data is rebalanced among the auxiliary database stations.


26 

Close the open console windows.

End of steps