Question on Read Repair

2012-09-16 Thread Raj N
Hi, I have a 2 DC setup(DC1:3, DC2:3). All reads and writes are at LOCAL_QUORUM. The question is if I do reads at LOCAL_QUORUM in DC1, will read repair happen on the replicas in DC2? Thanks -Raj

Re: Reading column names only

2012-09-16 Thread aaron morton
Re-work the data model if needed. There are probably some savings inside the server and definitely on the network if you could get just the column names. But it would take a lot of work to make the change and it's probably better solved at the model layer. Hope that helps.

Re: Query advice to prevent node overload

2012-09-16 Thread aaron morton
I have a schema that represents a filesystem and one example of a Super CF is: This may help with some ideas http://www.datastax.com/dev/blog/cassandra-file-system-design In general we advise to avoid Super Columns if possible. They are often slower, and the sub columns are not indexed. Meaning

Re: Is it possible to create a schema before a Cassandra node starts up ?

2012-09-16 Thread aaron morton
I have a script that needs to set up a schema first before starting up the cassandra node. Is this possible ? No. A node must be running to make a DDL change. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/09/2012, at 2:05 AM, Xu,

Re: cassandra does not close the stdout console on startup

2012-09-16 Thread aaron morton
Starting with -f backgrounds the process. By default logging is configured to write to stdout, maybe update log4j-server.properties. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/09/2012, at 2:49 AM, Xu, Zaili

Re: Composite Column Query Modeling

2012-09-16 Thread aaron morton
I may be missing something, but it looks like you pass multiple keys but only a singular SlicePredicate My bad. I was probably thinking multiple gets but wrote multigets. If Collections don't help maybe you need to support both query types using separate CF's. Or a secondary index for the