Writing to multiple tables

Hi, Are Cassandra Batch statements http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/batch_r.html the recommended way for updating same information in multiple tables? For example if I have the following tables: person_by_dob person_by_ssn person_by_lastname Then

Consistency Level for Atomic Batches

Is consistency level honored for batch statements? If I have 100 insert/update statements in my batch and use LOCAL_QUORUM consistency, will the control from coordinator return only after a local quorum update has been done for all the 100 statements? Or is it different ? Thanks Vish

Re: Consistency Level for Atomic Batches

at 8:00 AM, Viswanathan Ramachandran vish.ramachand...@gmail.com wrote: Is consistency level honored for batch statements? If I have 100 insert/update statements in my batch and use LOCAL_QUORUM consistency, will the control from coordinator return only after a local quorum update has been

Re: Scala driver

I haven't used this scala driver, but may possibly explore soon. https://github.com/websudosuk/phantom https://websudosuk.github.io/phantom/ Mentioned at at: http://planetcassandra.org/client-drivers-tools/#Scala http://www.datastax.com/download#dl-community-drivers On Mon, Sep 1, 2014 at

Re: LOCAL_QUORUM without a replica in current data center

Sorry for the spam - but I wanted to double check if anyone had experience with such a scenario. Thanks. On Sun, Aug 17, 2014 at 7:11 PM, Viswanathan Ramachandran vish.ramachand...@gmail.com wrote: Hi, How does LOCAL_QUORUM read/write behave when the data center on which query

LOCAL_QUORUM without a replica in current data center

Hi, How does LOCAL_QUORUM read/write behave when the data center on which query is executed does not have a replica of the keyspace? Does it result in an error or can it be configured to do LOCAL_QUORUM on the nearest data center (as depicted by the dynamic snitch) which has the replicas ? We

Nodetool Repair questions

Some questions on nodetool repair. 1. This tool repairs inconsistencies across replicas of the row. Since latest update always wins, I dont see inconsistencies other than ones resulting from the combination of deletes, tombstones, and crashed nodes. Technically, if data is never deleted from

Re: Nodetool Repair questions

repairs? Mark On Tue, Aug 12, 2014 at 10:06 PM, Viswanathan Ramachandran vish.ramachand...@gmail.com wrote: Some questions on nodetool repair. 1. This tool repairs inconsistencies across replicas of the row. Since latest update always wins, I dont see inconsistencies other than ones

Re: Nodetool Repair questions

consistency and you don't delete data. 2.Performance depends on size of data each node has. It's very difficult to predict. It may take days. Thank you, Andrey On Tue, Aug 12, 2014 at 2:06 PM, Viswanathan Ramachandran vish.ramachand...@gmail.com wrote: Some questions on nodetool

Is nodetool cleanup necessary on nodes of different data center when new node is added

I plan to have a multi data center Cassandra 2 setup with 2-4 nodes per data center and several 10s of data centers. We have keyspaces replicated on a certain number of nodes on *each* data center. Essentially, each data center has a logical ring that covers all token ranges. We have a vnode based