Number of rows under one partition key

ws and selecting them all, counting 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?

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 o

Re: MailBox Impl

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, i

Re: Changing replication factor

ases happens 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 -

Changing replication factor

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 key

Re: how to handle join properly in this case

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

  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 Sub

Re: How to store large columns?

ith Wright.   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.or

Re: How to store large columns?

plit into multiple columns? > >Thanks > >2013/1/21 Sávio Teles > >> >> Thanks Keith Wright. >> >> >> 2013/1/21 Keith Wright >> >>> This may be helpful: >>> https://github.com/Netflix/astyanax/wiki/Chunked-Object-Store >>>

Re: How to store large columns?

  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 C

Re: Wide rows in CQL 3

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 i

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

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

important we didnt try from scratch again. Vegard Berget aaron morton : >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.

Moving data from one datacenter to another

e same aswell?  (Wouldn't 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 we

Re: Hinted Handoff runs every ten minutes

ery node runs a > 0 row hinted handoff every 10 minutes. N-1 nodes hint to the same node, > while that node hints to another node. > > > On Tue, Oct 30, 2012 at 1:35 PM, Vegard Berget wrote: >> >> Hi, >> >> I have the exact same problem with 1.16. H

Re: Hinted Handoff runs every ten minutes

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

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 -