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 A07F3D9D7 for ; Mon, 13 Aug 2012 05:16:00 +0000 (UTC) Received: (qmail 85486 invoked by uid 500); 13 Aug 2012 05:15:58 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 84913 invoked by uid 500); 13 Aug 2012 05:15:51 -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 84884 invoked by uid 99); 13 Aug 2012 05:15:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Aug 2012 05:15:50 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [195.4.92.90] (HELO mout0.freenet.de) (195.4.92.90) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Aug 2012 05:15:42 +0000 Received: from [195.4.92.142] (helo=mjail2.freenet.de) by mout0.freenet.de with esmtpa (ID oliver@objectscape.org) (port 25) (Exim 4.76 #1) id 1T0mzo-0003u6-KV for user@cassandra.apache.org; Mon, 13 Aug 2012 07:15:20 +0200 Received: from localhost ([::1]:50173 helo=mjail2.freenet.de) by mjail2.freenet.de with esmtpa (ID oliver@objectscape.org) (Exim 4.76 #1) id 1T0mzo-0002FC-EL for user@cassandra.apache.org; Mon, 13 Aug 2012 07:15:20 +0200 Received: from [195.4.92.21] (port=39874 helo=11.mx.freenet.de) by mjail2.freenet.de with esmtpa (ID oliver@objectscape.org) (Exim 4.76 #1) id 1T0mxH-0001yp-PT for user@cassandra.apache.org; Mon, 13 Aug 2012 07:12:43 +0200 Received: from frnk-4d01ee7b.pool.mediaways.net ([77.1.238.123]:50442 helo=[192.168.1.100]) by 11.mx.freenet.de with esmtpa (ID oliver@objectscape.org) (port 25) (Exim 4.76 #1) id 1T0mxH-0003wJ-Fc for user@cassandra.apache.org; Mon, 13 Aug 2012 07:12:43 +0200 References: <502802FB.60301@objectscape.org> <5028065E.8020906@mebigfatguy.com> In-Reply-To: <5028065E.8020906@mebigfatguy.com> Mime-Version: 1.0 (1.0) Content-Transfer-Encoding: 7bit Content-Type: multipart/alternative; boundary=Apple-Mail-C4C09396-E91D-4700-9291-802703E83F36 Message-Id: <95DE6F36-9AB2-4AC4-B742-FFEC07421587@objectscape.org> Cc: "user@cassandra.apache.org" X-Mailer: iPad Mail (9B206) From: Oliver Plohmann Subject: Re: Loading data on-demand in Cassandra Date: Mon, 13 Aug 2012 07:12:40 +0200 To: "user@cassandra.apache.org" X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-C4C09396-E91D-4700-9291-802703E83F36 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Thanks Dave. Does anybody know of a distributed in-memory system that can do= this and that supports structured data (e.g. tables)?=20 /Oliver Am 12.08.2012 um 21:39 schrieb Dave Brosius : > When data is first written it does remain in memory until that memory is f= lushed. After the data is only on disk, it remains there until a read for th= at row-key/column is requested so in essense it's always load on demand.= >=20 > Currently there is no support for async notifications of changes. >=20 >=20 >=20 > On 08/12/2012 03:24 PM, Oliver Plohmann wrote: >>=20 >> Hello, >>=20 >> I'm looking a bit into Cassandra to see whether it would be something to g= o with for my company. I searched through the Internet, looked through the FA= Qs, etc. but there are still some few open questions. Hope I don't bother an= ybody with the usual beginner questions ... >>=20 >> Is there a way to do load-on-demand of data in Cassandra? For the time be= ing, we cannot afford to built up a cluster that holds our 700 GB SQL-Databa= se in RAM. So we need to be able to load data on-demand from our relational d= atabase. Can this be done in Cassandra? Then there also needs to be a way to= unload data in order to reclaim RAM space. Would be nice if it were possibl= e to register for an asynchronous notification in case some value was change= d. Can this be done? >>=20 >> Thanks for any answers. >> Regards, Oliver >>=20 >=20 --Apple-Mail-C4C09396-E91D-4700-9291-802703E83F36 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=utf-8
Thanks Dave. Does anybody know of a distributed in-memory system that can do this and that supports structured data (e.g. tables)? 

/Oliver

Am 12.08.2012 um 21:39 schrieb Dave Brosius <dbrosius@mebigfatguy.com>:

When data is first written it does remain in memory until that memory is flushed. After the data is only on disk, it remains there until a read for that row-key/column is requested so in essense it's always load on demand.

Currently there is no support for async notifications of changes.



On 08/12/2012 03:24 PM, Oliver Plohmann wrote:

Hello,

I'm looking a bit into Cassandra to see whether it would be something to go with for my company. I searched through the Internet, looked through the FAQs, etc. but there are still some few open questions. Hope I don't bother anybody with the usual beginner questions ...

Is there a way to do load-on-demand of data in Cassandra? For the time being, we cannot afford to built up a cluster that holds our 700 GB SQL-Database in RAM. So we need to be able to load data on-demand from our relational database. Can this be done in Cassandra? Then there also needs to be a way to unload data in order to reclaim RAM space. Would be nice if it were possible to register for an asynchronous notification in case some value was changed. Can this be done?

Thanks for any answers.
Regards, Oliver


--Apple-Mail-C4C09396-E91D-4700-9291-802703E83F36--