Re: Data Modeling- another question

2012-08-28 Thread Guy Incognito
i would respectfully disagree, what you have said is true but it really depends on the use case. 1) do you expect to be doing updates to individual fields of an item, or will you always update all fields at once? if you are doing separate updates then the first is definitely easier to handle

Re: Data Modeling- another question

2012-08-28 Thread samal
yes, you are right, it depend on use cases. I suggested it is a better choice not only choice. JSON will be better if any filed change re-write whole data without reading. I tend to use JSON more, where my data does not change or very rarely, Like storing demoralized JSON data for analytic

Re: Commit log periodic sync?

2012-08-28 Thread rubbish me
Thanks again Aaron. I think case I would not expect to see data lose. If you are still in a test scenario can you try to reproduce the problem ? If possible can you reproduce it with a single node ? We will try that later this week. We did the same exercise this week, this time we

Re: Cassandra 1.1.4 RPM required

2012-08-28 Thread Hiller, Dean
You are probably inside a company and the company has a proxy which is doing basic auth is my guess…try your company username /password or do it from home. Dean From: aaron morton aa...@thelastpickle.commailto:aa...@thelastpickle.com Reply-To:

Re: Automating nodetool repair

2012-08-28 Thread Edward Capriolo
You can consider adding -pr. When iterating through all your hosts like this. -pr means primary range, and will do less duplicated work. On Mon, Aug 27, 2012 at 8:05 PM, Aaron Turner synfina...@gmail.com wrote: I use cron. On one box I just do: for n in node1 node2 node3 node4 ; do

Re: Cassandra upgrade 1.1.4 issue

2012-08-28 Thread Adeel Akbar
I have upgraded jdk from 1.6_u14 to 1.7_u06 and now its working. Thanks Regards *Adeel**Akbar* On 8/24/2012 8:50 PM, Eric Evans wrote: On Fri, Aug 24, 2012 at 5:00 AM, Adeel Akbar adeel.ak...@panasiangroup.com wrote: I have upgraded cassandra on ring and one node successfully upgraded

Re: JMX(RMI) dynamic port allocation problem still exists?

2012-08-28 Thread Yang
Thanks Nick. it would be nice to pack such work-arounds together with Cassandra, and enable it with a command line arg in the start up script, so that the end-user has a more smooth usage experience - we did spend some time before to debug the ports issues, and find a trick for that. I

Re: An experiment using Spring Data w/ Cassandra (initially via JPA/Kundera)

2012-08-28 Thread Vivek Mishra
Hi, This support is now implemented in kundera(latest trunk branch). Let me know, if you have any other question. On Thu, Jul 19, 2012 at 11:21 AM, Vivek Mishra mishra.v...@gmail.comwrote: Thanks. Team is working on to extend support for SimpleJPARepository(including implementation for

Re: Automating nodetool repair

2012-08-28 Thread Aaron Turner
Funny you mention that... i just was hearing on #cassandra this morning that it repairs the replica set by default. I was thinking of repairing every 3rd node (RF=3), but running -pr seems cleaner. Do you know if this (repairing a replica vs node) was introduced in 1.0 or 1.1? On Tue, Aug 28,

Re: Automating nodetool repair

2012-08-28 Thread Mohit Agarwal
Is there any reason why cassandra doesn't do nodetool repair out of the box at some fixed intervals? On Tue, Aug 28, 2012 at 9:08 PM, Aaron Turner synfina...@gmail.com wrote: Funny you mention that... i just was hearing on #cassandra this morning that it repairs the replica set by default. I

RE: Expanding cluster to include a new DR datacenter

2012-08-28 Thread Bryce Godfrey
So in an interesting turn of events, this works on my other 4 keyspaces but just not this 'EBonding' one which will not recognize the changes. I can probably get around this by dropping and re-creating this keyspace since its uptime is not too important for us. [default@AlertStats] describe

Advantage of pre-defining column metadata

2012-08-28 Thread A J
For static column family what is the advantage in pre-defining column metadata ? I can see ease of understanding type of values that the CF contains and that clients will reject incompatible insertion. But are there any major advantages in terms of performance or something else that makes it

Re: Node forgets about most of its column families

2012-08-28 Thread Edward Sargisson
For the record, we just had a recurrence of this. This time, when the node (#5) came back it didn't properly rejoin the ring. We stopped every node and brought them back one by one to get the ring to link up correctly. Then, all the even nodes (#2, #4, #6) had out of data schemas. nodetool

Re: Advantage of pre-defining column metadata

2012-08-28 Thread Edward Capriolo
Setting the metadata will set the validation. If you insert to a column that is supposed to only INT values Cassandra will reject non INT data on insert time. Also comparator can not be changed, you only get once chance to set the column sorting. On Tue, Aug 28, 2012 at 3:34 PM, A J

Re: Automating nodetool repair

2012-08-28 Thread Edward Sargisson
Thanks a very nice approach. If every nodetool repair uses -pr does that satisfy the requirement to run a repair before GCGraceSeconds expires? In otherwords, will we get a correct result using -pr everywhere. Secondly, what's the need for sleep 120? Cheers, Edward On 12-08-28 07:03 AM,

RE: Expanding cluster to include a new DR datacenter

2012-08-28 Thread Bryce Godfrey
I believe what may be really going on is that my schema is in a bad or corrupt state. I also have one keyspace that I just cannot drop an existing column family from even though it shows no errors. So right now I was able to get 4 of my 6 keyspaces over to Network Topology strategy. I think

Re: Automating nodetool repair

2012-08-28 Thread Aaron Turner
On Tue, Aug 28, 2012 at 1:42 PM, Edward Sargisson edward.sargis...@globalrelay.net wrote: Thanks a very nice approach. If every nodetool repair uses -pr does that satisfy the requirement to run a repair before GCGraceSeconds expires? In otherwords, will we get a correct result using -pr

Re: Automating nodetool repair

2012-08-28 Thread Omid Aladini
Secondly, what's the need for sleep 120? just give the cluster a chance to settle down between repairs... there's no real need for it, just is there because. Actually, repair could cause unreplicated data to be streamed and new sstables to be created. New sstables could cause pending

Re: Node forgets about most of its column families

2012-08-28 Thread Peter Schuller
I can confirm having seen this (no time to debug). One method of recovery is to jump the node back into the ring with auto_bootstrap set to false and an appropriate token set, after deleting system tables. That assumes you're willing to have the node take a few bad reads until you're able to

Re: Why Cassandra secondary indexes are so slow on just 350k rows?

2012-08-28 Thread Dave Brosius
If i understand you correctly, you are only ever querying for the rows where is_exported = false, and turning them into trues. What this means is that eventually you will have 1 row in the secondary index table with 350K columns that you will never look at. It seems to me you that perhaps you

Re: can you use hostnames in the topology file?

2012-08-28 Thread aaron morton
All host names are resolved to IP addresses. does the listen_address have to be hardwired to that same EXACT hostname for lookup purposes as well? Not sure exactly what you mean here. I think if you only supply the host name, and your DNS is set correctly will work. Hope that helps.

Re: optimizing use of sstableloader / SSTableSimpleUnsortedWriter

2012-08-28 Thread aaron morton
dataset... just under 4 months of data is less then 2GB! I'm pretty thrilled. Be thrilled by all the compressions ! :) Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/08/2012, at 6:10 AM, Aaron Turner synfina...@gmail.com wrote: On

Re: sstableloader error

2012-08-28 Thread aaron morton
WARN 21:41:15,200 Failed attempt 1 to connect to /10.245.28.232 to stream null. Retrying in 2 ms. (java.net.ConnectException: Connection timed out) If you let sstable run does it complete ? I am running cassandra on foreground. So, on all of the cassandra nodes i get the below message: