Re: Use-case: multi-instance webshop

2012-05-10 Thread R. Verlangen
@Aaron: Solr will probably be the solution to our problem. Thank you! @Radim: We already have a Cassandra cluster, we do not want to add an extra MongoDB cluster. At this moment the data would fit easily in SQL, but we don't know how our platform grows and we want to be prepared for the future. W

Re: get dinamicsnith info from php

2012-05-14 Thread R. Verlangen
I struggled with this before and decided to use HAProxy which suits my needs, you can read a little more about it at my personal blog: http://www.robinverlangen.nl/index/view/4fa902c1596cb-44a627/how-to-solve-the-pain-of-stateless-php-with-cassandra.html Good luck with it! 2012/5/14 Viktor Jevd

Re: is it possible to run cassandra process in client mode as smart proxy

2012-05-16 Thread R. Verlangen
Hi there, I'm using HAProxy for PHP projects to take care of this. It improved connection pooling enormous on the client side: with preserving failover capabilities. Maybe that is something for you to use in combination with PHP. Good luck! 2012/5/16 Piavlo > > Hi, > > I'm interested in using

Re: is it possible to run cassandra process in client mode as smart proxy

2012-05-16 Thread R. Verlangen
Yes, I'm aware of those issues however in our use case they don't cause any problems. But ... If there's something better out there I'm really curious: so I'll keep up with this thread. 2012/5/16 Piavlo > On 05/16/2012 01:24 PM, R. Verlangen wrote: > > Hi the

Re: Number of keyspaces

2012-05-21 Thread R. Verlangen
Yes, it does. However there's no real answer what's the limit: it depends on your hardware and cluster configuration. You might even want to search the archives of this mailinglist, I remember this has been asked before. Cheers! 2012/5/21 Luís Ferreira > Hi, > > Does the number of keyspaces af

Re: Number of keyspaces

2012-05-22 Thread R. Verlangen
ww.thelastpickle.com > > On 22/05/2012, at 6:58 PM, R. Verlangen wrote: > > Yes, it does. However there's no real answer what's the limit: it depends > on your hardware and cluster configuration. > > You might even want to search the archives of this mailinglist

Re: Data Versioning Support

2012-05-24 Thread R. Verlangen
Hi Felipe, There recently was a thread about ( http://www.mail-archive.com/user@cassandra.apache.org/msg22298.html ). The answer in short: no. However you can build your own data model to support it. Cheers! 2012/5/24 Felipe Schmidt > Doe's Cassandra support data versioning? > > I'm trying to

Re: Finding whether a new node is successfully added or not

2012-06-04 Thread R. Verlangen
Hi there, You can check the ring info with nodetool. Furthermore you can take a look at the streaming statistics: lots of pending indicates a node that is still receiving data from it's seed(s). As far as I'm aware of the seed value will be read upon start: so a restart is required. Good luck. 2

Re: Adding a new node to Cassandra cluster

2012-06-04 Thread R. Verlangen
Hi there, When you speak to one node it will internally redirect the request to the proper node (local / external): but you won't be able to failover on a crash of the localhost. For adding another node to the connection pool you should take a look at the documentation of your java client. Good l

Re: Adding a new node to Cassandra cluster

2012-06-04 Thread R. Verlangen
> > I am using Thrift API and I am not able to find anything on the internet > about how to configure it for multiple nodes. I am not using any proper > client like Hector. > > ** ** > > Prakrati Agrawal | Developer - Big Data(I&D)| 9731648376 | > www.mu-sigm

Re: Adding a new node to Cassandra cluster

2012-06-04 Thread R. Verlangen
> > If you use thrift API, you have to maintain lot of low level code by > yourself which is already being polished by HLC hector, pycassa also with > HLC your can easily switch between thrift and growing CQL. > > On Mon, Jun 4, 2012 at 3:00 PM, R. Verlangen wrote: > > Y

Re: repair

2012-06-04 Thread R. Verlangen
The "repair -pr" only repairs the nodes primary range: so is only usefull in day to day use. When you're recovering from a crash use it without -pr. 2012/6/4 Romain HARDOUIN > > Run "repair -pr" in your cron. > > Tamar Fraenkel a écrit sur 04/06/2012 13:44:32 : > > > Thanks. > > > > I actually

Re: nodetool repair -pr enough in this scenario?

2012-06-05 Thread R. Verlangen
In your case -pr would be just fine (see Viktor's explanation). 2012/6/5 Viktor Jevdokimov > Understand simple mechanics first, decide how to act later. > > ** ** > > Without –PR there’s no difference from which host to run repair, it runs > for the whole 100% range, from start to end, the

Re: about multitenant datamodel

2012-06-05 Thread R. Verlangen
Every CF has a certain amount of overhead in memory. It's just not how Cassandra is designed to be used. Maybe you could think of a way to smash data down to indices and entities. With an abstraction layer you can store practically anything in Cassandra. 2012/6/5 Toru Inoko > IMHO a model that a

Re: Why Hector is taking more time than Thrift

2012-06-06 Thread R. Verlangen
Hector is a higher-level client that provides some abstraction and an easy to use interface. The Thrift API is pretty raw. So for most cases the Hector client would be the best choice; except for use-cases where the ultimate performance is a requirement (resulting in lots of more maintenance betwee

Re: Problem in getting data from a 2 node cluster

2012-06-06 Thread R. Verlangen
Did you run repair on the new node? 2012/6/6 Prakrati Agrawal > Dear all, > > ** ** > > I had a 1 node cluster. Then I added 1 more node to it. ** ** > > When I ran my query on 1 node cluster I got all my data but when I ran my > query on the 2 node cluster (Hector code) I am not getting th

Re: Problem in getting data from a 2 node cluster

2012-06-06 Thread R. Verlangen
a from a 2 node cluster > > ** ** > > What does repair do? > > ** ** > > Prakrati Agrawal | Developer - Big Data(I&D)| 9731648376 | > www.mu-sigma.com > > ** ** > > *From:* R. Verlangen [mailto:ro...@us2.nl] > *Sent:* Wednesday, June 06, 2

Re: Offset in slicequeries for pagination

2012-06-11 Thread R. Verlangen
I solved this with creating a manual index with as column keys integers and column values the uuid's of the results. Then run a slicequery to determine the batch to fetch. 2012/6/11 Cyril Auburtin > using 10 results maximum per page, > > to go directly to 14th page, there is no offset=141 possi

Re: portability between enterprise and community version

2012-06-13 Thread R. Verlangen
@Viktor: I've read/heard this many times before, however I've never seen a real explanation. Java is cross platform. If Cassandra runs properly on both Linux as Windows clusters: why would it be impossible to communicate? Of course I understand the disadvantages of having a combined cluster. 2012/

<    1   2