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

2012-05-16 Thread Mike Peters
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 other one gets

Re: Using elasticsearch on cassandra nodes

2011-10-24 Thread Mike Peters
and 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. Presently we have SOLR in place

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 values. We have tens of thousands

Cassandra 0.8 Counters Inverted Index?

2011-09-30 Thread Mike Peters
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:

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,

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

2010-09-03 Thread Mike Peters
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 cassan...@softwareprojects.com wrote: Hi, We're in the process of migrating 4,000 MySQL client

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

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

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: 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 http://github.com/tjake/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,

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

2010-09-02 Thread Mike Peters
from yaml On Thu, Sep 2, 2010 at 7:53 AM, Mike Peters cassan...@softwareprojects.com 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

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

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 http://www.apache.org/legal/3party.html, 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

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

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:

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

Re: Thrift + PHP: help!

2010-08-30 Thread Mike Peters
throw $this-last_exception; - Juho Mäkinen On Mon, Aug 30, 2010 at 3:48 PM, Mike Peters cassan...@softwareprojects.com wrote: 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

Re: Client developer mailing list

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