multitenant support with key spaces

2013-05-05 Thread Darren Smythe
How many keyspaces can you reasonably have? We have around 500 customers and expect that to double end of year. We're looking into C* and wondering if it makes sense for a separate KS per customer? If we have 1000 customers, so one KS per customer is 1000 keyspaces. Is that something C* can handle

1.2 tuning

2013-05-29 Thread Darren Smythe
Lots of possible "issues" with high write load and not sure if it means we need more nodes or if the nodes aren't tuned correctly. Were using 4 EC2 xlarge instances to support 4 medium instances. We're getting about 10k inserts/sec, but after about 10 minutes it goes down to about 7k/sec which see

Re: 1.2 tuning

2013-06-01 Thread Darren Smythe
If the amount of remaining time for compaction keeps going up, does this point to an overloaded node or an un-tuned node? On Thu, May 30, 2013 at 3:10 PM, Robert Coli wrote: > On Wed, May 29, 2013 at 2:38 PM, Darren Smythe > wrote: > > Were using the latest JNA and separate ephe

Re: 1.2 tuning

2013-06-03 Thread Darren Smythe
Is "setting live ratio to minimum of 1.0 instead of X" supposed to be rare? Because were getting it fairly consistently. On Sat, Jun 1, 2013 at 8:58 PM, Darren Smythe wrote: > If the amount of remaining time for compaction keeps going up, does this > point to an overloaded nod

Re: 1.2 tuning

2013-06-05 Thread Darren Smythe
Hi- On Mon, Jun 3, 2013 at 10:36 AM, Robert Coli wrote: > On Mon, Jun 3, 2013 at 8:54 AM, Darren Smythe > wrote: > > Is "setting live ratio to minimum of 1.0 instead of X" supposed to be > rare? > > Because were getting it fairly consistently. > &g

Billions of counters

2013-06-13 Thread Darren Smythe
We want to precalculate counts for some common metrics for usage. We have events, locations, products, etc. The problem is we have millions events/day, thousands of locations and millions of products. Were trying to precalculate counts for some common queries like 'how many times was product X pur

memtable overhead

2013-07-21 Thread Darren Smythe
Hi, How much overhead (in heap MB) does an empty memtable use? If I have many column families that aren't written to often, how much memory do these take up? TIA -- Darren

Re: memtable overhead

2013-07-22 Thread Darren Smythe
The way weve gone about our data models has resulted in lots of column families and just looking for guidelines about how much space each column table adds. TIA On Sun, Jul 21, 2013 at 11:19 PM, Darren Smythe wrote: > Hi, > > How much overhead (in heap MB) does an empty memtable use?