Re: Cassandra's 2GB row limit and indexing

2010-05-27 Thread Jonathan Ellis
Yes, #16 (which is almost done for 0.7) will make this possible. On Wed, May 26, 2010 at 7:52 PM, Richard West wrote: > Hi all, > > I'm currently looking at new database options for a URL shortener in order > to scale well with increased traffic as we add new features. Cassandra seems > to be a g

Re: Cassandra's 2GB row limit and indexing

2010-05-26 Thread Jonathan Shook
The example is a little confusing. .. but .. 1) "sharding" You can square the capacity by having a 2-level map. CF1->row->value->CF2->row->value This means finding some natural subgrouping or hash that provides a good distribution. 2) "hashing" You can also use some additional key hashing to sp

Cassandra's 2GB row limit and indexing

2010-05-26 Thread Richard West
Hi all, I'm currently looking at new database options for a URL shortener in order to scale well with increased traffic as we add new features. Cassandra seems to be a good fit for many of our requirements, but I'm struggling a bit to find ways of designing certain indexes in Cassandra due to its