Re: Consistency Level One Question

2014-02-21 Thread Duncan Sands
Hi Graham, On 21/02/14 07:54, graham sanderson wrote: Note also; that reading at ONE there will be no read repair, since the coordinator does not know that another replica has stale data (remember at ONE, basically only one node is asked for the answer). I don't think this is right. My

Re: Intermittent long application pauses on nodes

2014-02-21 Thread Joel Samuelsson
What happens if a ParNew is triggered while CMS is running? Will it wait for the CMS to finish? If so, that would be the eplanation of our long ParNew above. Regards, Joel 2014-02-20 16:29 GMT+01:00 Joel Samuelsson samuelsson.j...@gmail.com: Hi Frank, We got a (quite) long GC pause today on

TSocket read 0 bytes cqlsh error

2014-02-21 Thread Kasper Middelboe Petersen
Hi, I'm getting a TSocket read 0 bytes error in cqlsh when doing a SELECT * FROM tbl. Anyone else experienced this? It's a single node cluster running locally. I've tried doing a nodetool cleanup but that didn't solve the issue. Version information: INFO [main] 2014-02-21 10:20:25,224

Re: Performance problem with large wide row inserts using CQL

2014-02-21 Thread Sylvain Lebresne
On Thu, Feb 20, 2014 at 10:49 PM, Rüdiger Klaehn rkla...@gmail.com wrote: Hi Sylvain, I applied the patch to the cassandra-2.0 branch (this required some manual work since I could not figure out which commit it was supposed to apply for, and it did not apply to the head of cassandra-2.0).

Re: TSocket read 0 bytes cqlsh error

2014-02-21 Thread Kasper Middelboe Petersen
Looks like the problem is caused by: https://issues.apache.org/jira/browse/CASSANDRA-5202 On Fri, Feb 21, 2014 at 10:26 AM, Kasper Middelboe Petersen kas...@sybogames.com wrote: Hi, I'm getting a TSocket read 0 bytes error in cqlsh when doing a SELECT * FROM tbl. Anyone else experienced

Re: Consistency Level One Question

2014-02-21 Thread graham sanderson
My bad; should have checked the code: /** * This function executes local and remote reads, and blocks for the results: * * 1. Get the replica locations, sorted by response time according to the snitch * 2. Send a data request to the closest replica, and digest requests

Re: Performance problem with large wide row inserts using CQL

2014-02-21 Thread Edward Capriolo
The main issue is that cassandra has two of everything. Two access apis, two meta data systems, and two groups of users. Those groups of users using the original systems thrift, cfmetadata, and following the advice of three years ago have been labled obsolete (did you ever see that twighlight

Re: Consistency Level One Question

2014-02-21 Thread Drew Kutcharian
Thanks, this clears things up. On Feb 21, 2014, at 6:47 AM, Edward Capriolo edlinuxg...@gmail.com wrote: When you write at one, as soon as one node acknowledges the write the ack is returned to the client. This means if you quickly read from aome other node 1)you may get the result

Re: How do you remote backup your cassandra nodes ?

2014-02-21 Thread user 01
I'm wanting to back up my data to amazon S3. Can anyone please tell about which directories should I copy to the remote location for backup so as to restore the entire Cassandra data in the event of any failures? On Fri, Feb 21, 2014 at 1:43 AM, user 01 user...@gmail.com wrote: What is your

Re: How do you remote backup your cassandra nodes ?

2014-02-21 Thread Colin Blower
You might want to use the Priam tool for backups. https://github.com/Netflix/Priam If you don't want to use Priam, you should read this Datastax entry on backup and restore. http://www.datastax.com/docs/1.0/operations/backup_restore On 02/21/2014 11:19 AM, user 01 wrote: I'm wanting to back up

Re: How do you remote backup your cassandra nodes ?

2014-02-21 Thread Robert Coli
On Thu, Feb 20, 2014 at 12:13 PM, user 01 user...@gmail.com wrote: What is your strategy/tools set to backup your Cassandra nodes, apart from from cluster replication/ snapshots within cluster? https://github.com/synack/tablesnap =Rob

Re: Performance problem with large wide row inserts using CQL

2014-02-21 Thread Yogi Nerella
Sylvain, I am trying ccm to install and it does from source directory, I have tried 2.0.4/3/2/1 and 1.2.15, all of them are reporting the same failure after 127 records inserted. I am using 1.56.34 and 1.56.38 client both reports the same issue. Is something wrong with the client or the server,

Re: Performance problem with large wide row inserts using CQL

2014-02-21 Thread Yogi Nerella
I am using CCM to install the servers, it is bringing in the source code, is there any option for CCM which I can set only to download the binary, just to make sure it is not bringing in the working copy of the code. I am using the following statements to create Keyspace and table definition.

abusing cassandra's multi DC abilities

2014-02-21 Thread Jonathan Haddad
Upfront TLDR: We want to do stuff (reindex documents, bust cache) when changed data from DC1 shows up in DC2. Full Story: We're planning on adding data centers throughout the US. Our platform is used for business communications. Each DC currently utilizes elastic search and redis. A message

Re: How do you remote backup your cassandra nodes ?

2014-02-21 Thread user 01
Thanks for the links. @Colin: The Datastax doc about backup/restore (the one you linked to) is more about onsite backups, but not for remote backups. It did not described about what directories should I copy for backup to a remote location. After taking the snapshots should I copy all the

Update multiple rows in a CQL lightweight transaction

2014-02-21 Thread Clint Kelly
Folks, Does anyone know how I can modify multiple rows at once in a lightweight transaction in CQL3? I saw the following ticket: https://issues.apache.org/jira/browse/CASSANDRA-5633 but it was not obvious to me from the comments how (or whether) this got resolved. I also couldn't find

cell-level security for cassandra ?

2014-02-21 Thread Frank Hsueh
has there been any thought about adding cell-level security to Cassandra ? something similar to: http://accumulo.apache.org/1.5/accumulo_user_manual.html#_security ? -- Frank Hsueh | frank.hs...@gmail.com

Fwd: Delivery Status Notification (Failure)

2014-02-21 Thread Spencer Brown
I'm trying to get CQL going for my CentOS 5 cassandra PHP platform. I've installed thrift, but when I try to make cassandra-pdo or YACassandraPDO for that matter, none of the tests pass. And when I install it with PHP, phpinfo still doesn't show it loading and it doesn't work. Any ideas would

List support in Net::Async::CassandraCQL ?

2014-02-21 Thread Jacob Rhoden
This perl library has been extremely useful for scripting up data migrations. I wonder if anyone knows of the easiest way to use lists with this driver? Throwing a perl array in as a parameter doesn’t work as is: my $q = $cass-prepare(update contact set name=?, address=? where uuid=?)-get;