Does nodetool repair stop the node to answer requests ?

2015-01-22 Thread SEGALIS Morgan
I have been searching all over documentation but could not find an straight answer. For a project I'm using a single node cassandra database (so far)... It has always worked well, but I'm reading everywhere that I should do a nodetool repair at least every week, especially if I delete rows, which

Re: Does nodetool repair stop the node to answer requests ?

2015-01-22 Thread SEGALIS Morgan
what do you mean by "operating correctly" ? I only use dynamic columns if that helps... 2015-01-22 19:10 GMT+01:00 Robert Coli : > On Thu, Jan 22, 2015 at 9:36 AM, SEGALIS Morgan > wrote: > >> So I wondered, does a nodetool repair make the server stop serving >>

Re: Does nodetool repair stop the node to answer requests ?

2015-01-22 Thread SEGALIS Morgan
ot your server, at which > point your cluster will be down. If you want high availability, you should > use a 3 nodes cluster with RF = 3. > > On 22 January 2015 at 18:10, Robert Coli wrote: > >> On Thu, Jan 22, 2015 at 9:36 AM, SEGALIS Morgan >> wrote: >> >>>

Re: Does nodetool repair stop the node to answer requests ?

2015-01-22 Thread SEGALIS Morgan
Thanks, this is a straight forward answer, exactly what I needed ! 2015-01-22 19:22 GMT+01:00 Jan : > Running a 'nodetool repair' will 'not' bring the node down. > > Your question: > does a nodetool repair make the server stop serving requests, or does it > just use a lot of ressources but sti

Re: Does nodetool repair stop the node to answer requests ?

2015-01-22 Thread SEGALIS Morgan
Don't think it is near failure, it uses only 3% of the CPU and 40% of the RAM if that is what you meant. 2015-01-22 19:58 GMT+01:00 Robert Coli : > On Thu, Jan 22, 2015 at 10:53 AM, SEGALIS Morgan > wrote: > >> what do you mean by "operating correctly" ? >>

Cassandra row ordering best practice Modeling

2015-01-22 Thread SEGALIS Morgan
I have a column family that store articles. I'll need to get those articles from the most recent to the oldest, getting them from Country, and of course the ability to limit the number of fetched articles. I though about another ColumnFamily "ArticlesByDateAndCountry" with dynamic columns The Key

Re: Cassandra row ordering best practice Modeling

2015-01-22 Thread SEGALIS Morgan
Sorry, I copied/pasted the question from another platform where you don't generally say hello, So : Hello everyone, 2015-01-22 20:19 GMT+01:00 SEGALIS Morgan : > I have a column family that store articles. I'll need to get those > articles from the most recent to the oldest, g

Re: Cassandra row ordering best practice Modeling

2015-01-22 Thread SEGALIS Morgan
le. > The only thing I can see is how to go back in time to fetch articles from > previous buckets (previous days). It is possible to have 0 article for a > country for a day ? > > > On Thu, Jan 22, 2015 at 8:23 PM, SEGALIS Morgan > wrote: > >> Sorry, I copied/pasted the q

Re: Cassandra row ordering best practice Modeling

2015-01-22 Thread SEGALIS Morgan
but I've seen some code that misses this > scenario and ends up in an infinite loop back in time ... > > On Thu, Jan 22, 2015 at 8:41 PM, SEGALIS Morgan > wrote: > >> Hi DuyHai, >> >> if there is 0 article, the row will obviously not exist I guess... (no >&g

Which Topology fits best ?

2015-01-25 Thread SEGALIS Morgan
Hi everyone, I need one more time your precious advice. I would like to create a 2 nodes cluster, each node are on a different DataCenter, but with the same provider, ping between the 2 servers is fast: ~0,5 ms, and the bandwidth is great: ~ 1GB/s is, org.apache.cassandra.locator.SimpleStrategy w

Re: Which Topology fits best ?

2015-01-26 Thread SEGALIS Morgan
However I guess it can be easily changed ? doesn' it ? 2015-01-25 20:18 GMT+01:00 mck : > NetworkTopogolyStrategy gives you a better horizon and more flexibility > as you scale out, at least once you've gone past small cluster problems > like wanting RF=3 in a 4 node two dc cluster. > > IMO I'd g

Re: Which Topology fits best ?

2015-01-26 Thread SEGALIS Morgan
Thank you both for your precious advices ! 2015-01-26 12:30 GMT+01:00 mck : > > > However I guess it can be easily changed ? > > > that's correct. > -- Morgan SEGALIS

Using Cassandra for geospacial search

2015-01-26 Thread SEGALIS Morgan
Hi everyone, I wanted to know if someone has a feedback using geoHash algorithme with cassandra ? I will have to create a "nearby" functionnality soon, and I really would like to do it with cassandra for it's scalability, otherwise the smart choice would be MongoDB apparently. Is Cassandra can b

Re: Using Cassandra for geospacial search

2015-01-26 Thread SEGALIS Morgan
ing ready for geo-oriented interactions with C*; our plan is to > use DSE Solr integration for this purpose. > > On Mon, Jan 26, 2015 at 8:47 AM, SEGALIS Morgan > wrote: > >> Hi everyone, >> >> I wanted to know if someone has a feedback using geoHash algorithme wit

Re: Using Cassandra for geospacial search

2015-01-26 Thread SEGALIS Morgan
The news I guess would be to have it for free. I do not use commercial versions. I wasn't aware of it though. Le lundi 26 janvier 2015, Robert Coli a écrit : > On Mon, Jan 26, 2015 at 9:29 AM, SEGALIS Morgan > wrote: > >> That's actually GREAT news !! + Solr will