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 ind

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

2012-09-11 Thread Data Craftsman
you > probably have gone 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.

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 Archi

Re: How to set LeveledCompactionStrategy for an existing table

2012-09-02 Thread Data Craftsman
We have same problem. On Friday, August 31, 2012, Jean-Armel Luce 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 > > Looks like a bug. > Can you please create a ticket

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 wrote: > In using CQL (the pytho

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 木匠 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/docs/1.

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 '