Re: how can we get (a lot) more performance from cassandra

2012-05-16 Thread Mike Peters
"wrap" your reads with memcache (or redis), so that the bulk of your reads can be served from memory. Thanks, Mike Peters On 5/16/2012 3:59 PM, Yiming Sun wrote: Hello, I asked the question as a follow-up under a different thread, so I figure I should ask here instead in case the

Re: Using elasticsearch on cassandra nodes

2011-10-24 Thread Mike Peters
nd it wasn't enough. We ended up upgrading to 48gb of memory, allocating 15gb to Cassandra, 15gb to ElasticSearch and haven't had any issues since. Thanks, Mike Peters On 10/18/2011 9:14 AM, Brian O'Neill wrote: Anthony, We've been looking at elastic search as well. Present

Re: Cassandra 0.8 Counters Inverted Index?

2011-10-02 Thread Mike Peters
Any ideas? Thanks, Mike Peters On 10/1/2011 1:19 AM, Mike Peters wrote: Hi, We're using Cassandra 0.8 counters in production and loving it! One issue we're running into is we need an efficient mechanism to retrieve the "top 100" results, sorted by count value

Cassandra 0.8 Counters Inverted Index?

2011-09-30 Thread Mike Peters
reads and deletes are killing our performance. Any one has any ideas about a more efficient way to utilize counters and support "top 100" results? Looking forward to any ideas and feedback you can share. Thanks, Mike Peters

Re: buggy secondary indexes?

2010-09-13 Thread Mike Peters
Sounds like you may need to patch your php thrift See http://www.softwareprojects.com/resources/programming/t-php-thrift-library-for-cassandra-1982.html On 9/13/2010 5:09 AM, Petr Odut wrote: Hi, let's have CF User with indexed column email. Now i insert new user: "user":{"email":"s...@emai

Re: skip + limit support in GetSlice

2010-09-05 Thread Mike Peters
Hi Michal, Did you read the PDF Stu sent over, start to finish? There are several different approaches described there. With Cassandra, what we found works best for pagination: * Keep a separate 'total_records' count and increment/decrement it on every insert/delete * When getting slices, pa

Re: 4k keyspaces... Maybe we're doing it wrong?

2010-09-03 Thread Mike Peters
edin <http://in.linkedin.com/in/vineetdaniel> | Twitter <https://twitter.com/vineetdaniel> On Fri, Sep 3, 2010 at 2:58 PM, Mike Peters <mailto:cassan...@softwareprojects.com>> wrote: Very interesting. Thank you So it sounds like other than being able to quickly

Re: 4k keyspaces... Maybe we're doing it wrong?

2010-09-03 Thread Mike Peters
guration is per keyspace/column family, so you cannot run that many keyspaces. This page has some more information http://wiki.apache.org/cassandra/MultiTenant Aaron On 03 Sep, 2010,at 01:25 PM, Mike Peters wrote: Hi, We're in the process of migrating 4,000 MySQL client databas

Re: question about Cassandra error

2010-09-02 Thread Mike Peters
Simon, See this page: http://www.riptano.com/blog/whats-new-cassandra-065 "Because of licensing issues , we can't distribute JNA with Cassandra, so you must manually add it to the Cassandra lib/ directory or otherwise place it on the classpath." On 9

4k keyspaces... Maybe we're doing it wrong?

2010-09-02 Thread Mike Peters
Hi, We're in the process of migrating 4,000 MySQL client databases to Cassandra. All database schemas are identical. With MySQL, we used to provision a separate 'database' per each client, to make it easier to shard and move things around. Does it make sense to migrate the 4,000 MySQL dat

Re: Migrate data from 0.7 pre-release to 0.7 Beta

2010-09-02 Thread Mike Peters
d re-import from yaml On Thu, Sep 2, 2010 at 7:53 AM, Mike Peters wrote: Hi, Is there a way to migrate data from a 0.7 pre-release build (June 30, 2010) to the latest 0.7 beta 1? Replacing the binaries and starting-up Cassandra, throws the "are you upgrading a pre-release version"

Re: Looking for something like "like" of mysql.

2010-09-02 Thread Mike Peters
Cassandra doesn't support adhoc queries, like what you're describing I recommend looking at Lucandra On 9/2/2010 12:27 PM, Anuj Kabra wrote: I am working with cassandra-0.6.4. I am working on mail retreival problem. We have the metadata of mail like sender, r

Migrate data from 0.7 pre-release to 0.7 Beta

2010-09-02 Thread Mike Peters
Hi, Is there a way to migrate data from a 0.7 pre-release build (June 30, 2010) to the latest 0.7 beta 1? Replacing the binaries and starting-up Cassandra, throws the "are you upgrading a pre-release version" error and dies. Thanks, Mike

Re: Client developer mailing list

2010-08-30 Thread Mike Peters
I'm in! We really need a better PHP Thrift

Re: Thrift + PHP: help!

2010-08-30 Thread Mike Peters
es< 4); // Give up and throw the last exception throw $this->last_exception; - Juho Mäkinen On Mon, Aug 30, 2010 at 3:48 PM, Mike Peters wrote: Juho, do you mind sharing your implementation with the group? We'd love to help as well with rewritin

Re: TException: Error: TSocket: timed out reading 1024 bytes from 10.1.1.27:9160

2010-08-30 Thread Mike Peters
Hi guys, There are several patches you need to apply to Thrift to completely resolve all timeout errors. Here's a list of them along with a link to download a patched thrift library: http://www.softwareprojects.com/resources/programming/t-php-thrift-library-for-cassandra-1982.html http://www.

Re: cassandra for a inbox search with high reading qps

2010-08-30 Thread Mike Peters
Chen, Have you considered using http://www.slideshare.net/otisg/lucandra Lucandra for Inbox search? We have a similar setup and are currently looking into using Lucandra over implementing the searching ourselves with pure Cassandra. -- View this message in context: http://cassandra-user-in

Re: Thrift + PHP: help!

2010-08-30 Thread Mike Peters
Juho, do you mind sharing your implementation with the group? We'd love to help as well with rewriting the thrift interface, specificaly TSocket.php which seems to be where the majority of the problems are lurking. Has anyone tried compiling native thrift support as described here https://wik