Cassandra Hector failover + load balancing not as expected with version 1.0-5

2012-07-22 Thread Roshan
Hi Currently I am using Cassandra 1.0.6 with Hector 1.0-5 in production, and now in the process of upgrading current Cassandra cluster to 1.1.2 version. As the first upgrade process, I select one node from local development Cassandra cluster (3 node 1.0.6 and RF=3) and execute the nodetool drain

Schema advice: (Single row or multiple row!?) How do I store millions of columns when I need to read a set of around 500 columns at a single read query using column names ?

2012-07-22 Thread Ertio Lew
I want to store hundred of millions of columns(containing id1 to id2 mappings) in the DB & at any single time, retrieve a set of about 200-500 columns based on the column names(id1) if they are in single row or using rowkeys if each column is stored in a unique row. If I put them in a single row: