Re: Need a little help with data model design

2010-07-05 Thread Jonathan Ellis
i would expect row per log entry will be substantially faster to query. 2010/7/5 Bartosz Kołodziej : > I have big and dynamic number of loggers. > According to this https://issues.apache.org/jira/browse/CASSANDRA-16 2GB > size limit is no longer an issue in 0.7 (btw mnesia has similar issue ;-) )

Re: Storing application logs into Cassandra / design question

2010-07-05 Thread yaw
Perfectly right Nick. So i suppose that If I want to keep RandomPartionner ( I understand this is the best for high volume applications), I could design database like this : A CF with key = UUID will contain log message details => allows me to split real data evenly between nodes A CF with key

Re: Need a little help with data model design

2010-07-05 Thread Bartosz Kołodziej
I have big and dynamic number of loggers. According to this https://issues.apache.org/jira/browse/CASSANDRA-16 2GB size limit is no longer an issue in 0.7 (btw mnesia has similar issue ;-) ) I think I can go with svn release at the moment. Solving this by composite key (logger+timestamp) would re

Re: tool modeling data of cassandra

2010-07-05 Thread Jonathan Ellis
No. The right approach with cassandra is to model your queries, rather than your relationships. On Sun, Jul 4, 2010 at 5:55 PM, StiPh wrote: > > Can you please tell whether there is a cassandra tool modeling data, which > provides a standard way to define the data and relations between them, > s

Re: Need a little help with data model design

2010-07-05 Thread Jonathan Ellis
You don't want to have all the data from a single logger in a single row b/c of the 2GB size limit. If you have a small, static number of loggers you could create one CF per logger and use timestamp as the row key. Otherwise use a composite key (logger+timestamp) as the key in a single CF. 2010/

Re: Digg 4 Preview on TWiT

2010-07-05 Thread Eric Evans
On Sun, 2010-07-04 at 13:14 +0100, Bill de hÓra wrote: > This person's understanding is that Facebook 'no longer contributes to > nor uses Cassandra.': > > http://redmonk.com/sogrady/2010/05/17/beyond-cassandra/ Last I heard, Facebook was still using Cassandra for what they had always used it for

Re: Running Cassandra as a Windows Service

2010-07-05 Thread Jonathan Ellis
If you'd like to get it included in the Cassandra tree, submitting it to https://issues.apache.org/jira/browse/CASSANDRA-292 would be a good start. On Sun, Jul 4, 2010 at 2:54 PM, Kochheiser,Todd W - TOK-DITT-1 wrote: > Apache’s Procrun is a “real windows service” similar to the one from Tanuki >