Is this backup stategy okay?

Moderator: NorbertKrupa

Post Reply
sarah
Intermediate
Intermediate
Posts: 77
Joined: Mon Aug 27, 2012 1:34 pm

Is this backup stategy okay?

Post by sarah » Thu Aug 29, 2013 9:18 pm

Hello,

I have a three node cluster. I want to take full database and object level backups daily. I don't have any where else to put the backup files other than on the nodes themselves. :roll:

Will the following strategy be ok?

On node 1, run vbr.py scripts to do full backup and schema level backup of node 1, 2 and 3 to local storage on node 1
On node 2, run vbr.py scripts to do full backup and schema level backup of node 1, 2 and 3 to local storage on node 2
On node 3, run vbr.py scripts to do full backup and schema level backup of node 1, 2 and 3 to local storage on node 3

I figure by doing that I will have three copies of the backups.

Question: If my node 1 does fail, and I have to install a new node 1 to replace the failed node, will I be able to restore it from either the full backup on node 2 or the full backup on node 3?

Thanks in advance for help on this!!!
Have a GREAT day!

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Is this backup stategy okay?

Post by id10t » Fri Aug 30, 2013 9:01 am

HI!

>> If my node 1 does fail, and I have to install a new node 1 to replace the failed node, will I be able to restore it from either the full backup on node 2 or the full backup on node 3?
Yes (full and object-level MUST be in same location!)
BTW: you can restore it without a backup of failed node (3 nodes => K-SAFETY 1, so 1 node can fail). Vertica knows how to re-balance data in case of new node added.

Other strategy - backup with shifting(offset):
---
* node1 do backup to node2
* node2 do backup to node3
* node3 do backup to node1
---
This method very similar to Vertica HA approach - K-SAFETY

sarah
Intermediate
Intermediate
Posts: 77
Joined: Mon Aug 27, 2012 1:34 pm

Re: Is this backup stategy okay?

Post by sarah » Fri Aug 30, 2013 1:41 pm

sKwa, Thanks! I love your suggestion! I will implement your solution :D :D :D
Have a GREAT day!

harryrundles
Intermediate
Intermediate
Posts: 96
Joined: Thu Jul 19, 2012 12:33 am

Re: Is this backup stategy okay?

Post by harryrundles » Fri Aug 30, 2013 2:46 pm

What happens if two of the nodes fail? Won't you loose everything, Sarah?
Thanks,
Harry

Post Reply

Return to “Vertica Backup & Recovery”