Re: Using the commit log for external synchronization

2012-09-20 Thread Data Craftsman
This will be a good new feature. I guess the development team don't have time on this yet. ;) On Thu, Sep 20, 2012 at 1:29 PM, Ben Hood 0x6e6...@gmail.com wrote: Hi, I'd like to incrementally synchronize data written to Cassandra into an external store without having to maintain an index to

Re: Number of columns per row for Composite Primary Key CQL 3.0

2012-09-11 Thread Data Craftsman
too far. Remember the byte size of the row is also important; larger rows churn memory more and take longer to compact / repair. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 8/09/2012, at 11:05 AM, Data Craftsman 木匠

Number of columns per row for Composite Primary Key CQL 3.0

2012-09-07 Thread Data Craftsman
Hello experts. Should I limit the number of rows per Composite Primary Key's leading column? I think it falls into the same wide row good practice for number of columns per row for CQL 2.0, e.g. 10M or less. Any comments will be appreciated. -- Thanks, Charlie (@mujiang) 木匠 === Data

Re: How to set LeveledCompactionStrategy for an existing table

2012-09-03 Thread Data Craftsman
We have same problem. On Friday, August 31, 2012, Jean-Armel Luce jaluc...@gmail.com wrote: Hello Aaron. Thanks for your answer Jira ticket 4597 created : https://issues.apache.org/jira/browse/CASSANDRA-4597 Jean-Armel 2012/8/31 aaron morton aa...@thelastpickle.com Looks like a bug.

Re: CQL connections

2012-08-10 Thread Data Craftsman
I want to know it too. http://www.datastax.com/support-forums/topic/when-will-pycassa-support-cql Connection pool and load balance is a necessary feature for multi-user production application. Thanks, Charlie | DBA On Fri, Aug 10, 2012 at 6:47 AM, David McNelis dmcne...@gmail.com wrote: In

Re: How to create a COLUMNFAMILY with Leveled Compaction?

2012-08-03 Thread Data Craftsman
Nobody use Leveled Compaction with CQL 3.0 ? -Z On Tue, Jul 31, 2012 at 11:17 AM, Data Craftsman 木匠 database.crafts...@gmail.com wrote: Sorry for my stupid simple question. How to create a COLUMNFAMILY with Leveled Compaction? There is no example in documentation: http://www.datastax.com

How to create a COLUMNFAMILY with Leveled Compaction?

2012-07-31 Thread Data Craftsman
Sorry for my stupid simple question. How to create a COLUMNFAMILY with Leveled Compaction? There is no example in documentation: http://www.datastax.com/docs/1.1/configuration/storage_configuration#compaction-strategy I try it on Cassandra 1.1.0 and 1.1.2, both failed. The COLUMNFAMILY is still