Re: CQL3 Custom Functions

2014-02-11 Thread Sylvain Lebresne
On Mon, Feb 10, 2014 at 7:16 PM, Drew Kutcharian d...@venarc.com wrote: Hey Guys, How can I define custom CQL3 functions (similar to dateOf, now, etc)? You can't, there is currently no way to define custom functions. -- Sylvain

RE: Recommended OS

2014-02-11 Thread Brust, Corwin [Hollander]
This /is/ our first cluster. We've upgraded one-over-one since 2.0.2 (our initially deployed version), doing rolling updates across the rings. No especial resource tuning save turning off SELinux and the usual (disabling swap, separate disk for commit logs, data and the OS). From: Keith

RE: Adding a node to cluster keeping 100% data replicated on all nodes

2014-02-11 Thread Brust, Corwin [Hollander]
I’m wondering if write consistency “ALL” on the KeySpace will help, here. I too will listen eagerly for the ordained answer. From: _ _ [mailto:a...@abv.bg] Sent: Monday, February 10, 2014 5:02 AM To: user@cassandra.apache.org Subject: Re: Adding a node to cluster keeping 100% data replicated

Worse perf after Row Caching version 1.2.5:

2014-02-11 Thread PARASHAR, BHASKARJYA JAY
Hi, I have two tables and I enabled row caching for both of them using CQL. These two CF's are very small with one about 300 rows and other 2000 rows. The rows themselves are small. Cassandra heap: 8gb. a. alter table TABLE_X with caching = 'rows_only'; b. alter table TABLE_Y with

1.2.15 non-seed nodes never join cluster. JOINING: waiting for schema information to complete

2014-02-11 Thread John Pyeatt
I am trying to bring up a 6 node cluster in AWS. 3 seed nodes and 3 non-seed nodes. One of each in each availability zone with 1.2.15 and my non-seed nodes never join the cluster. If I run 1.2.14 everything works fine. We are not using vnodes and all of the initial_token values are assigned based

Re: 1.2.15 non-seed nodes never join cluster. JOINING: waiting for schema information to complete

2014-02-11 Thread sankalp kohli
If you don't have a schema, you are probably hitting this https://issues.apache.org/jira/browse/CASSANDRA-6685 On Tue, Feb 11, 2014 at 8:22 AM, John Pyeatt john.pye...@singlewire.comwrote: I am trying to bring up a 6 node cluster in AWS. 3 seed nodes and 3 non-seed nodes. One of each in each

Re: Clarification on how multi-DC replication works

2014-02-11 Thread sankalp kohli
@Mullen, I think your diagram does not answer the question on responses. @Sameer All nodes in DC2 will replay back to the co-ordinator in DC1. So if you have replication of DC1:3,DC2:3. A co-ordinator node will get 6 responses back if it is not in the replica set. Hope that answers your question.

Re: Worse perf after Row Caching version 1.2.5:

2014-02-11 Thread Jonathan Lacefield
Hello, Please paste the output of cfhistograms for these tables. Also, what does your environment look like, number of nodes, disk drive configs, memory, C* version, etc. Thanks, Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield

Re: 1.2.15 non-seed nodes never join cluster. JOINING: waiting for schema information to complete

2014-02-11 Thread Michael Shuler
On 02/11/2014 10:34 AM, sankalp kohli wrote: If you don't have a schema, you are probably hitting this https://issues.apache.org/jira/browse/CASSANDRA-6685 Looks like #6685 was committed to the cassandra-1.2 branch, yesterday. SNAPSHOT artifacts can be grabbed for the latest build of each

Re: Clarification on how multi-DC replication works

2014-02-11 Thread Mullen, Robert
So is that picture incorrect, or just incomplete missing the piece on how the nodes reply to the coordinator node. On Tue, Feb 11, 2014 at 9:38 AM, sankalp kohli kohlisank...@gmail.comwrote: @Mullen, I think your diagram does not answer the question on responses. @Sameer All nodes in DC2

Re: Clarification on how multi-DC replication works

2014-02-11 Thread Andrey Ilinykh
1. reply part is missing. 2. It is confusing a little bit. I would not use term synchronous. Everything is asynchronous here. Coordinator writes data to all local nodes and waits for response from ANY two of them (in case of quorum). In your picture it looks like the coordinator first makes

Re: Clarification on how multi-DC replication works

2014-02-11 Thread Mullen, Robert
Thanks for the feedback. The picture shows a sample request, which is why the coordinator points to two specific nodes. What I was trying to convey that the coordinator node would ensure that 2 of the 3 nodes were written to before reporting success to the client. I found the article here, it

Re: Clarification on how multi-DC replication works

2014-02-11 Thread Andrey Ilinykh
On Tue, Feb 11, 2014 at 10:14 AM, Mullen, Robert robert.mul...@pearson.comwrote: Thanks for the feedback. The picture shows a sample request, which is why the coordinator points to two specific nodes. What I was trying to convey that the coordinator node would ensure that 2 of the 3 nodes

Re: Clarification on how multi-DC replication works

2014-02-11 Thread Mullen, Robert
The picture shows a sample request, which is why the coordinator points to two specific nodes. What I was trying to convey that the coordinator node would ensure that 2 of the 3 nodes were written to before reporting success to the client. This is my point. ANY 2 of 3. Your picture shows

Re: Clarification on how multi-DC replication works

2014-02-11 Thread graham sanderson
slightly off topic, but does anyone know off the top of their head what happens if data is being written at LOCAL_QUORUM to a multi data center setup faster than the inter data center link can handle… something has to block, throw an exception, die, or have unbounded growth (memory, threads, on

Warning about copying and pasting from datastax configuration page: weird characters in config

2014-02-11 Thread Donald Smith
In http://www.datastax.com/documentation/cassandra/2.0/mobile/cassandra/install/installRecommendSettings.html it says: Packaged installs: Ensure that the following settings are included in the /etc/security/limits.d/cassandra.conf file: cassandra - memlock unlimited cassandra - nofile 10

Re: Warning about copying and pasting from datastax configuration page: weird characters in config

2014-02-11 Thread Michael Shuler
On 02/11/2014 04:50 PM, Donald Smith wrote: In http://www.datastax.com/documentation/cassandra/2.0/mobile/cassandra/install/installRecommendSettings.html it says: Just curious.. why are you using the mobile site on a desktop, instead of the main page? [0] -- Michael [0]

RE: Warning about copying and pasting from datastax configuration page: weird characters in config

2014-02-11 Thread Donald Smith
The same problem happens with the non-mobile page: http://www.datastax.com/documentation/cassandra/2.0/webhelp/index.html#cassandra/install/installRecommendSettings.html I used the mobile page because someone embedded that link in a wiki page I was referring to. (I'll change the link.) Don

Re: Warning about copying and pasting from datastax configuration page: weird characters in config

2014-02-11 Thread Andy Losey
I think the issue you're running into is the same reason not to compose a script or config file in notepad. Without using a true text editor (vi), or relying on copy and past, you're very likely to introduce non visible formatting characters, as you see with you paragraph symbols. Trusting code

Re: Warning about copying and pasting from datastax configuration page: weird characters in config

2014-02-11 Thread Michael Shuler
On 02/11/2014 05:23 PM, Andy Losey wrote: I think the issue you're running into is the same reason not to compose a script or config file in notepad. Without using a true text editor (vi), or relying on copy and past, you're very likely to introduce non visible formatting characters, as you see

Re: Warning about copying and pasting from datastax configuration page: weird characters in config

2014-02-11 Thread Robert Coli
On Tue, Feb 11, 2014 at 3:23 PM, Andy Losey and...@addthis.com wrote: I think the issue you're running into is the same reason not to compose a script or config file in notepad. Without using a true text editor (vi), or relying on copy and past, you're very likely to introduce non visible