Counter question

2012-03-29 Thread Tamar Fraenkel
Hi! Asking again, as I didn't get responses :) I have a ring with 3 nodes and replication factor of 2. I have counter cf with the following definition: CREATE COLUMN FAMILY tk_counters with comparator = 'UTF8Type' and default_validation_class = 'CounterColumnType' and

Re: Counter question

2012-03-29 Thread Shimi Kiviti
Like everything else in Cassandra, If you need full consistency you need to make sure that you have the right combination of (write consistency level) + (read consistency level) if W = write consistency level R = read consistency level N = replication factor then W + R N Shimi On Thu, Mar 29,

opscenter

2012-03-29 Thread puneet loya
I m currently using the the datastax opscenter. How do we add column to the column families in opscenter??

Re: opscenter

2012-03-29 Thread R. Verlangen
As far as I'm aware of that is not possible using the opscenter. I recommend you use the cassandra-cli and perform an update column family query. 2012/3/29 puneet loya puneetl...@gmail.com I m currently using the the datastax opscenter. How do we add column to the column families in

Re: Counter question

2012-03-29 Thread Tamar Fraenkel
Can this be set on a CF basis. Only this CF needs higher consistency level. Thanks, Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, Mar 29, 2012 at 10:44 AM,

Re: Counter question

2012-03-29 Thread Paolo Bernardi
On Thu, 2012-03-29 at 11:47 +0200, Tamar Fraenkel wrote: Can this be set on a CF basis. Only this CF needs higher consistency level. The consistency level of read/write operations is specified at each single read/write function call. This means that you have to use the desired consistency level

Re: Counter question

2012-03-29 Thread Shimi Kiviti
You set the consistency with every request. Usually a client library will let you set a default one for all write/read requests. I don't know if Hector lets you set a default consistency level per CF. Take a look at the Hector docs or ask it in the Hector mailing list. Shimi On Thu, Mar 29, 2012

Re: [BETA RELEASE] Apache Cassandra 1.1.0-beta2 released

2012-03-29 Thread Sylvain Lebresne
To be clear, the incompatibility we've talked about does *not* concern any of the 1.0 releases (you'll want to refer NEWS file for any details on the upgrade path for these versions). The incompatibility here is only between 1.1.0-beta1 and 1.1.0-beta2. -- Sylvain On Thu, Mar 29, 2012 at 2:50

Re: opscenter

2012-03-29 Thread puneet loya
thank you :) I m using cqlsh now.. Its workin.. Can we add an autoincrement field using cqlsh?? On Thu, Mar 29, 2012 at 2:23 PM, R. Verlangen ro...@us2.nl wrote: As far as I'm aware of that is not possible using the opscenter. I recommend you use the cassandra-cli and perform an update

Re: Counter question

2012-03-29 Thread Tamar Fraenkel
Thanks! will do. Tamar *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Thu, Mar 29, 2012 at 12:11 PM, Shimi Kiviti shim...@gmail.com wrote: You set the consistency with

Re: Cassandra 06x debian repo GONE

2012-03-29 Thread Sylvain Lebresne
Not sure what happened in there. Anyway, I've regenerated the Packages file so hopefully that should be fixed (but it may take up to an hour to propagate to apache mirrors). That being said, I wouldn't advise relying on the 0.6 packages to be available forever. Apache is not fond of us keeping

Re: [BETA RELEASE] Apache Cassandra 1.1.0-beta2 released

2012-03-29 Thread Mohit Anchlia
This is from NEWS.txt. So my question is if we are on 1.0.0-2 release do we still need to upgrade since this impacts releases between 1.0.3-1.0.5? - If you are running a multi datacenter setup, you should upgrade to the latest 1.0.x (or 0.8.x) release before upgrading. Versions

RE: Any improvements in Cassandra JDBC driver ?

2012-03-29 Thread Jeremiah Jordan
There is no such thing as pure insert which will give an error if the thing already exists. Everything is really UPDATE OR INSERT. Whether you say UPDATE, or INSERT, it will all act like UPDATE OR INSERT, if the thing is there it get over written, if it isn't there it gets inserted.

Re: Cassandra 06x debian repo GONE

2012-03-29 Thread Ashley Martens
Got it. Moving the packages I use to another repo now. On Thu, Mar 29, 2012 at 7:17 AM, Sylvain Lebresne sylv...@datastax.comwrote: Not sure what happened in there. Anyway, I've regenerated the Packages file so hopefully that should be fixed (but it may take up to an hour to propagate to

Re: Any improvements in Cassandra JDBC driver ?

2012-03-29 Thread Dinusha Dilrukshi
What I want to tell was this driver does not use INSERT key word. Since CQL support for using INSERT keyword and it is more generic key word used to add new records, it's more user friendly to use INSERT key word to add new record set rather using UPDATE keyword. Regards, ~Dinusha~ On Thu,

Cassandra multi DC

2012-03-29 Thread Alexandru Sicoe
Hello everyone, How are people running multi DC Cassandra across remote locations? Are VPNs used? Or some dedicated application proxis? What is the norm here? Any advice is much appreciated, Alex

Re: Cassandra multi DC

2012-03-29 Thread David Schairer
We built multi-DC right from the start -- two equal locations about 1000 miles apart but on the same provider backbone so there was reasonably robust and consistent connectivity between them. We did this using software ipsec to set up tunnels between the private networks in each location, but

another DataStax OpsCenter question

2012-03-29 Thread Alexandru Sicoe
Hello, I am planning on testing OpsCenter to see how it can monitor a multi DC cluster. There are 2 DCs each on a different side of a firewall. I've configured NAT on the firewall to allow the communication between all Cassandra nodes on ports 7000, 7199 and 9160. The cluster works fine. However

cassandra gui

2012-03-29 Thread Tim Dunphy
hey all, I have a new cassandra node that I've setup so that I can get better acquainted with this technology. Thus far I've been using the cassandra-cli and it'd been a fun experience so far. However I know that there are a few cassandra gui's out there and I was just wondering which ones

Re: Cassandra multi DC

2012-03-29 Thread Eric Tamme
On 03/29/2012 01:35 PM, Alexandru Sicoe wrote: Hello everyone, How are people running multi DC Cassandra across remote locations? Are VPNs used? Or some dedicated application proxis? What is the norm here? Any advice is much appreciated, Alex No vpn for us. We do it all over pure ipv6

Re: Any improvements in Cassandra JDBC driver ?

2012-03-29 Thread R. Verlangen
The best would to not use update / insert at all but set / put / save. Cheers! 2012/3/29 Dinusha Dilrukshi sdddilruk...@gmail.com What I want to tell was this driver does not use INSERT key word. Since CQL support for using INSERT keyword and it is more generic key word used to add new

Re: cassandra gui

2012-03-29 Thread Mucklow, Blaine (GE Energy)
Datastax OpsCenter really is pretty awesome. I haven't tried anything else, but have had no issues with opscenter. On 3/29/12 1:53 PM, Tim Dunphy bluethu...@gmail.com wrote: hey all, I have a new cassandra node that I've setup so that I can get better acquainted with this technology. Thus far

Re: cassandra gui

2012-03-29 Thread Nick Bailey
Just so you know. OpsCenter is a good tool for managing your cluster and viewing data in your keyspaces/columnfamilies (data besides string data currently doesn't display an extremely user friendly way, it will display hex). Currently you can not insert data to your cluster using the OpsCenter gui

Re: cassandra gui

2012-03-29 Thread Tim Dunphy
Cool guys, thanks. I'll certainly give it a try now that my cassandra setup is functioning well. But what about the Apollo gui for Cassandra. Has anyone else had any experience with that and maybe know if it supports entering data into the cluster? tx! On Thu, Mar 29, 2012 at 2:33 PM, Nick

Re: [BETA RELEASE] Apache Cassandra 1.1.0-beta2 released

2012-03-29 Thread Mohit Anchlia
Any updates? On Thu, Mar 29, 2012 at 7:31 AM, Mohit Anchlia mohitanch...@gmail.comwrote: This is from NEWS.txt. So my question is if we are on 1.0.0-2 release do we still need to upgrade since this impacts releases between 1.0.3-1.0.5? - If you are running a multi datacenter setup, you

Re: another DataStax OpsCenter question

2012-03-29 Thread Nick Bailey
This setup may be possible although there are a few potential issues. Firstly, see: http://www.datastax.com/docs/opscenter/configure_opscenter#configuring-firewall-port-access Basically the agents and OpsCenter communicate on ports 61620 and 61621 by default (those can be configured though). The

Re: [BETA RELEASE] Apache Cassandra 1.1.0-beta2 released

2012-03-29 Thread Sylvain Lebresne
As the NEWS file says, only the version 1.0.3-1.0.5 are generating those cross-dc forwarding messages that are incompatible with 1.1. If you're on 1.0.0, you shouldn't have that problem. To be more precise, 1.0.0 does not generate cross-dc forwarding message at all, so you're safe on that side.

Re: [BETA RELEASE] Apache Cassandra 1.1.0-beta2 released

2012-03-29 Thread Mohit Anchlia
On Thu, Mar 29, 2012 at 1:32 PM, Sylvain Lebresne sylv...@datastax.comwrote: As the NEWS file says, only the version 1.0.3-1.0.5 are generating those cross-dc forwarding messages that are incompatible with 1.1. If you're on 1.0.0, you shouldn't have that problem. To be more precise, 1.0.0

Re: [BETA RELEASE] Apache Cassandra 1.1.0-beta2 released

2012-03-29 Thread Sylvain Lebresne
On Thu, Mar 29, 2012 at 10:37 PM, Mohit Anchlia mohitanch...@gmail.com wrote: On Thu, Mar 29, 2012 at 1:32 PM, Sylvain Lebresne sylv...@datastax.com wrote: As the NEWS file says, only the version 1.0.3-1.0.5 are generating those cross-dc forwarding messages that are incompatible with 1.1.

Re: counter column family

2012-03-29 Thread Tyler Hobbs
On Tue, Mar 27, 2012 at 9:35 AM, puneet loya puneetl...@gmail.com wrote: now i want to have a field incrementing with every row insertion. how do i do it in cassandra?? There's nothing that will do it automatically. You need to increment it yourself. -- Tyler Hobbs DataStax

really bad select performance

2012-03-29 Thread Chris Hart
Hi, I have the following cluster: 136112946768375385385349842972707284580 ip address MountainViewRAC1Up Normal 1.86 GB 20.00% 0 ip address MountainViewRAC1Up Normal 2.17 GB 33.33%

AW: cassandra gui

2012-03-29 Thread Markus Wiesenbacher | Codefreun.de
Hi, yes you can insert data into cassandra with apollo, just try the demo center: http://www.codefreun.de/apolloUI/ You can login by just press the login-button (autologin) and play around with it. More info: http://codefreun.de/en/apollo-en If you miss any feature, please let me know! Best