unsubscribe

[Sridhar Chellappa]

unsubscribe

Re: Backup strategy

[Sridhar Chellappa]

Yes. I am taking a Snapshot and then offloading the full data into S3.  How
will Table Snap help?


On Wed, Nov 6, 2013 at 6:57 AM, Robert Coli rc...@eventbrite.com wrote:

 On Tue, Nov 5, 2013 at 4:36 PM, Sridhar Chellappa 
 schellap2...@gmail.comwrote:


1. *If not, what is the right  backup strategy ?*

 You didn't specify, but it sounds like you are doing a snapshot and then
 a full offhost backup of the sstables?

 Perhaps instead of point in time full backups, you could continuously back
 up with something like tablesnap [1]? tablesnap watches the datadir for
 newly created SSTables and then writes the file and a manifest containing
 which other files were also in the directory at the time. These two pieces
 of information allow you to restore to the point in time when any given
 (immutable) data file was created.

 =Rob

 [1] https://github.com/synack/tablesnap

Backup strategy

[Sridhar Chellappa]

We are running into problems where Backup jobs are taking away a huge
bandwidth out of the C* nodes. While we can schedule a particular timing
window for backups alone, the request pattern is so random; there is no
particular time where we can schedule backups, periodically.

My current thinking is to run backups against a replica that does not serve
requests. Questions:


   1.
*Is it the right strategy? *
   2.
*if it is - how do I pull a replica out from serving requests ? *
   3. *If not, what is the right  backup strategy ?*

Cassandra Reads

[Sridhar Chellappa]

Folks,

When I read Column(s) from a table, does Cassandra read only that column?
Or, does it read the entire row into memory and then filters out the
contents to send only the requested column(s) ?