Re: Backup strategies in a multi DC cluster

2013-03-26 Thread Jabbar Azam
Thank you for your feedback. I'll speak to the dev guys and come up with something appropriate. On 26 Mar 2013 17:51, "aaron morton" wrote: > Assume you have four nodes and a snapshot is taken. The following day if > a node goes down and data is corrupt through user error then how do you use >

Re: Backup strategies in a multi DC cluster

2013-03-26 Thread aaron morton
> Assume you have four nodes and a snapshot is taken. The following day if a > node goes down and data is corrupt through user error then how do you use the > previouus nights snapshots? > Not sure what is corrupt, the snapshot/backup or the data is incorrect through application error. >

Re: Backup strategies in a multi DC cluster

2013-03-24 Thread Jabbar Azam
Thanks Aaron. I have a hypothetical question. Assume you have four nodes and a snapshot is taken. The following day if a node goes down and data is corrupt through user error then how do you use the previouus nights snapshots? Would you replace the faulty node first and then restore last nights

Re: Backup strategies in a multi DC cluster

2013-03-24 Thread aaron morton
> There are advantages and disadvantages in both approaches. What are people > doing in their production systems? Generally a mix of snapshots+rsync or https://github.com/synack/tablesnap to get things off node. Cheers - Aaron Morton Freelance Cassandra Consultant New Zealand

Backup strategies in a multi DC cluster

2013-03-22 Thread Jabbar Azam
Hello, I've been experimenting with cassandra for quite a while now. It's time for me to look at backups but I'm not sure what the best practice is. I want to be able to recover the data to a point in time before any user or software errors. We will have two datacentres with 4 servers and RF=3.