Re: Using CCM with Opscenter and manual agent installation

Thanks Michael for the reply. I'm quite new to Cassandra, so it make sense to explain the use case. I just want to try different choices of data modelling and compare number of reads and writes. At the moment I'm not interested in a real stress test, I just want to understand implications of my

Re: Using CCM with Opscenter and manual agent installation

Cassandra switched jmx to only bind to localhost, so I believe you just need to change jmx_host to localhost for all conf files. On Thu, Jan 7, 2016 at 4:48 PM, Giampaolo Trapasso < giampaolo.trapa...@radicalbit.io> wrote: > Thanks Michael for the reply. I'm quite new to Cassandra, so it make

Re: Best way to get Cassandra status in Bash

Hello, thanks a lot! The solution proposed by Gerard works perfectly. This is the snippet of what I have done: echo "Checking if Cassandra is up and running ..." # Try to connect on Cassandra's JMX port 7199 nc -z localhost 7199 nc_return=$? # Try to connect on Cassandra

Re: Requesting some details for my use case

Hi Jack, We are valuing reliability and consistency over performance right now. In E-commerce industry we can expect unexpected spikes at odd times. Ill be grateful if you tell me about reliability and failover scenarios. On Wed, Jan 6, 2016 at 2:59 AM, Jack Krupansky

Important notice for upgrades from 2.2.X to 3.Y

The native protocol is the name we give to the protocol used between CQL drivers and the server. That protocol is versioned and a new version, version 4, was introduced in Cassandra 2.2.0. We recently uncovered a compatibility bug in that 4th version

Sorting & pagination in apache cassandra 2.1

HI All, If suppose I have a cassandra table with structure CREATE TABLE test.t1 ( col1 text, col2 text, col3 text, col4 text, PRIMARY KEY (col1, col2, col3, col4) ) WITH CLUSTERING ORDER BY (col2 ASC, col3 ASC, col4 ASC); and it has following data col1 | col2 | col3 | col4

How do I upgrade from 2.0.16 to 2.0.17 in my case????

Hello, My problem is described CASSANDRA-10872 . I upgraded a second node on the same cluster in case there was something special with the first node but I experienced identical behaviour. Both cassandra-env.sh and cassandra-rackdc.properties

Re: How to make the result of select dateof(now) from system.local be equal to date command ?

The database timestamp is UTC, which should be the same as date -u on your system. cqlsh does not convert query results to local timezone, but it should be easy to do in your application code. Independent of the above, I'm a little confused by your example because I would expect CST to be UTC -

Re: what consistency level should I set when using IF NOT EXIST or UPDATE IF statements ?

Thanks Tyler. I've read the python document and it's a bit more clear than before, but i'm still confused at what combinations make lightweight transaction operations work correctly. So, let me clarify the conditions where lightweight transactions work. QUORUM conditional write -> QUORUM read

Re: Using CCM with Opscenter and manual agent installation

On 01/07/2016 08:46 PM, Michael Shuler wrote: > I'm not sure exactly what that service is, but if all 4 nodes (which are > all really localhost aliases) are attempting to bind to the same IP:port > for that stomp connection, they could be stepping on one another. Should > those be 127.0.0.1 for

Too many compactions, maybe keyspace system?

Hi, I am using Cassandra 2.0.16 with 4 nodes and found too many compactions for this cluster. This caused too much full gc and choked the system. I have discussed the high gc in previous mails but didnot get the satisfied answers. To clarify the source of the compactions, I shutdown all the

Re: Using CCM with Opscenter and manual agent installation

On 01/07/2016 02:09 AM, Giampaolo Trapasso wrote: > I've configured all the four agents. For example /agent3/ configuration is > > |[Giampaolo]: ~/opscenter/> cat agent3/conf/address.yaml stomp_interface: > "127.0.0.1" agent_rpc_interface: 127.0.0.3 jmx_host: 127.0.0.3 jmx_port: > 7300 | This

Re: Using CCM with Opscenter and manual agent installation

stomp_interface is the address to connect back to the central OpsCenter daemon with, so 127.0.0.1 should be correct. I believe the issue is just jmx_host needing to be set to 'localhost' On Thu, Jan 7, 2016 at 8:50 PM, Michael Shuler wrote: > On 01/07/2016 08:46 PM,

Re: Using CCM with Opscenter and manual agent installation

On 01/07/2016 10:17 PM, Nick Bailey wrote: > stomp_interface is the address to connect back to the central OpsCenter > daemon with, so 127.0.0.1 should be correct. I believe the issue is just > jmx_host needing to be set to 'localhost' This indeed looks promising, thanks Nick! mshuler@hana:~$

Is it good for performance to put rows that are of different types but are always queried together in the same table partition?

My consideration is that whether doing so will result in better memory/disk cache locality. Suppose I need to query for 2 different types of rows for a frequent user request, I can use 2 tables or 1 table: 2 tables: create table t1( partitionkey int primary key, col1 int, col2

RE: Data rebalancing algorithm

Have a look at this: http://www.datastax.com/dev/blog/virtual-nodes-in-cassandra-1-2 The vnodes mechanism is there to provide better scalability as new nodes are added/removed, by allowing a single node to own several small chunks of the token range. Aside from that, the process is exactly the

Re: Data rebalancing algorithm

num_tokens is the number of tokens per node, not per cluster. On Thu, Jan 7, 2016 at 10:09 PM Alec Collier wrote: > Have a look at this: > > http://www.datastax.com/dev/blog/virtual-nodes-in-cassandra-1-2 > > > > The vnodes mechanism is there to provide better

Re: Revisit Cassandra EOL Policy

If you wish to have a specific EOL policy, you need to basically buy it. It's unusual for open source projects to give any sort of an EOL policy; that's something that people with very specific requirements are willing to cough up a lot of money on. And getting money by giving support on older

Re: Revisit Cassandra EOL Policy

On Wed, Jan 6, 2016 at 5:26 PM, Anuj Wadehra wrote: > I would like to understand how various users are dealing with the > situation. Are you upgrading Cassandra every 3-6 mths? How do you cut short > your planning,test and release cycles for Cassandra upgrades in your >

Re: Sorting & pagination in apache cassandra 2.1

On Thu, Jan 7, 2016 at 6:45 AM, anuja jain wrote: > My question is, what is the alternative if we need to order by col3 or > col4 in my above example without including col2 in order by clause. > The server-side alternative is to create a second table (or a materialized

Re: Revisit Cassandra EOL Policy

Anuj, do you have a link to the versioning policy? The tick-tock versioning blog post [1] says that EOL happens after two major versions come out, but I can't find this stated more formally anywhere. I'm interested in how long a given version will receive patches for security issues or critical