To upgrade a standalone Release 22.9 or later auxiliary database
Description
The following procedure describes how to upgrade a standalone NSP auxiliary database from Release 22.9 or later.
Note: You require the following user privileges on each station:
Note: Ensure that you record the information that you specify, for example, directory names, passwords, and IP addresses.
Note: The following RHEL CLI prompts in command lines denote the active user, and are not to be included in typed commands
Steps
Obtain software | |||
1 |
Download the following installation files to an empty local directory on a station that is reachable by each station in the auxiliary database cluster: where R.r.p is the NSP release identifier, in the form MAJOR.minor.patch v is a version number | ||
Back up database | |||
2 |
If you specify a backup location on the database data partition, data loss or corruption may occur. The auxiliary database backup location must be an absolute path on a partition other than the database data partition. Back up the auxiliary database as described in the NSP System Administrator Guide for the installed release. Note: The backup location requires 20% more space than the database data consumes. Note: If the backup location is remote, a 1 Gb/s link to the location is required; if achievable, a higher-capacity link is recommended. | ||
Stop and disable database proxies | |||
3 |
Perform one of the following to stop the auxiliary database services:
| ||
Enable auxiliary database maintenance mode | |||
4 |
Enable nspos-auxdb-agent maintenance mode.
| ||
Stop auxiliary database | |||
5 |
Log in as the root user on an auxiliary database station. | ||
6 |
Open a console window. | ||
7 |
Enter the following: # cd /opt/nsp/nfmp/auxdb/install/bin ↵ | ||
8 |
Enter the following to stop the auxiliary database: # ./auxdbAdmin.sh stop ↵ | ||
9 |
Enter the following to display the auxiliary database status: # ./auxdbAdmin.sh status ↵ Information like the following is displayed: Database status Node | Host | State | Version | DB ------------+---------------+-------+---------+------- node_1 | internal_IP_1 | STATE | version | db_name node_2 | internal_IP_2 | STATE | version | db_name . . . node_n | internal_IP_n | STATE | version | db_name Output captured in log_file The cluster is stopped when each STATE entry reads DOWN. | ||
10 |
Repeat Step 9 periodically until the cluster is stopped. Note: You must not proceed to the next step until the cluster is stopped. | ||
Prepare all stations for upgrade | |||
11 |
Perform Step 13 to Step 30 on each auxiliary database station. | ||
12 |
Go to Step 31. | ||
Prepare individual station for upgrade | |||
13 |
If the auxiliary database station is deployed in a VM created using an NSP RHEL OS disk image, perform To apply a RHEL update to an NSP image-based OS. | ||
14 |
Log in as the root user on the auxiliary database station. | ||
15 |
Open a console window. | ||
16 |
Perform one of the following to stop the database services:
| ||
17 |
Perform one of the following to disable the database services:
| ||
18 |
Transfer the downloaded installation files to an empty directory on the station. Note: You must ensure that the directory is empty. Note: In subsequent steps, the directory is called the NSP software directory. | ||
19 |
Navigate to the NSP software directory. Note: The directory must contain only the installation files. | ||
20 |
Enter the following: # chmod +x * ↵ | ||
21 |
Enter the following: # ./VerticaSw_PreInstall.sh ↵ Messages like the following are displayed: Logging Vertica pre install checks to log_file INFO: About to remove proxy parameters set by a previous run of this script from /etc/profile.d/proxy.sh INFO: Completed removing proxy parameters set by a previous run of this script from /etc/profile.d/proxy.sh INFO: About to set proxy parameters in /etc/profile.d/proxy.sh... INFO: Completed setting proxy parameters in /etc/profile.d/proxy.sh... INFO: About to remove kernel parameters set by a previous run of this script from /etc/sysctl.conf INFO: Completed removing kernel parameters set by a previous run of this script from /etc/sysctl.conf 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 remove ulimit parameters set by a previous run of this script from /etc/security/limits.conf INFO: Completed removing ulimit parameters set by a previous run of this script from /etc/security/limits.conf 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... WARNING: Vertica DBA group with the specified name already exists locally. Checking Vertica user samauxdb... WARNING: Vertica user with the specified name already exists locally. Changing ownership of the directory /opt/nsp/nfmp/auxdb/install to samauxdb:samauxdb. Adding samauxdb to sudoers file. Changing ownership of /opt/nsp/nfmp/auxdb files. INFO: About to remove commands set by a previous run of this script from /etc/rc.d/rc.local INFO: Completed removing commands set by a previous run of this script from /etc/rc.d/rc.local INFO: About to add setting to /etc/rc.d/rc.local... INFO: Completed adding setting to /etc/rc.d/rc.local... | ||
22 |
Enter the following to reboot the station: # systemctl reboot ↵ The station reboots. | ||
23 |
When the reboot is complete, log in as the root user on the station. | ||
24 |
Open a console window. | ||
25 |
Enter the following: # cd /opt/nsp/nfmp/auxdb/install/bin ↵ | ||
26 |
Enter the following to display the auxiliary database status: # ./auxdbAdmin.sh status ↵ Information like the following is displayed: Database status Node | Host | State | Version | DB ------------+---------------+-------+---------+------- node_1 | internal_IP_1 | STATE | version | db_name node_2 | internal_IP_2 | STATE | version | db_name . . . node_n | internal_IP_n | STATE | version | db_name Output captured in log_file | ||
27 |
if any STATE entry is not DOWN, perform the following steps.
| ||
28 |
Navigate to the NSP software directory. | ||
29 |
Enter the following: # dnf install nspos-*.rpm ↵ The dnf utility resolves any package dependencies, and displays the following prompt for each package: Total size: nn G Installed size: nn G Is this ok [y/d/N]: | ||
30 |
Enter y. The following and the installation status are displayed as each package is installed: Downloading Packages: Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction The package installation is complete when the following is displayed: Complete! | ||
Upgrade database | |||
31 |
Log in as the root user on an auxiliary database station. | ||
32 |
Open a console window. | ||
33 |
Enter the following: # cd /opt/nsp/nfmp/auxdb/install/bin ↵ | ||
34 |
Enter the following: # ./auxdbAdmin.sh upgrade tar_file ↵ where tar_file is the absolute path and filename of the vertica-R.r.p-rel.tar file in the NSP software directory The following prompt is displayed: Updating Vertica - Please perform a backup before proceeding with this option Do you want to proceed (YES/NO)? | ||
35 |
Enter YES ↵. The following prompt is displayed: Please enter auxiliary database dba password [if you are doing initial setup for auxiliary database, press enter]: | ||
36 |
Enter the dba password. The following prompt is displayed: Please verify auxiliary database dba password: | ||
37 |
Enter the dba password again. The upgrade begins, and operational messages are displayed. The upgrade is complete when the following is displayed: Database database_name started successfully Output captured in log_file | ||
38 |
Enter the following to display the auxiliary database status: # ./auxdbAdmin.sh status ↵ Information like the following is displayed: Database status Node | Host | State | Version | DB ------------+---------------+-------+---------+------- node_1 | internal_IP_1 | STATE | version | db_name node_2 | internal_IP_2 | STATE | version | db_name . . . node_n | internal_IP_n | STATE | version | db_name Output captured in log_file The cluster is running when each STATE entry reads UP. | ||
39 |
Repeat Step 38 periodically until the cluster is running. Note: You must not proceed to the next step until the cluster is running. | ||
Update database schema | |||
40 |
If the NSP deployment includes the NFM-P, update the NFM-P database schema. Note: The schema update may take considerable time.
| ||
Configure TLS | |||
41 |
Open the /opt/nsp/nfmp/auxdb/install/config/install.config file using a plain-text editor such as vi. | ||
42 |
Edit the following lines in the file to read as shown below: secure=true pki_server=address pki_server_port=80 where address is one of the following in the platform—ingressApplications—ingressController section of the nsp-config.yml file on the local NSP deployer host: In the internalAddresses subsection, if configured, otherwise, in the clientAddresses subsection: | ||
43 |
Save and close the install.config file. | ||
Enable required database services and proxies | |||
44 |
Perform the following steps on each auxiliary database station.
| ||
45 |
Enter the following on each auxiliary database station: # systemctl start nspos-auxdbproxy.service ↵ The auxiliary database proxy starts. | ||
46 |
Close the open console windows. End of steps |