Skip to main content
Question

Conflicting vertica doc advice on upgrading OS versions

  • May 13, 2024
  • 2 replies
  • 6 views

dgrumann
Forum|alt.badge.img+2

This page https://docs.vertica.com/12.0.x/en/supported-platforms/server-and-mc/ has a VERY clear warning "Vertica does not support or recommend in-place upgrades from one major version to another major version. For example, you cannot perform in-place upgrades from RHEL/CentOS 7.x to RHEL/CentOS 8.x." but then there is a reference to https://www.vertica.com/kb/UpgradingtheOperatingSystem/Content/BestPractices/UpdateOSinVerticaCluster.htm.
This article specifically recommends in-place upgrades! It says "Upgrade the operating system on all nodes." So far as I can tell, this article was published years ago for vertica 8, and it mentions a vertica.local_verify step which fails as it no longer exists.

So there is a conflict in our docs.

I tested internally upgrading the underlying Linux OS on a Vertica 12 3-node cluster by simply replacing the CentOS 7.9 nodes one at a time with fresh RHEL 8.9 nodes following https://docs.vertica.com/12.0.x/en/admin/managing-db/managing-nodes/replacing-nodes (https://docs.vertica.com/12.0.x/en/admin/managing-db/managing-nodes/replacing-nodes/replacing-host-using-same-name-and-ip-address/). This worked great for me.

The question for Vertica experts is this: Why NOT upgrade a k-safe cluster by replacing each node live using what seems to be simpler and more modern instructions at https://docs.vertica.com/12.0.x/en/admin/managing-db/managing-nodes/replacing-nodes/replacing-host-using-same-name-and-ip-address ? The replacement process works - the node recovers and the cluster stays up - so no need for formal downtime. Should you replace the clearly outdated https://www.vertica.com/kb/UpgradingtheOperatingSystem/Content/BestPractices/UpdateOSinVerticaCluster.htm article with new advice?

2 replies

dgrumann
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • May 14, 2024

Thank you Hibiki you seem to be agreeing with me that the old article https://forum.vertica.com/home/leaving?allowTrusted=1&target=https://www.vertica.com/kb/UpgradingtheOperatingSystem/Content/BestPractices/UpdateOSinVerticaCluster.htm has BAD advice and the new doc page https://docs.vertica.com/12.0.x/en/admin/managing-db/managing-nodes/replacing-nodes/replacing-host-using-same-name-and-ip-address is what our customers should be doing. Can you please confirm? This conflict really needs correcting IN the customer documentation (is R&D listening?)


dgrumann
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • May 16, 2024

OK so when we talk to our ITOM customers we will tell them to ignore the old/bad article advice.
For single-node Verticas (versions 11 and 12 currently), we will ask them to take a backup (say, to a file on a different host), then delete the Linux 7 VM, install a new fresh Linux 8 VM, then install Vertica 24.1 (what the ITOM 24.2 releases supports) using the same directory names and admin credentials, and then they should be able to restore their DB on the new host.
For multi-node Verticas, we will tell them to follow the "node replacement" doc page reference above, replacing old Linux 7 node with a fresh Linux 8 node, done one at a time for each of their clusters nodes and wait for each to fully recover before moving to the next.
Everyone reading this OK with the process?