Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4E1B5EF69 for ; Tue, 19 Feb 2013 02:27:10 +0000 (UTC) Received: (qmail 91343 invoked by uid 500); 19 Feb 2013 02:27:07 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 91220 invoked by uid 500); 19 Feb 2013 02:27:07 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 91210 invoked by uid 99); 19 Feb 2013 02:27:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 19 Feb 2013 02:27:07 +0000 X-ASF-Spam-Status: No, hits=2.9 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [206.225.165.117] (HELO HUB024-nj-2.exch024.serverdata.net) (206.225.165.117) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 19 Feb 2013 02:27:02 +0000 Received: from MBX024-E1-NJ-6.exch024.domain.local ([10.240.10.56]) by HUB024-NJ-2.exch024.domain.local ([10.240.10.33]) with mapi id 14.02.0318.001; Mon, 18 Feb 2013 18:26:41 -0800 From: Kanwar Sangha To: "user@cassandra.apache.org" Subject: RE: Cassandra backup Thread-Topic: Cassandra backup Thread-Index: Ac4ORS9J1H5UmtvgRDyxA2HEOUGK4QAQ99kAABBDO/A= Date: Tue, 19 Feb 2013 02:26:40 +0000 Message-ID: <57C7C3CBDCB04F45A57AEC4CB21C0CCD1DB32694@mbx024-e1-nj-6.exch024.domain.local> References: <57C7C3CBDCB04F45A57AEC4CB21C0CCD1DB32676@mbx024-e1-nj-6.exch024.domain.local> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [76.184.245.196] Content-Type: multipart/alternative; boundary="_000_57C7C3CBDCB04F45A57AEC4CB21C0CCD1DB32694mbx024e1nj6exch_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_57C7C3CBDCB04F45A57AEC4CB21C0CCD1DB32694mbx024e1nj6exch_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Thanks. I will look into the details. One issue I see is that if I have only one column family which needs only t= he last 7 days data to be on SSD and the rest to be on the HDD, how will th= at work. From: Michael Kjellman [mailto:mkjellman@barracuda.com] Sent: 18 February 2013 20:08 To: user@cassandra.apache.org Subject: Re: Cassandra backup There is this: http://www.datastax.com/dev/blog/whats-new-in-cassandra-1-1-flexible-data-f= ile-placement But you'll need to design your data model around the fact that this is only= as granular as 1 column family Best, michael From: Kanwar Sangha > Reply-To: "user@cassandra.apache.org" > Date: Monday, February 18, 2013 6:06 PM To: "user@cassandra.apache.org" > Subject: Cassandra backup Hi - We have a req to store around 90 days of data per user. Last 7 days of= data is going to be accessed frequently. Is there a way we can have the re= cent data (7 days) in SSD and the rest of the data in the HDD ? Do we take a snapshot every 7 days and use a separate 'archive' clust= er to serve the old data and a 'active' cluster to serve recent data ? Any links/thoughts would be helpful. Thanks, Kanwar --_000_57C7C3CBDCB04F45A57AEC4CB21C0CCD1DB32694mbx024e1nj6exch_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Thanks. I will look in= to the details.

 

One issue I see is tha= t if I have only one column family which needs only the last 7 days data to= be on SSD and the rest to be on the HDD, how will that work.

 

From: Michael = Kjellman [mailto:mkjellman@barracuda.com]
Sent: 18 February 2013 20:08
To: user@cassandra.apache.org
Subject: Re: Cassandra backup

 

There i= s this:

&n= bsp;

&n= bsp;

But you= 'll need to design your data model around the fact that this is only as gra= nular as 1 column family

&n= bsp;

Best,

michael=

&n= bsp;

From: Kanwar Sangha <kanwar@mavenir.com>
Reply-To: "user@ca= ssandra.apache.org" <user@cassandra.apache.org>
Date: Monday, February 18, 2013 6:06 PM
To: "user@cassandr= a.apache.org" <use= r@cassandra.apache.org>
Subject: Cassandra backup

&n= bsp;

Hi –= ; We have a req to store around 90 days of data per user. Last 7 days of da= ta is going to be accessed frequently. Is there a way we can have the recen= t data (7 days) in SSD and the rest of the data in the

HDD ? Do = we take a snapshot every 7 days and use a separate ‘archive’ cl= uster to serve the old data and a ‘active’ cluster to serve rec= ent data ?

 

Any links= /thoughts would be helpful.

 

Thanks,

Kanwar

--_000_57C7C3CBDCB04F45A57AEC4CB21C0CCD1DB32694mbx024e1nj6exch_--