RE: Taking a Cluster Wide Snapshot

2012-04-25 Thread Shubham Srivastava
Thanks a Lot Deno. A bit surprised that the an equivalent command should be there with nodetool. Not sure if it is in the latest release. BTW this makes a prerequisite that all the Data files of Cassandra be it index or filters etc will have unique names across cluster. Is this a reasoanble as

Re: Taking a Cluster Wide Snapshot

2012-04-25 Thread Deno Vichas
On 4/25/2012 11:34 PM, Shubham Srivastava wrote: Whats the best way(or the only way) to take a cluster wide backup of Cassandra. Cant find much of the documentation on the same. I am using a MultiDC setup with cassandra 0.8.6. Regards, Shubham here's how i'm doing in AWS land using the DataS

Re: Cassandra and harddrives

2012-04-25 Thread Maki Watanabe
If your shared disk is super fast enough to handle IO requests from multiple cassandra node, you can do it in theory. And the disk will be the single point of failure in your system. For optimal performance, each node should have at least 2 hdd, one for commitlog and one for data. maki 2012/4/26

Re: Cassandra and harddrives

2012-04-25 Thread samal
Each node need its own HDD for multiple copies. cant share it with others node. On Thu, Apr 26, 2012 at 8:52 AM, Benny Rönnhager < benny.ronnha...@thrutherockies.com> wrote: > Hi! > > I am building a database with several hundred thousands of images. > have just learned that HaProxy is a very goo

Re: Cassandra and harddrives

2012-04-25 Thread Eric Evans
Questions like this should be directed to the user mailing list (user@cassandra.apache.org); This mailing list is for discussion of development *of* Cassandra. On Wed, Apr 25, 2012 at 3:25 PM, Benny Rönnhager wrote: > I am building a database with several hundred thousands of images. I have > ju

Re: EC2 Best Practices

2012-04-25 Thread Dave Brosius
0 is a perfectly valid id.node - 1 is modulo the maximum token value. that token range is 0 - 2**127so node - 1 in this case is 2**127 - Original Message -From: "Deno Vichas" >;d...@syncopated.net

Re: EC2 Best Practices

2012-04-25 Thread Deno Vichas
has anybody written up anything related to recovery for fails in EC2? this morning i woke up to find 1 (of 4) nodes marked as unreachable. i used the datastax (1.0.7) ami to set up my cluster and the node that fail had the token id of 0 (this is the seed node - right?). the docs says to repl

Re: Highest and lowest valid values for UUIDs/TimeUUIDs

2012-04-25 Thread Tyler Hobbs
Good idea. Done here: https://github.com/pycassa/pycassa/commit/2390363066c7efd79bdd2f27cd2d4496f692abf4 On Wed, Apr 25, 2012 at 7:11 AM, Carlo Pires wrote: > Tyler, > > A think you could add this values as python constants to pycassa. This > would be very useful for many people. > > > 2012/4/2

Re: nodetool repair hanging

2012-04-25 Thread Gregg Ulrich
How much data do you have and how long is "a while"? In my experience repairs can take a very long time. Check to see if validation compactions are running (nodetool compactionstats) or if files are streaming (nodetool netstats). If either of those are in progress then your repair should be r

RE: Bad Request: No indexed columns present in by-columns clause with "equals" operator

2012-04-25 Thread mdione.ext
De : mdione@orange.com [mailto:mdione@orange.com] > Should I understand that when the indexes are finished being built a) > the «Built indexes» list should be empty and b) there should be no pending > compactions? Because that's exactly what I have now but I still can't > use the column H

Re: Cassandra search performance

2012-04-25 Thread Jason Tang
1.0.8 在 2012年4月25日 下午10:38,Philip Shon 写道: > what version of cassandra are you using. I found a big performance hit > when querying on the secondary index. > > I came across this bug in versions prior to 1.1 > > https://issues.apache.org/jira/browse/CASSANDRA-3545 > > Hope that helps. > > 2012/4

Re: Cassandra search performance

2012-04-25 Thread Philip Shon
what version of cassandra are you using. I found a big performance hit when querying on the secondary index. I came across this bug in versions prior to 1.1 https://issues.apache.org/jira/browse/CASSANDRA-3545 Hope that helps. 2012/4/25 Jason Tang > And I found, if I only have the search con

Re: Cassandra search performance

2012-04-25 Thread Jason Tang
And I found, if I only have the search condition "status", it only scan 200 records. But if I combine another condition "partition" then it scan all records because "partition" condition match all records. But combine with other condition such as "userName", even all "userName" is same in the 1,0

Cassandra search performance

2012-04-25 Thread Jason Tang
Hi We have the such CF, and use secondary index to search for simple data "status", and among 1,000,000 row records, we have 200 records with status we want. But when we start to search, the performance is very poor, and check with the command "./bin/nodetool -h localhost -p 8199 cfstats" ,

Re: Proper Mutation to IntegerType column w/ secondary index

2012-04-25 Thread Patrik Modesto
I'll also try LongType index. I'll let you know how that works. Regards, P.

Proper Mutation to IntegerType column w/ secondary index

2012-04-25 Thread Patrik Modesto
Hi, I see strange behaviour using CF with two secondary indexes, one IntegerType one UTF8Type. Using Cassanra 1.0.9 and CF: create column family IndexTest with column_type=Standard and comparator=UTF8Type and default_validation_class=UTF8Type and key_validation_class=UTF8Type

Re: Highest and lowest valid values for UUIDs/TimeUUIDs

2012-04-25 Thread Carlo Pires
Tyler, A think you could add this values as python constants to pycassa. This would be very useful for many people. 2012/4/24 Drew Kutcharian > Nice, that's exactly what I was looking for. > > > On Apr 24, 2012, at 11:21 AM, Tyler Hobbs wrote: > > Oh, I just realized that you're asking about th

Re: CQL 3.0 - UPDATE Statement - how it works?

2012-04-25 Thread Sylvain Lebresne
In CQL, both UPDATE AND INSERT have the same semantic and are both "upsert". I.e, INSERT does not fail if the record was already existing and UPDATE does not fail if the record wasn't existing. -- Sylvain On Wed, Apr 25, 2012 at 1:18 PM, Maciej Miklas wrote: > CQL will have UPDATE future, I am t

CQL 3.0 - UPDATE Statement - how it works?

2012-04-25 Thread Maciej Miklas
CQL will have UPDATE future, I am trying to understand how this could work. Every write is an append to SSTable, UPDATE would need to change data, but only if it exists, and this is problematic, since we have distributed system. Is UPDATE special kind of insert, which changes given data only if i

RE: Bad Request: No indexed columns present in by-columns clause with "equals" operator

2012-04-25 Thread mdione.ext
De : aaron morton [mailto:aa...@thelastpickle.com] > The secondary index will be build using the compaction features, > you can check the progress with nodetool compactionstats > > When they are build the output from describe. will list the build indexes. > > Built indexes: [] Should I unders

Re: size tiered compaction - improvement

2012-04-25 Thread Radim Kolar
Dne 18.4.2012 16:22, Jonathan Ellis napsal(a): It's not that simple, unless you have an append-only workload. I have append only workload and probably most ppl using TTL too.

Re: Cassandra 1.1 - conflict resolution - any changes ?

2012-04-25 Thread Sylvain Lebresne
> On Apr 25, 2012 9:36 AM, "Maciej Miklas" wrote: >> >> Hi, >> >> I've seen this blog entry: >> http://www.datastax.com/dev/blog/schema-in-cassandra-1-1 and I am trying to >> understand, how could Cassandra support PRIMARY KEY. >> >> Cassandra has silent conflict resolution, where each insert over

Re: Cassandra 1.1 - conflict resolution - any changes ?

2012-04-25 Thread Paolo Bernardi
Yes, AFAIK it's still like this (and I don't think that this behavior will change, you can rely on it). Paolo On Apr 25, 2012 9:36 AM, "Maciej Miklas" wrote: > Hi, > > I've seen this blog entry: > http://www.datastax.com/dev/blog/schema-in-cassandra-1-1 and I am trying > to understand, how could

Crash by truncate with cassandra 1.1

2012-04-25 Thread Pierre Chalamet
Hi, With Cassandra 1.1, I have the following crash on a fresh new single node cluster running on Windows 7. On client side: create keyspace toto; create column family titi; truncate titi; The crash server side (the server is dead then) : D:\Cassandra\apache-cassandra-1.1.0\bin>ca

Cassandra 1.1 - conflict resolution - any changes ?

2012-04-25 Thread Maciej Miklas
Hi, I've seen this blog entry: http://www.datastax.com/dev/blog/schema-in-cassandra-1-1 and I am trying to understand, how could Cassandra support PRIMARY KEY. Cassandra has silent conflict resolution, where each insert overwrites next one, and there are only inserts and deletes - no updates. The