Best strategy for OS upgradation?
SK21
Vertica Customer ✭
We want to upgrade OS of our 24 node cluster by replicating it to different servers with robust disks updated OS.
Os team suggested since the new disks are much robust then the current ones , so we should replicate this 24 node cluster to a 15 node cluster. We have around 10k objects and 20 TB data to replicate.
What can be the best strategy to follow from docs?
0
Best Answers
-
SK21
Vertica Customer ✭
Yeah @Nimmi_gupta saw that one earlier.....i guess it not that handy when replicating 10K plus tables.....I mean export...import
0 -
Nimmi_gupta
- Select Field - Employee
In that case only option would be remove the node from 24 node cluster and bring it down to 15 and do the copycluster.
1
Answers
Your question is how to remove some of the nodes from the existing cluster right?
Check the below document link and hope this will help.
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/ManageNodes/RemovingNodesFromADatabase.htm
@Nimmi_gupta that can be one of the way removing 9 nodes from existing cluster(24 nodes) and use copy cluster between similar cluster to replicate data in new 15 node cluster with updated os and robust disks.
I was wondering any other alternative without removing nodes migrate all the 20 tb data (10k+ tables) to new 15 node cluster.
Copying data between two cluster with different number of nodes, check the below link
http://vertica.com/kb/Copying-Data-Between-Dissimilar-Vertica-Clusters/Content/BestPractices/Copying-Data-Between-Dissimilar-Vertica-Clusters.htm
Thanks @Nimmi_gupta
@SK21, If the source Enterprise database version is 10.0 or above,
And the amount of RAM and CPU power on the 24 nodes is equal or above the new 15 nodes,
Then another option one may consider is to use the nodes with large storage to play as MinIO (S3) communal storage
and migrates the Enterprise database to Eon Mode via the meta-function MIGRATE_ENTERPRISE_TO_EON
Advantages: