Re: Enable compression Cassandra 1.1.2

We just upgrade to C* 1.1.6 We can now change anything using the CLI or cqlsh. So problem solved. 2012/11/14 Alain RODRIGUEZ > Oh! That's obviously the exact same issue. I didn't find this thread while > searching about my issue. > > We will upgrade. > > Thanks for the link. > > > 2012/11/14 a

Re: Offsets and Range Queries

There are several reasons. First there is no "absolute offset". The rows are sorted by the data. If someone inserts new data between your query and this query the rows have changed. Unless you doing select queries inside a transaction with repeatable read and your database supports this the query

Re: unable to read saved rowcache from disk

If the startup is taking a long time or not working and you believe it to be corrupt in some way it is safe to delete the saved cache files. If you think the process is taking longer then it should you could try attaching a debugger to the process. I try to avoid the row cache these days, even wit

Re: unable to read saved rowcache from disk

For a row cache of 1,650,000: 16 byte token 300 byte row key ? and row data ? multiply by a java fudge factor or 5 or 10. Trying delete the saved cache and restarting. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.co

Re: Upgrade 1.1.2 -> 1.1.6

Can you provide an example of the increase ? Can you provide the log from startup ? Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 16/11/2012, at 3:21 AM, Alain RODRIGUEZ wrote: > We had an issue with counters ove

Re: unable to read saved rowcache from disk

Just curious why do you think row key will take 300 byte? If the row key is Long type, doesn't it take 8 bytes? In his case, the rowCache was 500M with 1.6M rows, so the row data is 300B. Did I miss something? Thanks. -Wei From: aaron morton To: user@cassandr

Re: Looking for a good Ruby client

Update on this: someone just pointed me towards the Cequel gem: https://github.com/brewster/cequel The way it's described in the readme it looks like exactly what I was looking for - a modern, CQL-based gem that is in active development and also follows the ActiveModel pattern. I'd be very intere

Re: Upgrade 1.1.2 -> 1.1.6

Here is an example of the increase for some counter (counting events per hour) time (UTC) 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Good value 88 44 26 35 26 86 187 251 455 389 473 367 453 373 C* counter 149 82 45 68 38 146 329 414 746 566 473 377 453 373 I finished my Cassandra 1.1.6 upgrades at 9

Datatype Conversion in CQL-Client?

Does the official/built-in Cassandra CQL client (in 1.2) offer any built-in option to get direct values/objects when reading a field, instead of just a byte array?

Admin for cassandra?

Is there an IDE for a Cassandra database? Similar to the SQL Server Management Studio for SQL server. I mainly want to execute queries and see the results. Preferably that runs under a Windows OS. Thank you.

cassandra-sharp 2.0-ALPHA available

Hi all, I'm happy to announce a new release of cassandra-sharp (version 2.0-alpha), a .NET client for Cassandra - all bits are available at http://code.google.com/p/cassandra-sharp/. This version is quite special because only the CQL Binary Protocol interface is supported ! Yes, Thrift is d

Question regarding the need to run nodetool repair

I have a 4 node cluster, version 1.1.2, replication factor of 4, read/write consistency of 3, level compaction. Several questions. 1) Should nodetool repair be run regularly to assure it has completed before gc_grace? If it is not run, what are the exposures? 2) If a node goes down

Re: Question regarding the need to run nodetool repair

On Thursday, November 15, 2012, Dwight Smith wrote: > I have a 4 node cluster, version 1.1.2, replication factor of 4, read/write consistency of 3, level compaction. Several questions. > > > > 1) Should nodetool repair be run regularly to assure it has completed before gc_grace? If it is no

RE: Question regarding the need to run nodetool repair

Thanks From: Edward Capriolo [mailto:edlinuxg...@gmail.com] Sent: Thursday, November 15, 2012 4:30 PM To: user@cassandra.apache.org Subject: Re: Question regarding the need to run nodetool repair On Thursday, November 15, 2012, Dwight Smith wrote: > I have a 4 node cluster, version 1.1

Re: Question regarding the need to run nodetool repair

On Thu, Nov 15, 2012 at 4:12 PM, Dwight Smith wrote: > I have a 4 node cluster, version 1.1.2, replication factor of 4, read/write > consistency of 3, level compaction. Several questions. Hinted Handoff is broken in your version [1] (and all versions between 1.0.0 and 1.0.3 [2]). Upgrade to 1.1.

RE: Admin for cassandra?

Cqlsh is probably the closest you will get. Or pay big bucks to hire someone to develop one for you:) Thanks. -Wei Sent from my Samsung smartphone on AT&T Original message Subject: Admin for cassandra? From: Kevin Burton To: user@cassandra.apache.org CC: Is there an ID

Re: Admin for cassandra?

We should build an eclipse plugin named Eclipsandra or something. On Thu, Nov 15, 2012 at 9:45 PM, Wz1975 wrote: > Cqlsh is probably the closest you will get. Or pay big bucks to hire someone > to develop one for you:) > > > Thanks. > -Wei > > Sent from my Samsung smartphone on AT&T > > > ---

Re: Offsets and Range Queries

Thanks Ed, for the clarifications Yes you are correct that the apps have to handle repeatable reads and not the databases themselves when using absolute offsets, but SQL databases do provide such an option at app's peril!!! "Slices have a fixed size, this ensures that the the "query" does not exe

Re: Admin for cassandra?

I think an eclipse plugin would be the wrong way to go here. Most people probably just want to browse through the columnfamilies and see whether their queries work out or not. This functionality is imho best implemented as some form of a light-weight editor, not a full blown IDE. I do have somethi