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.
1 |
Log in as the root user on the replacement auxiliary database station. |
2 |
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. where R.r.p is the NSP release identifier, in the form MAJOR.minor.patch v is a version number |
3 |
Open a console window. |
4 |
Navigate to the software directory. Note: The directory must contain only the installation files. |
5 |
Enter the following: # chmod +x * ↵ |
6 |
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: |
7 |
Enter the samauxdb password. The following prompt is displayed: Retype new password: |
8 |
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... |
9 |
If the script instructs you to perform a restart, perform the following steps.
|
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.
|
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.
|
20 |
When the station reboot is complete, log in as the root user on the replacement station and enter the following to enable auxiliary database services: # systemctl enable nspos-auxdbproxy.service ↵ # systemctl enable nspos-auxdb.service ↵ # systemctl enable nspos-nodeexporter.service ↵ |
21 |
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 |
22 |
Enter the following on the existing auxiliary database station: # /opt/nsp/nfmp/auxdb/install/bin/auxdbAdmin.sh configureTLS force-gen ↵ |
23 |
Enter the following on each auxiliary database station in the cluster to start the database proxy: # systemctl restart nspos-auxdbproxy.service ↵ |
24 |
Close the open console windows. End of steps |