Skip to main content
Question

Can I configure DR with single new node?

  • October 27, 2020
  • 1 reply
  • 4 views

sameeraw

We are using Vertica 3 node cluster in production. Now we have a requirement to implement DR. Our Vertica version is vsql version 09.02.0108, built for Linux64, contains support for command-line editing
Can I configure DR with single new node? If yes can you share supportive documents/URLs?
Thx,
Sameera Wijeweera

1 reply

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • October 28, 2020

Here is a link to the the Best Practices for Disaster Recovery doc page for Vertica 9.0.x:
https://www.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AdministratorsGuide/Recovery/BestPracticesForDisasterRecovery.htm

If you stand up a single node for DR you'll have to mamually copy/load data onto it as replication and back up /restore won't work because you have to have the same number of nodes.

Replicating Tables and Schemas to an Alternate Database
https://www.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/ReplicatingtoanAlternateCluster.htm

Creating Full Backups
https://www.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/CreatingFullAndIncrementalBackups.htm

Restoring Full Database Backups
https://www.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/RestoringFullDatabaseBackups.htm

You can use Vertica's IMPORT/EXPORT functionality to copy the data from the 3 node DB to the 1 node DB:

Importing and Exporting Data Across Databases
https://www.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AdministratorsGuide/CopyExportData/CopyingAndExportingData.htm

P.S. You might want to plan to upgrade Vertica in the near future :)

Newer features you are missing out on:
https://www.vertica.com/docs/9.1.x/HTML/Content/Authoring/NewFeatures/_VersionIndependent/NewFeatures.htm
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/NewFeatures/_VersionIndependent/NewFeatures.htm
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/NewFeatures/_VersionIndependent/NewFeatures.htm
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/NewFeatures/_VersionIndependent/NewFeatures.htm