Custom commands in cassandra

2013-07-26 Thread Nulik Nol
Hi, I am a startup in development stage, and I want to embed my app functionality into cassandra's server. How might it be done? Some databases allow you to load server-side extensions or commands that are executed upon client's request as some sort of stored procedures. Another databases let you e

Re: maximum storage per node

2013-07-26 Thread cem
I dont think it is a good idea to put multiple instance in same machine. You may lose multiple instances at the same time if the machine goes down. You can also specify multiple directories as storage in 1.2. I am also not sure boot-strapping will be a big problem since the number keys you will st

RE: cassandra 1.2.5- virtual nodes (num_token) pros/cons?

2013-07-26 Thread HuS . Andy
Disadvantage, hadoop support is based on the token range, so maps may equals numtokens per node * nodes number. Best Regards,Andy Hu(胡 珊) Date: Thu, 25 Jul 2013 17:25:11 -0400 Subject: cassandra 1.2.5- virtual nodes (num_token) pros/cons? From: rashmi.aros...@gmail.com To: user@cassandra.apache

Re: Custom commands in cassandra

2013-07-26 Thread Radim Kolar
What would be the way to do this with cassandra? embed app into server, use OSGi.

RE: maximum storage per node

2013-07-26 Thread Romain HARDOUIN
Do you have some fairly complex queries to run against your data? Or your need is just to store large pieces of data? (In which case Object Storage like OpenStack Swift could be more appropriate IMHO) "Pruner, Anne (Anne)" a écrit sur 25/07/2013 17:45:11 : > De : "Pruner, Anne (Anne)" > A : "u

Re: sstable size change

2013-07-26 Thread Keith Wright
FYI. It appears that the proper command in CQL3 is the following: alter table cookie_user_lookup with compaction={'sstable_size_in_mb': '256', 'class': 'LeveledCompactionStrategy'}; I still would have expected my original alter command to at least have thrown an error. I assume I should open

AssertionError: Incorrect row data size

2013-07-26 Thread Pavel Kirienko
Hi list, We run Cassandra 1.2 on three-node cluster. Each node has 16GB RAM, single 200GB HDD with Ubuntu Server 12.04. There is an issue with one table that contains about 3000 rows, here its describe-table: CREATE TABLE outputs ( appid text, staged boolean, field ascii, data blob, PR

RE: cassandra 1.2.5- virtual nodes (num_token) pros/cons?

2013-07-26 Thread Romain HARDOUIN
Vnodes are a great feature. More nodes are involved during operations such as bootstrap, decommission, etc. DataStax documentation is definitely a must read. That said, If I were you, I'd wait somewhat before to shuffle the ring. I'd focus on cluster upgrade and monitoring the nodes. (number of f

hadoop/cassandra integration using CL_ONE...

2013-07-26 Thread Hiller, Dean
Is it possible to use CL_ONE with hadoop/cassandra when doing an M/R job? And more importantly is there a way to configure that such that if my RF=3, that it only reads from 1 of the nodes in that 3. We have 12 nodes and ideally we would for example hope M/R runs on a2, a9, a5, a12 which happen

Re: cassandra 1.2.5- virtual nodes (num_token) pros/cons?

2013-07-26 Thread David McNelis
I second Romain, do the upgrade and make sure the health is good first. If you have or plan to have a large number of nodes, you might consider using fewer than 256 as your initial vnodes amount. I think that number is inflated from reasonable in the docs, as we've had some people talk about pote

AssertionError during ALTER TYPE in 1.2.5

2013-07-26 Thread Sergey Leschenko
Hi, I have following column family from pre-CQL times, now using 1.2.5 and want to investigate ability to use CQL instead of Thrift API. ColumnFamily: RRD Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type Default column value validator: org.apache.cassandra.db.marshal.B

[RELEASE] Apache Cassandra 1.2.7 released

2013-07-26 Thread Sylvain Lebresne
The Cassandra team is pleased to announce the release of Apache Cassandra version 1.2.7. Cassandra is a highly scalable second-generation distributed database, bringing together Dynamo's fully distributed design and Bigtable's ColumnFamily-based data model. You can read more here: http://cassand

Re: maximum storage per node

2013-07-26 Thread Robert Coli
On Fri, Jul 26, 2013 at 4:23 AM, Romain HARDOUIN wrote: > Do you have some fairly complex queries to run against your data? > Or your need is just to store large pieces of data? (In which case Object > Storage like OpenStack Swift could be more appropriate IMHO) > Or distributed blob storage like

Re: Custom commands in cassandra

2013-07-26 Thread Nulik Nol
On Fri, Jul 26, 2013 at 4:31 AM, Radim Kolar wrote: > >> What would be the way to do this with cassandra? > > embed app into server, use OSGi. Thanks, but a quick search of cassandra's source didn't return any word like "osgi", are you sure I can emmbed my code into cassandra ? could you tell me t

Re: AssertionError: Incorrect row data size

2013-07-26 Thread Paul Ingalls
This is the same issue we have been seeing. Still no luck getting a simple repro case for creating a JIRA issue. Do you have something simple enough to drop in a JIRA report? Paul On Jul 26, 2013, at 8:06 AM, Pavel Kirienko wrote: > Hi list, > > We run Cassandra 1.2 on three-node cluster.

Re: Custom commands in cassandra

2013-07-26 Thread Radim Kolar
basic osgi integration is easy you need to get osgi compatible container and hookup it to cassandra daemon. Its very easy to do - about 5 lines. osgi container can be accessed from network, you need to deploy your application into container on each node and start it up. Then use some RPC mecha

key cache hit rate and BF false positive

2013-07-26 Thread Keith Wright
Hi all, I am experiencing VERY poor key cache hit rate on my 6 node C* 1.2.4 with Vnode cluster. I am using CQL3 with LCS and yesterday increased my SSTable size from default 5 MB to 256 MB although I did not force a major compaction and am instead letting the new size take effect organica

Re: key cache hit rate and BF false positive

2013-07-26 Thread Keith Wright
Also here is the output from cfhistograms if that helps. Thanks all! users/cookie_user_lookup histograms Offset SSTables Write Latency Read Latency Row Size Column Count 1 574961651 0 0 0 67267 2