To upgrade a geo-redundant Release 22.9 or later auxiliary database
Description
The following procedure describes how to upgrade a geo-redundant NSP auxiliary database from Release 22.9 or later.
Note: You require the following user privileges on each auxiliary database 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: where R.r.p is the NSP release identifier, in the form MAJOR.minor.patch v is a version number | ||
2 |
For each auxiliary database cluster, transfer the downloaded files to a station that is reachable by each station in the cluster. | ||
Verify auxiliary database synchronization | |||
3 |
If you are upgrading the standby auxiliary database cluster, you must verify the success of the most recent copy-cluster operation, which synchronizes the database data between the clusters. Note: You must not proceed to the next step until the operation is complete and successful. Issue the following RESTCONF API call periodically to check the copy-cluster status: Note: In order to issue a RESTCONF API call, you require a token; see this tutorial on the Network Developer Portal for information. GET https://address/restconf/data/auxdb:/auxdb-agent where address is the advertised address of the primary NSP cluster The call returns a status of SUCCESS, as shown below, for a successfully completed copy-cluster operation: <HashMap> <auxdb-agent> <name>nspos-auxdb-agent</name> <application-mode>ACTIVE</application-mode> <copy-cluster> <source-cluster>cluster_M</source-cluster> <target-cluster>cluster_N</target-cluster> <time-started>timestamp</time-started> <status>SUCCESS</status> </copy-cluster> </auxdb-agent> </HashMap> | ||
Back up database | |||
4 |
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. If you are upgrading the standby cluster, 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 standby database proxies | |||
5 |
If you are upgrading the standby auxiliary database cluster, perform one of the following to stop the auxiliary database services:
| ||
Enable maintenance mode on auxiliary database agent | |||
6 |
If you are upgrading the standby auxiliary database cluster, enable nspos-auxdb-agent maintenance mode.
| ||
Stop standby auxiliary database services | |||
7 |
If you are upgrading the standby auxiliary database cluster, perform one of the following to disable the database services:
| ||
Stop database | |||
8 |
Log in as the root user on a station in the auxiliary database cluster that you are upgrading. | ||
9 |
Open a console window. | ||
10 |
Enter the following: # cd /opt/nsp/nfmp/auxdb/install/bin ↵ | ||
11 |
Enter the following to stop the auxiliary database: # ./auxdbAdmin.sh stop ↵ | ||
12 |
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. | ||
13 |
Repeat Step 12 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 | |||
14 |
Perform Step 16 to Step 33 on each station in the cluster that you are upgrading. | ||
15 |
Go to Step 34. | ||
Prepare individual station for upgrade | |||
16 |
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. | ||
17 |
Log in as the root user on the station. | ||
18 |
Open a console window. | ||
19 |
Perform one of the following to stop the auxiliary database services:
| ||
20 |
Perform one of the following to disable the database services:
| ||
21 |
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. | ||
22 |
Navigate to the NSP software directory. Note: The directory must contain only the installation files. | ||
23 |
Enter the following: # chmod +x * ↵ | ||
24 |
Enter the following: # ./VerticaSw_PreInstall.sh ↵ Information like the following is 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... | ||
25 |
Enter the following to reboot the station: # systemctl reboot ↵ The station reboots. | ||
26 |
When the reboot is complete, log in as the root user on the station. | ||
27 |
Open a console window. | ||
28 |
Enter the following: # cd /opt/nsp/nfmp/auxdb/install/bin ↵ | ||
29 |
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 | ||
30 |
if any STATE entry is not DOWN, perform the following steps.
| ||
31 |
Navigate to the NSP software directory. | ||
32 |
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]: | ||
33 |
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 | |||
34 |
Log in as the root user on a station in the auxiliary database cluster that you are upgrading. | ||
35 |
Open a console window. | ||
36 |
Enter the following: # cd /opt/nsp/nfmp/auxdb/install/bin ↵ | ||
37 |
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)? | ||
38 |
Enter YES ↵. The following prompt is displayed: Please enter auxiliary database dba password [if you are doing initial setup for auxiliary database, press enter]: | ||
39 |
Enter the dba password. The following prompt is displayed: Please verify auxiliary database dba password: | ||
40 |
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 | ||
41 |
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. | ||
42 |
Repeat Step 41 periodically until the cluster is running. Note: You must not proceed to the next step until the cluster is running. | ||
Update database schema | |||
43 |
Update the NFM-P database schema. Note: The schema update may take considerable time.
| ||
Configure TLS | |||
44 |
Open the /opt/nsp/nfmp/auxdb/install/config/install.config file using a plain-text editor such as vi. | ||
45 |
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: | ||
46 |
Save and close the install.config file. | ||
Enable required database services and proxies | |||
47 |
Perform the following steps on each station in the auxiliary database cluster.
| ||
48 |
If you are upgrading the primary auxiliary database cluster, enter the following on each station in the cluster: # systemctl start nspos-auxdbproxy.service ↵ The auxiliary database proxy starts. | ||
49 |
Close the open console windows. End of steps |