Re: Replacing disks

2016-02-28 Thread Alain RODRIGUEZ
I wrote that a few days ago: http://thelastpickle.com/blog/2016/02/25/removing-a-disk-mapping-from-cassandra.html I believe this might help you. C*heers, --- Alain Rodriguez - al...@thelastpickle.com France The Last Pickle - Apache Cassandra Consulting http

Re: How to complete bootstrap with exception due to stream failure?

2016-02-28 Thread Jason Kania
Thanks for the reference to nodetool resetlocalschema as that will come in handy in the future. Thanks also for the reference to https://issues.apache.org/jira/browse/CASSANDRA-11050 which seems related, but I am not sure. I was doing a bootstrapping on 192.168.10.10 and it had nothing on it to

Re: How to complete bootstrap with exception due to stream failure?

2016-02-28 Thread Paulo Motta
Were the columns sensor.lastEvaluation and sensordb.lastCheckTime dropped by any chance? If so, you might be hitting https://issues.apache.org/jira/browse/CASSANDRA-11050, fixed in upcoming 3.4. If that's the case, you may want to check if nodes other than 192.168.10.10 have the dropped columns in

Re: Cassandra Ussages

2016-02-28 Thread Jonathan Haddad
Cassandra is primarily used as an OLTP database, not analytics. You should watch this 30 min video discussing Cassandra core concepts (coming from a relational background): https://academy.datastax.com/courses/ds101-introduction-cassandra On Sun, Feb 28, 2016 at 5:40 AM Andrés Ivaldi wrote: > Hel

Re: Replacing disks

2016-02-28 Thread Clint Martin
Code wise, I am not completely familiar with what accomplishes the behavior. But my understanding and experience is that Cass 2.1 picks the drive with the most free space when picking a destination for a compaction operation. (This is an overly simplistic description. Reality is always more nuance

Re: Replacing disks

2016-02-28 Thread Michał Łowicki
On Sun, Feb 28, 2016 at 4:00 PM, Clint Martin < clintlmar...@coolfiretechnologies.com> wrote: > Your plan for replacing your 200gb drive sounds good to me. Since you are > running jbod, I wouldn't worry about manually redistributing data from your > other disk to the new one. Cassandra will do tha

Re: Replacing disks

2016-02-28 Thread Clint Martin
Your plan for replacing your 200gb drive sounds good to me. Since you are running jbod, I wouldn't worry about manually redistributing data from your other disk to the new one. Cassandra will do that for you as it performs compaction. While you're doing the drive change, you need to complete the s

Replacing disks

2016-02-28 Thread Michał Łowicki
Hi, I've two disks on single box (500GB + 200GB). data_file_directories in cassandra.yaml has two entries. I would like to replace 200GB with 500GB as it's running out of space and to align it with others we've in the cluster. The plan is to stop C*, attach new disk, move data from 200GB to new on

Cassandra Ussages

2016-02-28 Thread Andrés Ivaldi
Hello, At my work we are looking for new technologies for an Analysis Engine, and we are evaluating differents technologies one of them is Cassandra as our Data repository. Now we can execute query analysis agains an OLAP Cube and RDBMS, using MSSQL as our data repository. Cube is obsolete and SQL