smallest/largest UUIDs for LexicalUUIDType

C*, I'm trying to use composite column names to organize 10**8 records. Each record has a unique pair of UUIDs. The first UUID is often repeated, so I want to use column_start and column_finish to find all the records that have a given UUID as the first UUID in the pair. I thought a simple

Re: Multiple JBOD data directory

... sorry, message got cut off # policy for data disk failures: # stop: shut down gossip and Thrift, leaving the node effectively dead, but # can still be inspected via JMX. # best_effort: stop using the failed disk and respond to requests based on # remaining available sstable

Re: Multiple JBOD data directory

If you're using cassandra 1.2 then you have a choice specified in the yaml # policy for data disk failures: # stop: shut down gossip and Thrift, leaving the node effectively dead, but # can still be inspected via JMX. # best_effort: stop using the failed disk and respond to requests based o

Re: 1.2 tuning

Hi- On Mon, Jun 3, 2013 at 10:36 AM, Robert Coli wrote: > On Mon, Jun 3, 2013 at 8:54 AM, Darren Smythe > wrote: > > Is "setting live ratio to minimum of 1.0 instead of X" supposed to be > rare? > > Because were getting it fairly consistently. > > Do you have working JNA? If so, my understandin

Re: Looking for a fully working AWS multi DC configuration.

Do you open all these nodes one by one on every Security Group in each region every time you add a node or did you manage to automate it somehow ? 2013/6/5 Dan Kogan > Hi, > > ** ** > > We are using a very similar configuration. From our experience, Cassandra > nodes in the same DC need ac

Re: Cassandra optimizations for multi-core machines

Hi, Cassandra is heavily multithreaded. If the load demands it will make use of your 8 cores. I dont know the startup code, but I would assume it would be parallelized if neccessary/possible. Afaik there were optimizations already made to reduce the startup time. Therefore I would assume any opti

Cassandra optimizations for multi-core machines

Hello All, We are thinking of going with Cassandra on a 8 core machine, are there any optimizations that can help us here ? I have seen that during startup stage Cassandra uses only one core, is there a way we can speed up the startup process ? Thanks !

Re: partition key of composite type and "where partition_key in (...)" clause

Hi Sorin, I'm not aware of CQL supporting Cartesian set notation, and like you when I tried it, the CQL parser bailed at the first parenthesis - "*(*k1, k2)" You cannot use SELECT in a BATCH statement, see http://cassandra.apache.org/doc/cql/CQL.html#BATCH So I'm not sure what your options are o

RE: Looking for a fully working AWS multi DC configuration.

Hi, We are using a very similar configuration. From our experience, Cassandra nodes in the same DC need access over both public and private IP on the storage port (7000/7001). Nodes from other DC will need access over public IP on the storage port. All Cassandra nodes also need access over th

Cassandra and "-server" JVM parameter

Hi, I'm wondering why Cassandra does not use "-server" JVM parameter. Did you try it and obtained bad results ? Or maybe I've missed something somewhere... Thanks !

Looking for a fully working AWS multi DC configuration.

Hi, We use to work on a single DC (EC2Snitch / SimpleStrategy). For latency reason we had top open a new DC in the US (us-east). We run C* 1.2.2. We don't use VPC. Now we use: - 2 DC (eu-west, us-east) - EC2MultiRegionSnitch / NTS - public IPs as broadcast_address and seeds - private IPs as liste

partition key of composite type and "where partition_key in (...)" clause

Hello, Is it possible to use the "where partition_key in (...)" clause if the partition key has a composite type? I have a schema as follows: create table tbl ( k1 int, k2 varchar, k3 varchar, m blob, primary key((k1, k2), k3) ) I would like to be able to do something like se

RE: Multiple JBOD data directory

I would hope so. Just trying to get some confirmation from someone with production experience. Thanks for your reply From: Shahab Yunus [mailto:shahab.yu...@gmail.com] Sent: 05 June 2013 13:31 To: user@cassandra.apache.org Subject: Re: Multiple JBOD data directory Though, I am a newbi

Re: Multiple JBOD data directory

Though, I am a newbie bust just had a thought regarding your question 'How will it handle requests for data which unavailable?', wouldn't the data be served in that case from other nodes where it has been replicated? Regards, Shahab On Wed, Jun 5, 2013 at 5:32 AM, Christopher Wirt wrote: > Hell

Re: CQL 3 returning duplicate keys

Thanks Eric. Yeah, I was asking about the second limitation (about dynamic columns) and you have explained it well along with pointers to read further. Regards, Shahab On Wed, Jun 5, 2013 at 8:18 AM, Eric Stevens wrote: > I mentioned a few limitations, so I'm not sure which you refer to. > >

Re: CQL 3 returning duplicate keys

I mentioned a few limitations, so I'm not sure which you refer to. As for not being able to access a CQL3 column family via traditional approaches, beyond the example I gave above (where cassandra-cli claims it does not recognize the column family), here is an article that mentions it: http://www.

Multiple JBOD data directory

Hello, We're thinking about using multiple data directories each with its own disk and are currently testing this against a RAID0 config. I've seen that there is failure handling with multiple JBOD. e.g. We have two data directories mounted to separate drives /disk1 /disk2 One of

New virtual node not starting

Hi, I have added a third node(virtual) to a previously existing two node test cluster(virtual). When I am starting the new node after doing changes in the configuration file, it is getting struck for hours every time showing the following logs: ...