Re: Medusa : a new OSS backup/restore tool for Apache Cassandra

2019-11-07 Thread Léo FERLIN SUTTON
Seems great ! Thank you :) We had tried https://github.com/GoogleCloudPlatform/cassandra-cloud-backup but it was not satisfying, looking forward to try medusa ! On Thu, Nov 7, 2019 at 4:35 PM Ahmed Eljami wrote: > Thanks for open-sourcing your work, TLP&Spotify ! > > cassandra-reaper and now Me

Re: Medusa : a new OSS backup/restore tool for Apache Cassandra

2019-11-07 Thread Ahmed Eljami
Thanks for open-sourcing your work, TLP&Spotify ! cassandra-reaper and now Medusa, you are doing an excellent job for the community. Le mer. 6 nov. 2019 à 17:46, Alexander Dejanovski a écrit : > Hi folks, > > I'm happy to announce that Spotify and TLP have been collaborating to > create and

Medusa : a new OSS backup/restore tool for Apache Cassandra

2019-11-06 Thread Alexander Dejanovski
Hi folks, I'm happy to announce that Spotify and TLP have been collaborating to create and open source a new backup and restore tool for Apache Cassandra : https://github.com/spotify/cassandra-medusa It is released under the Apache 2.0 license. It can perform full and differential backups, in pla

Re: Backup Restore

2019-04-30 Thread Ivan Junckes Filho
Thanks guys! On Fri, Apr 26, 2019 at 1:17 PM Alain RODRIGUEZ wrote: > Hello Ivan, > > Is there a way I can do one command to backup and one to restore a backup? > > > > Handling backups and restore automatically is not an easy task to work on. > It's not straight forward. But it's doable and som

Re: Backup Restore

2019-04-26 Thread Alain RODRIGUEZ
Hello Ivan, Is there a way I can do one command to backup and one to restore a backup? Handling backups and restore automatically is not an easy task to work on. It's not straight forward. But it's doable and some did some tools (with both open source and commercial licences) do this process (o

Re: Backup Restore

2019-04-25 Thread Naman Gupta
You should take a look into ssTableLoader cassandra utility, https://docs.datastax.com/en/cassandra/3.0/cassandra/tools/toolsBulkloader.html On Fri, Apr 26, 2019 at 1:33 AM Ivan Junckes Filho wrote: > Hi guys, > > I am trying do a bakup and restore script in a simple way. Is there a way > I can

Backup Restore

2019-04-25 Thread Ivan Junckes Filho
Hi guys, I am trying do a bakup and restore script in a simple way. Is there a way I can do one command to backup and one to restore a backup? Or the only way is to create snapshots of all the tables and then restore one by one?

Backup & Restore w/ AWS Blog Post

2018-04-03 Thread Jon Haddad
Hey folks. We (The Last Pickle) have helped a number of clients set up backup & restore on AWS over the last couple of years. Alain has been working on a thorough blog post over the last several months to try to document pros, cons and techniques. Hopefully it proves to be helpful to

Re: backup/restore cassandra data

2018-03-08 Thread Dipan Shah
schema. Thanks, Dipan Shah From: onmstester onmstester Sent: Thursday, March 8, 2018 1:31 PM To: user Subject: Re: backup/restore cassandra data Thanks But is'nt there a method to restore the node as it was before the crash, like commitlog and every last

Re: backup/restore cassandra data

2018-03-08 Thread onmstester onmstester
Thanks But is'nt there a method to restore the node as it was before the crash, like commitlog and every last data inserted? How often snapshots would be created? Shouldn't they be created manually by nodetool? I haven't created snapshots on the node! Sent using Zoho Mail On Thu,

Re: backup/restore cassandra data

2018-03-07 Thread Ben Slater
You should be able to follow the same approach(s) as restoring from a backup as outlined here: https://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_backup_snapshot_restore_t.html#ops_backup_snapshot_restore_t Cheers Ben On Thu, 8 Mar 2018 at 17:07 onmstester onmstester wrote: > W

backup/restore cassandra data

2018-03-07 Thread onmstester onmstester
Would it be possible to copy/paste Cassandra data directory from one of nodes (which Its OS partition corrupted) and use it in a fresh Cassandra node? I've used rf=1 so that's my only chance! Sent using Zoho Mail

RE: AWS Cassandra backup/Restore tools

2017-09-12 Thread Durity, Sean R
Datos IO has a backup/restore product for Cassandra that another team here has used successfully. It solves many of the problems inherent with sstable captures. Without something like it, restores are a nightmare with any volume of data. The downtime required and the loss of data since the

Re: AWS Cassandra backup/Restore tools

2017-05-12 Thread Alexander Dejanovski
n Thu, May 11, 2017 at 1:54 PM, Nitan Kainth wrote: > >> Also , Opscenter backup/restore does not work for large databases >> >> Sent from my iPhone >> >> On May 11, 2017, at 3:41 PM, Blake Eggleston >> wrote: >> >> OpsCenter 6.0 and up don't work

Re: AWS Cassandra backup/Restore tools

2017-05-11 Thread Manikandan Srinivasan
know more about these improvements, please send me an email directly: msriniva...@datastax.com Regards Mani On Thu, May 11, 2017 at 1:54 PM, Nitan Kainth wrote: > Also , Opscenter backup/restore does not work for large databases > > Sent from my iPhone > > On May 11, 2017, at 3:41

Re: AWS Cassandra backup/Restore tools

2017-05-11 Thread Nitan Kainth
Also , Opscenter backup/restore does not work for large databases Sent from my iPhone > On May 11, 2017, at 3:41 PM, Blake Eggleston wrote: > > OpsCenter 6.0 and up don't work with Cassandra. > >> On May 11, 2017 at 12:31:08 PM, cass savy (casss...@gmail.com) wrote: &g

Re: AWS Cassandra backup/Restore tools

2017-05-11 Thread Blake Eggleston
OpsCenter 6.0 and up don't work with Cassandra. On May 11, 2017 at 12:31:08 PM, cass savy (casss...@gmail.com) wrote: AWS Backup/Restore process/tools for C*/DSE C*: Has anyone used Opscenter 6.1 backup tool to backup/restore data for larger datasets online ? If yes, did you run into i

AWS Cassandra backup/Restore tools

2017-05-11 Thread cass savy
AWS Backup/Restore process/tools for C*/DSE C*: Has anyone used Opscenter 6.1 backup tool to backup/restore data for larger datasets online ? If yes, did you run into issues using that tool to backup/restore data in PROD that caused any performance or any other impact to the cluster? If no

RE: Backup restore with a different name

2016-11-03 Thread Michael Laws
the same or a different cluster, etc. Might be useful… https://github.com/AppliedInfrastructure/cassandra-snapshot-tools Mike *From:* Jens Rantil [mailto:jens.ran...@tink.se] *Sent:* Wednesday, November 2, 2016 2:21 PM *To:* Cassandra Group *Subject:* Backup restore with a different name Hi

Re: Backup restore with a different name

2016-11-03 Thread kurt Greaves
On 2 November 2016 at 22:10, Jens Rantil wrote: > I mean "exposing that state for reference while keeping the (corrupt) > current state in the live cluster". The following should work: 1. Create a new table with the same schema but different name (in the same or a different keyspace).

Re: Backup restore with a different name

2016-11-03 Thread Rajath Subramanyam
Hi Jens, Looks like what you need is an "any point in time" recovery solution. I suggest that you go back to the snapshot that you issued that was closest to "20161102" and restore that snapshot using the bulk loader to a new table called "users_20161102". If you need to recover precisely to a par

Re: Backup restore with a different name

2016-11-02 Thread Jens Rantil
Bryan, On Wed, Nov 2, 2016 at 11:38 AM, Bryan Cheng wrote: > do you mean restoring the cluster to that state, or just exposing that > state for reference while keeping the (corrupt) current state in the live > cluster? I mean "exposing that state for reference while keeping the (corrupt) curre

Re: Backup restore with a different name

2016-11-02 Thread Jens Rantil
re is an option: https://github.com/anubhavkale/CassandraTools/ > tree/master/BackupRestore > > > > > > *From:* Jens Rantil [mailto:jens.ran...@tink.se] > *Sent:* Wednesday, November 2, 2016 2:21 PM > *To:* Cassandra Group > *Subject:* Backup restore with a different name &g

Re: Backup restore with a different name

2016-11-02 Thread Bryan Cheng
Hi Jens, When you refer to restoring a snapshot for a developer to look at, do you mean restoring the cluster to that state, or just exposing that state for reference while keeping the (corrupt) current state in the live cluster? You may find these useful: https://docs.datastax.com/en/cassandra/2

RE: Backup restore with a different name

2016-11-02 Thread Anubhav Kale
You would have to build some logic on top of what’s natively supported. Here is an option: https://github.com/anubhavkale/CassandraTools/tree/master/BackupRestore From: Jens Rantil [mailto:jens.ran...@tink.se] Sent: Wednesday, November 2, 2016 2:21 PM To: Cassandra Group Subject: Backup

Backup restore with a different name

2016-11-02 Thread Jens Rantil
Hi, Let's say I am periodically making snapshots of a table, say "users", for backup purposes. Let's say a developer makes a mistake and corrupts the table. Is there an easy way for me to restore a replica, say "users_20161102", of the original table for the developer to looks at the old copy? Ch

Re: Snapshots - Backup/Restore requirements

2015-10-12 Thread Robert Coli
On Mon, Oct 12, 2015 at 3:28 PM, Jeff Ferland wrote: > Yeah, that’s got plenty of promise looking at it the 2nd time around. What > turned me off from using it was the combination of not having a single-shot > backup mode and appearing to only run in inotify mode which would just > chuck in every

Re: Snapshots - Backup/Restore requirements

2015-10-12 Thread Jeff Ferland
Yeah, that’s got plenty of promise looking at it the 2nd time around. What turned me off from using it was the combination of not having a single-shot backup mode and appearing to only run in inotify mode which would just chuck in every compaction. It looks like when reading it through its sour

Re: Snapshots - Backup/Restore requirements

2015-10-12 Thread Robert Coli
On Mon, Oct 12, 2015 at 9:41 AM, Jeff Ferland wrote: > I have a semi-hacky Python script I’ve written up. It needs refining for > public use, but I’ll put it in Github later today and send you a link as I > work on it. It uses boto to do concurrent multi-part uploads to S3 with > retry and resume

Re: Snapshots - Backup/Restore requirements

2015-10-12 Thread Jeff Ferland
isk from the last snapshot. In case of disaster with a cluster size change, I’d use sstableloader. -Jeff > On Oct 12, 2015, at 8:52 AM, Jason Turner wrote: > > We have recently created production ready Cassandra clusters and we are > currently trying to create and implement a robus

Snapshots - Backup/Restore requirements

2015-10-12 Thread Jason Turner
We have recently created production ready Cassandra clusters and we are currently trying to create and implement a robust Backup/Restore process. We are hosting our Cassandra VMs in AWS and we understand the Snapshot process, but we are unclear on the best way to get Snapshots backed up off the

RE: Backup/Restore in Cassandra

2014-03-07 Thread java8964
Hi, Jonathan: Thanks for your answer. My original goal of this question is not really related to backup/restore, but to see if we can skip the Full Snapshot during ETL transferring the data from SSTable files of Cassandra into another Hadoop Cluster. Right now, our production generates a full

Re: Backup/Restore in Cassandra

2014-03-07 Thread Jonathan Lacefield
Hello, Full snapshot forces a flush, yes. Incremental hard-links to SSTables, yes. This question really depends on how your cluster was "lost". Node Loss: You would be able to restore a node based on restoring backups + commit log or just by using repair. Cluster Loss: (all nod

Backup/Restore in Cassandra

2014-03-06 Thread java8964
Hi, Currently I am looking how the bacup/restore be done in Cassandra, based the document from DataStax: http://www.datastax.com/docs/1.1/backup_restore Here is one way to do it: 1) Do a full snapshot every week2) Enable incremental backup every day So with last snapshot + the incremental backup

Re: CF backup / restore selected columns

2013-11-12 Thread Tyler Hobbs
GE) < ferenc.t...@ge.com> wrote: > Hi, > > > > I have a question which I was not able to find the right answer for. > > What is the best way to backup/restore a set of columns? > > Let’s say we have: > > > > CF1(a,b,c,d) – a,b,c,d are columns/ original CF w

CF backup / restore selected columns

2013-11-11 Thread Turi, Ferenc (GE Power & Water, Non-GE)
Hi, I have a question which I was not able to find the right answer for. What is the best way to backup/restore a set of columns? Let's say we have: CF1(a,b,c,d) - a,b,c,d are columns/ original CF we would like to take backup from CF2(d,e,f,g) - e,f,g are different columns, we would re

Re: backup/restore from sstable files ?

2012-11-12 Thread Rob Coli
On Sat, Nov 10, 2012 at 3:00 PM, Tyler Hobbs wrote: > For an alternative that doesn't require the same ring topology, you can use > the bulkloader, which will take care of distributing the data to the correct > nodes automatically. For more details on which cases are best for the different bulk l

Re: backup/restore from sstable files ?

2012-11-10 Thread Tyler Hobbs
On Fri, Nov 9, 2012 at 6:04 PM, Rob Coli wrote: > > > some of my colleagues seem to use this method to backup/restore a > cluster, > > successfully: > > > >> on each of the node, save entire /cassandra/data/ dir to S3, > > then on a new set of nodes, with

Re: backup/restore from sstable files ?

2012-11-09 Thread Rob Coli
On Thu, Nov 8, 2012 at 5:15 PM, Yang wrote: > some of my colleagues seem to use this method to backup/restore a cluster, > successfully: > >> on each of the node, save entire /cassandra/data/ dir to S3, > then on a new set of nodes, with exactly the same number of nodes, copy

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-23 Thread Peter Schuller
> that with storage, there are *lots* of urban legends and people making > strange claims. In this case it is wrong for fundamental reasons > independent of kernel implementation details. Also, note that it is not specific to log based file systems. Even "old" file systems the predates journaling

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-23 Thread Peter Schuller
> A snippet from the wikipedia page on XFS for example: > http://en.wikipedia.org/wiki/XFS > ... > > Snapshots > > XFS does not provide direct support for snapshots, as it expects the > snapshot process to be implemented by the volume manager. Taking a snapshot > of an XFS filesystem involves freez

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-23 Thread Josep Blanquer
On Thu, Jun 23, 2011 at 8:54 AM, Peter Schuller wrote: > > Actually, I'm afraid that's not true (unless I'm missing something). Even > if > > you have only 1 drive, you still need to stop writes to the disk for the > > short time it takes the low level "drivers" to snapshot it (i.e., marking > >

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-23 Thread Peter Schuller
> If taking an atomic snapshot of the device on which a file system is > located on, assuming the file system is designed to be crash > consistent, it *has* to result in a consistent snapshot. Anything else > would directly violate the claim that the file system is crash > consistent, making the pr

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-23 Thread Peter Schuller
> Actually, I'm afraid that's not true (unless I'm missing something). Even if > you have only 1 drive, you still need to stop writes to the disk for the > short time it takes the low level "drivers" to snapshot it (i.e., marking > all blocks as clean so you can do CopyOnWrite later). I.e., you nee

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-23 Thread Josep Blanquer
On Thu, Jun 23, 2011 at 8:02 AM, William Oberman wrote: > I've been doing EBS snapshots for mysql for some time now, and was using a > similar pattern as Josep (XFS with freeze, snap, unfreeze), with the extra > complication that I was actually using 8 EBS's in RAID-0 (and the extra > extra compli

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-23 Thread Josep Blanquer
On Thu, Jun 23, 2011 at 7:30 AM, Peter Schuller wrote: > > EBS volume atomicity is good. We've had tons of experience since EBS came > > out almost 4 years ago, to back all kinds of things, including large > DBs. > > One important thing to have in mind though, is that EBS snapshots are > done >

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-23 Thread William Oberman
I've been doing EBS snapshots for mysql for some time now, and was using a similar pattern as Josep (XFS with freeze, snap, unfreeze), with the extra complication that I was actually using 8 EBS's in RAID-0 (and the extra extra complication that I had to lock the MyISAM tables... glad to be moving

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-23 Thread Peter Schuller
>> EBS volume atomicity is good. We've had tons of experience since EBS came >> out almost 4 years ago,  to back all kinds of things, including large DBs. And thanks a lot for coming forward with production experience. That is always useful with these things. -- / Peter Schuller

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-23 Thread Peter Schuller
> EBS volume atomicity is good. We've had tons of experience since EBS came > out almost 4 years ago,  to back all kinds of things, including large DBs. > One important thing to have in mind though, is that EBS snapshots are done > at the block level, not at the filesystem level. So depending on th

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-23 Thread Josep Blanquer
On Thu, Jun 23, 2011 at 5:04 AM, Peter Schuller wrote: > > 1. Is it feasible to run directly against a Cassandra data directory > > restored from an EBS snapshot? (as opposed to nodetool snapshots restored > > from an EBS snapshot). > > Assuming EBS is not buggy, including honor write barriers, i

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-23 Thread Peter Schuller
> 1. Is it feasible to run directly against a Cassandra data directory > restored from an EBS snapshot? (as opposed to nodetool snapshots restored > from an EBS snapshot). Assuming EBS is not buggy, including honor write barriers, including the linux guest kernel etc, then yes. EBS snapshots of a

Re: Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-22 Thread aaron morton
elastpickle.com On 23 Jun 2011, at 10:48, Thoku Hansen wrote: > I have a couple of questions regarding the coordination of Cassandra nodetool > snapshots with Amazon EBS snapshots as part of a Cassandra backup/restore > strategy. > > Background: I have a cluster running in EC2. It

Backup/Restore: Coordinating Cassandra Nodetool Snapshots with Amazon EBS Snapshots?

2011-06-22 Thread Thoku Hansen
I have a couple of questions regarding the coordination of Cassandra nodetool snapshots with Amazon EBS snapshots as part of a Cassandra backup/restore strategy. Background: I have a cluster running in EC2. Its nodes are configured like so: * Instance type: m1.xlarge * Cassandra commit log