Number of rows under one partition key

2014-05-16 Thread Vegard Berget
them and selecting individual rows (with both clientid and id) and it seems fine, but I want to ask to be sure that I am on the right track.   Best regards,Vegard Berget

Re: Why don't you start off with a “single small” Cassandra server as you usually do it with MySQL?

2013-09-18 Thread Vegard Berget
Hi, The idea behind Cassandra is not the same as for MySQL.  First of all you can't get fault tolerance with one node.  I don't think Cassandra nodes are more prone to be unavailable, but by using replication you can get more availability right away.  If you have multiple instances when you start

Re: MailBox Impl

2013-07-19 Thread Vegard Berget
Hi, 1)  Counters will probably work for this.  Our experience with counters is that it is very accurate.  But read up on how repair/inconsistencies etc is handled.2)  You can not, as far as i know at least, have ttl on part of a counter.  What you can do, depending on how accurate it needs to be,

Re: Changing replication factor

2013-06-17 Thread Vegard Berget
on the other node and that node will have the correct number?  I am just curious, as some minor errors in the counters would be no problem for us. .vegard, - Original Message - From: user@cassandra.apache.org To:, Vegard Berget Cc: Sent:Fri, 14 Jun 2013 17:20:26 -0700 Subject:Re: Changing

Changing replication factor

2013-06-10 Thread Vegard Berget
Hi, If one increases the replication factor of a keyspace and then do a repair, how will this affect the performance of the affected nodes? Could we risk the nodes being (more or less) unresponsive while repair is going on?  The nodes I am speaking of contains ~100gb of data.  Also, some of the

Re: how to handle join properly in this case

2013-05-27 Thread Vegard Berget
Hi, I am no expert, but a couple of suggestions:1)  Remember that writes are very fast i Cassandra, so don't be afraid to store more information than you would in an Sql-ish server. 2)  It would be better with an example, but again - by storing more than you would in an sql-schema, would you still

Re: cassandra vs. mongodb quick question

2013-02-18 Thread Vegard Berget
  Just out of curiosity : When using compression, does this affect this one way or another?  Is 300G (compressed) SSTable size, or total size of data?    .vegard, - Original Message - From: user@cassandra.apache.org To: Cc: Sent:Mon, 18 Feb 2013 08:41:25 +1300

Re: How to store large columns?

2013-01-22 Thread Vegard Berget
.   2013/1/21 Keith Wright This may be helpful:  https://github.com/Netflix/astyanax/wiki/Chunked-Object-Store [6] From: Vegard Berget Reply-To: user@cassandra.apache.org [8] , Vegard Berget Date: Monday, January 21, 2013 8:35 AM To: user@cassandra.apache.org [11] Subject: Re: How

Re: How to store large columns?

2013-01-21 Thread Vegard Berget
  Hi, You could split it into multiple columns on the client side:   RowKeyData: Part1: [1mb], Part2: [1mb], Part3: [1mb]...PartN[1mb] Now you can use multiple get() in parallell to get the files back and then join them back to one file. I _think_ maybe the new

Re: How to store large columns?

2013-01-21 Thread Vegard Berget
? It is better to split into multiple columns? Thanks 2013/1/21 Sávio Teles savio.te...@lupa.inf.ufg.br Thanks Keith Wright. 2013/1/21 Keith Wright kwri...@nanigans.com This may be helpful: https://github.com/Netflix/astyanax/wiki/Chunked-Object-Store From: Vegard Berget p...@fantasista.no

Re: Wide rows in CQL 3

2013-01-10 Thread Vegard Berget
Thanks for explaining, Sylvain.You say that it is not a mandatory one, how long could we expect it to be not mandatory?I think the new CQL stuff is great and I will probably use it heavily.  I understand the upgrade path, but my question is if I should start planning for an all-CQL future, or if I

Re: How long does it take for a write to actually happen?

2013-01-09 Thread Vegard Berget
Hi, The timestamp is generated on the client side, so actually if you have two clients which sets the timestamp from the system time, you will experience trouble.  I don't know how Astyanax does it, and I am not sure if it would cause trouble when getting data?  Could it be that the Process server

Re: Moving data from one datacenter to another

2012-12-21 Thread Vegard Berget
. As it was not important we didnt try from scratch again. Vegard Berget aaron morton aa...@thelastpickle.com: Sounds about right, i've done similar things before. Some notes… * I would make sure repair has completed on the source cluster before making changes. I just like to know data is distributed. I

Moving data from one datacenter to another

2012-12-19 Thread Vegard Berget
a repair correct that later?) 2)  Could data files have any name?  Could we, to avoid a filename crash, just substitute the numbers with for example XXX in the data-files? 3)  Is this really a sane way to do things?   Suggestions are most welcome! Regards Vegard

Re: Hinted Handoff runs every ten minutes

2012-11-12 Thread Vegard Berget
. On Tue, Oct 30, 2012 at 1:35 PM, Vegard Berget wrote: Hi, I have the exact same problem with 1.16. HintsColumnFamily consists of one row (Rowkey 00, nothing more). The problem started after upgrading from 1.1.4 to 1.1.6. Every ten minutes HintedHandoffManager starts and finishes

Re: Hinted Handoff runs every ten minutes

2012-10-30 Thread Vegard Berget
Hi, I have the exact same problem with 1.1.6.  HintsColumnFamily consists of one row (Rowkey 00, nothing more).   The problem started after upgrading from 1.1.4 to 1.1.6.  Every ten minutes HintedHandoffManager starts and finishes  after sending 0 rows.   .vegard, - Original Message -

Re: Hinted Handoff runs every ten minutes

2012-10-30 Thread Vegard Berget
Hi, I have the exact same problem with 1.1.6.  HintsColumnFamily consists of one row (Rowkey 00, nothing more).   The problem started after upgrading from 1.1.4 to 1.1.6.  Every ten minutes HintedHandoffManager starts and finishes  after sending 0 rows.   .vegard, - Original Message -