Re: Excessive allocation during hinted handoff

2011-05-11 Thread aaron morton
ering hints to the nodes when they restart? Finally hinted_handoff_throttle_delay_in_ms in conf/cassandra.yaml will let you slow down the delivery rate if HH is indeed the problem. Hope that helps. - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.co

Re: Unable to add columns to empty row in Column family: Cassandra

2011-05-11 Thread aaron morton
e your app ? Cassandra-cli will be using the current time as it's time stamp for the delete. If I had to guess what was happening it would be a problem with the timestamps your app is creating. Thanks --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle

Re: network topology issue

2011-05-11 Thread aaron morton
ring can have the same token, hence the error. When using the NTS the RF must be set per DC using the strategy_options clause in the `create keyspace CL i statement. The global RF is just the sum of the per DC values. Hope that helps. - Aaron Morton Freelance Cass

Re: Import/Export of Schema Migrations

2011-05-13 Thread aaron morton
What sort of schema changes are you making? can you manage them as a CLI script under source control ? You may also be interested in CASSANDRA-2221. Cheers Aaron - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 12 May 2011, at 20:45

Re: Excessive allocation during hinted handoff

2011-05-13 Thread aaron morton
e the node is been asked to record a lot of hints. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 13 May 2011, at 03:51, Gabriel Tataranu wrote: >>> What does the TPStats look like on the nodes under pressure ? And how m

Re: nodetool move in cassandra

2011-05-13 Thread aaron morton
Aaron - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 13 May 2011, at 12:22, Anurag Gujral wrote: > Hi All, >I want to change the token for my cassandra node from T to T+1. It > appears that cassandra in this case brings all the

Re: assertion error in cassandra when doing nodetool move

2011-05-13 Thread aaron morton
nodes assigned to all dc's. Hope that helps. - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 13 May 2011, at 13:45, Anurag Gujral wrote: > Hi All, > I run following command on one of my nodes to move the token

Re: Cassandra node is not blanced Rf=2 Random Partitioner

2011-05-13 Thread aaron morton
You need to manually assign the tokens to the nodes http://wiki.apache.org/cassandra/Operations#Load_balancing One should be 0 and the other 85070591730234615865843651857942052864 Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On

Re: Import/Export of Schema Migrations

2011-05-15 Thread aaron morton
different ideas --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 14 May 2011, at 00:15, David Boxenhorn wrote: > Actually, I want a way to propagate *any* changes from development to staging > to production, but schema changes a

Re: [howto measure disk usage]

2011-05-15 Thread aaron morton
sting. Cheers --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 14 May 2011, at 03:15, Alexis Rodríguez wrote: > cassandra-people, > > I'm trying to measure disk usage by cassandra after inserting some columns in > order to plan d

Re: Converting separate clusters in mutliple dc to one cluster across multiple dcs

2011-05-15 Thread aaron morton
? I can give it some more thought later if you need. Hope that helps. - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 14 May 2011, at 04:55, Anurag Gujral wrote: > Hi All, > I have 3 separate cassandra clusters runn

Re: assertion error in cassandra when doing nodetool move

2011-05-15 Thread aaron morton
I've had a bit more of a look and am a bit confused between what I see in the stack below and what's in the source. What version are you seeing ? Thank ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 14 May 2011, at 03:23, Anu

Re: problems using property snitch file

2011-05-15 Thread aaron morton
Whats does your cassandra-topology.properties file look like ? Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 14 May 2011, at 11:48, Anurag Gujral wrote: > Hi All, > I have built a cassandra cluster which is

Re: JMX access sample by jython (Was: How to invoke getNaturalEndpoints with jconsole?)

2011-05-15 Thread aaron morton
Nice, Thanks - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 15 May 2011, at 01:12, Maki Watanabe wrote: > Just FYI for beginners like me: I've also write it with jython. > Getting attributes are more easier than invoke Ope

Re: insert and batch_insert

2011-05-16 Thread aaron morton
e. You may want to reduce the batch size if clients are seeing high latency. Hope that helps. --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 15 May 2011, at 10:34, Xiaowei Wang wrote: > Hi, > > We use Cassandra 0.7.4 to do T

Re: Multiget_slice or composite column keys?

2011-05-16 Thread aaron morton
that helps. ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 15 May 2011, at 19:56, Charles Blaxland wrote: > Hi All, > > New to Cassandra, so apologies if I don't fully grok stuff just yet. > > I have data keyed by a

Re: problems using property snitch file

2011-05-16 Thread aaron morton
Do all the lines have the same IP address or is that just how you redacted them ? is the single node in DC1 the one you are moving? Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 16 May 2011, at 12:28, Anurag Gujral wrote

Re: Converting separate clusters in mutliple dc to one cluster across multiple dcs

2011-05-16 Thread aaron morton
/CASSANDRA-2656 to have a nicer message. cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 16 May 2011, at 12:41, Anurag Gujral wrote: > Hi Aaron, > Thanks for your mail. I am leaning towards making a new cluster &

Re: AssertionError

2011-05-16 Thread Aaron Morton
The code is trying to follow the column index for a row in an sstable, but it cannot skip as many bytes as it would like to to get to the column. Helpfully the help says running out of bytes is only one of the reasons why this could happen:) Can you provide some more information about the query

Re: Using composite column names in the CLI

2011-05-16 Thread Aaron Morton
What do you mean by composite column names? Do the data type functions supported by get and set help? Or the assume statement? Aaron On 17/05/2011, at 3:21 AM, David Boxenhorn wrote: > Is there a way to view composite column names in the CLI? > > Is there a way to input them (i.e. in the set

Re: Counter Column family Cassandra 0.8 PHP Support ?

2011-05-17 Thread aaron morton
I'm not a php type person, but I can help a little with thrift. Install thrift 0.6 and then run this in the interface/ directory of the cassandra source... thrift --gen php cassandra.thrift You should end up with the interface/gen-php/ Hope that helps. - Aaron M

Re: problems using property snitch file

2011-05-17 Thread aaron morton
definition, and settings such as listen_address and rpc_address . Cheers ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 17 May 2011, at 03:44, Anurag Gujral wrote: > All lines have different IP address,yes I am trying to move singl

Re: Questions about using MD5 encryption with SimpleAuthenticator

2011-05-17 Thread aaron morton
Use the plain text password via the cli, the server will make a hash and compare it to the one in the file. wrt SHA-2 I'm not a security guy but MD5 is probably "good enough" for the problem of storing passwords in plain text in a file. Hope that helps. -------

Re: Questions about using MD5 encryption with SimpleAuthenticator

2011-05-17 Thread aaron morton
If you need it create a ticket on https://issues.apache.org/jira/browse/CASSANDRA Aaron - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 18 May 2011, at 10:52, Sameer Farooqui wrote: > Opps, my bad... please ignore the email below.

Re: Questions about using MD5 encryption with SimpleAuthenticator

2011-05-18 Thread Aaron Morton
Also if you were wearing an aluminium foil hat you may also be concerned about how the password is sent to the server. Again though, see previous "I am not a security guy" comment and helpful link from Jonathan confirming that statement :) Cheers ----- Aaron Morton

Re: Cassandra Vs. Oracle Coherence

2011-05-19 Thread aaron morton
at provide support http://wiki.apache.org/cassandra/ThirdPartySupport Hope that helps. ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 18 May 2011, at 10:44, Karamel, Raghu wrote: > Hi, > > I am new to Cassandra and very excited

Re: Knowing when there is a *real* need to add nodes

2011-05-19 Thread aaron morton
ng the pending queue for a while. AFAIK the other pools should not have many (< 10) tasks in the pending queue and should be able to clearing the pending queue. Hope that helps. ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com O

Re: Recommandation on how to organize CF

2011-05-19 Thread aaron morton
longer. Hope that helps. - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 19 May 2011, at 05:44, openvictor Open wrote: > Hello all, > > I know organization is a broad topic and everybody may have an idea on how to >

Re: Support for IN clause

2011-05-19 Thread aaron morton
Language spec is here https://github.com/apache/cassandra/blob/trunk/doc/cql/CQL.textile - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 20 May 2011, at 01:42, Yuki Morishita wrote: > Hi, > > I think IN clause for SELECT and UP

Re: Re : Re : selecting data

2011-05-22 Thread aaron morton
You should be using Cassandra 0.7+, 0.6 is basically end of life. 0.7 is stable and 0.8 is in release candidate. There is limited support for using 0.6. Grabe a copy of 0.7 and run bin/cassandra-cli and look at the help in there. Cheers - Aaron Morton Freelance Cassandra

Re: How to reduce the Read Latency.

2011-05-22 Thread aaron morton
with other things - check if the IO system is overloaded (google is your friend) I'd start with the data model and the query. Hope that helps. - --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 20 May 2011, at 2

Re: rainbird question (why is the 1minute buffer needed?)

2011-05-22 Thread aaron morton
cluster to do. This can be important when the numbers are big http://blog.twitter.com/2011/03/numbers.html Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 21 May 2011, at 09:04, Yang wrote: > (sorry if Rainbird is not a to

Re: Reboot, now node down 0.8rc1

2011-05-23 Thread aaron morton
o DEBUG so there are some more details if things go wrong. Cheers ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 24 May 2011, at 08:05, Scott McPheeters wrote: > Since this is a testing system, I deleted the commit log and it came &g

Re: EC2 node adding trouble

2011-05-24 Thread aaron morton
Check the listen_address and rpc_address in the yaml file for each node. I think they are normally set to the private and public respectively. This may make your live easier http://www.datastax.com/dev/blog/setting-up-a-cassandra-cluster-with-the-datastax-ami Cheers - Aaron

Re: Measure Latency

2011-05-24 Thread Aaron Morton
(one may be the one the client is connected to.)After the initial request has completed it's up the "Eventual Consistency" features of Read Repair, Hinted Handoff and Anti-Entropy to distribute changes. Does that help or are you thinking of something else?  --------- Aaron M

Re: How to make use of Cassandra raw row keys?

2011-05-24 Thread Aaron Morton
owMutation(keyspace='dev', key='666f6f', modifications=[data])You can tell the CLI what data type the keys are, see the assume statement. e.g. assume my_cf keys as ascii; Will tell the cli to convert them back to ascii for you.Hope that helps. - Aaron Morton

Re: nodetool move trying to stream data to node no longer in cluster

2011-05-25 Thread aaron morton
Is it showing progress ? It may just be a problem with the information printed out. Can you check from the other nodes in the cluster to see if they are receiving the stream ? cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 26

Re: EC2 node adding trouble

2011-05-25 Thread aaron morton
d-VPC-td6335709.html cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 25 May 2011, at 18:49, Marcus Bointon wrote: > On 25 May 2011, at 02:10, aaron morton wrote: > >> Check the listen_address and rpc_address in the yaml f

Re: How to make use of Cassandra raw row keys?

2011-05-25 Thread aaron morton
Hard to say exactly what the issue is. Are they connected to the same node and using the same Consistency Level? Try turing the logging up to DEBUG to see they are issuing the same query. Hope that helps. - Aaron Morton Freelance Cassandra Developer @aaronmorton http

Re: Measure Latency

2011-05-25 Thread aaron morton
me point in the future. Depending on the mix of Read Repair, Hinted Handoff and nodetool repair. Hope that helps. --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 26 May 2011, at 05:56, Stephan P wrote: > Thanks for the reply. >

Re: nodetool move trying to stream data to node no longer in cluster

2011-05-26 Thread aaron morton
cool. I was going to suggest that but as you already had the move running I thought it may be a little drastic. Did it show any progress ? If the IP address is not responding there should have been some sort of error. Cheers - Aaron Morton Freelance Cassandra Developer

Re: How to programmatically index an existed column?

2011-05-26 Thread aaron morton
Please post to one list at a time. Otherwise people may spend their time helping you when someone already has. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 26 May 2011, at 17:35, Dikang Gu wrote: > > I want to b

Re: PHP CQL Driver

2011-05-26 Thread aaron morton
Cool, this may be a better discussion for the client-dev list http://www.mail-archive.com/client-dev@cassandra.apache.org/ I would start by turning up the server logging to DEBUG and watching your update / select queries. Cheers - Aaron Morton Freelance Cassandra Developer

Re: nodetool move trying to stream data to node no longer in cluster

2011-05-26 Thread aaron morton
le to add a new application state that purges an IP from the ring. e.g. VersionedValue.STATUS_PURGED that works with a ttl so it goes through X number of gossip rounds and then disappears. Hope that helps. --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelas

Re: EC2 node adding trouble

2011-05-26 Thread aaron morton
This ticket may be just the ticket :) https://issues.apache.org/jira/browse/CASSANDRA-2452 Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 27 May 2011, at 01:16, Sasha Dolgy wrote: > As an aside, you can also use that command

Re: EC2 node adding trouble

2011-05-26 Thread aaron morton
This is the *most* useful page on the wiki http://wiki.apache.org/cassandra/Operations Hope that helps. - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 27 May 2011, at 02:06, Marcus Bointon wrote: > On 26 May 2011, at 15:21, Sa

Re: Consistency Level throughput

2011-05-29 Thread aaron morton
You've not talked about how you are doing the tests (or i missed it). With 6 nodes and RF 3 when you read at ONE there is a 50% chance of the data read been served locally. In which case the request will return to the client very quickly. Allowing X number of clients to make Y number of request

Re: Counters

2011-05-29 Thread aaron morton
Specify a comparator and sub_comparator for the CF, the cli will then use these to format the values correctly. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 29 May 2011, at 18:02, Mubarak Seyed wrote: > I have a Coun

Re: expiring + counter column?

2011-05-29 Thread aaron morton
the write path to require a read from disk. Cheers ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 29 May 2011, at 20:04, Yang wrote: > > sorry in the notation, instead of "ttl" I mean "timestamp" > >

Re: Recommandation on how to organize CF

2011-05-29 Thread aaron morton
, use hive/pig and it's a pain for everyone. I agree it's not for every situation and it probably makes sense to start coding without it to begin with. But I think it is worth considering in some cases. Hope that helps. --------- Aaron Morton Freelance Cassandra Developer @a

Re: expiring + counter column?

2011-05-29 Thread aaron morton
-1909?focusedCommentId=12976727&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12976727 Cheers ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 30 May 2011, at 06:41, Yang wrote: > yeah, then maybe

Re: sync commitlog in batch mode lose data

2011-05-31 Thread aaron morton
t log sync'ing. Hope that helps. ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 31 May 2011, at 20:46, Preston Chang wrote: > My RF is 2. > > When the node A is down, the commit log should be fsynced to disk in my test

Re: get_indexed_slices count api

2011-06-01 Thread aaron morton
The best thing to do is log into jira and vote for the feature so others know people are interested in it. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 1 Jun 2011, at 09:21, Donal Zang wrote: > Hi, > I'm query o

Re: ConsistencyLevel and write availability

2011-06-01 Thread aaron morton
are stored on nodes 0,1,2,3,4,5,6,7 Token ranges assigned to nodes 4,5,6,7,8,9 will not available at CL all as nodes 8 and 9 are part of the replica sets for those ranges. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 1 Jun 2011

Re: [RELEASE] 0.8.0

2011-06-02 Thread aaron morton
Big thanks to all the contributors and committers :) A - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 3 Jun 2011, at 11:48, Joseph Stein wrote: > Awesome! > > On Thu, Jun 2, 2011 at 7:36 PM, Eric Evans wrote: > > I

Re: Cannot recover SSTable with version f (current version g).

2011-06-03 Thread aaron morton
e node before starting decommission as this would write new data files. It's a bit late here so I may have missed something. Thanks for reporting it. - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 3 Jun 2011, at 22:06, Dikang Gu

Re: Reading quorum

2011-06-03 Thread aaron morton
e returned. Hope that helps. ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 4 Jun 2011, at 04:53, mcasandra wrote: > > Fredrik Stigbäck wrote: >> >> Does reading quorum mean only waiting for quorum respones or does it

Re: Problem compiling

2011-06-04 Thread aaron morton
300) Hope that helps. ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 4 Jun 2011, at 14:31, Fabio Souto wrote: > Seems like it's not the problem: > > [root@nosql-dev cassandra]# ant -version > Apache Ant(TM) version 1.

Re: CQL How to do

2011-06-04 Thread aaron morton
to is https://github.com/apache/cassandra/blob/cassandra-0.8.0/doc/cql/CQL.textile There are Java, Python and Twisted Python drivers in the source tree under the drivers/ directory. Hope that helps. - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickl

Re: 回复: how to know there are some columns in a row

2011-06-04 Thread aaron morton
You can also use slice a range of columns for a row , e.g. first 100 columns after column "". What client are you using ? Cheers ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 5 Jun 2011, at 04:19, Yonder wrote: >

Re: problems with many columns on a row

2011-06-04 Thread aaron morton
ow removed. [default@dev] get data['foo']; Returned 0 results. [default@dev] The higher numbers created by the client should still work, but I would look into this first. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.the

Re: problems with many columns on a row

2011-06-05 Thread aaron morton
Ops, I misread "150 GB" in one of your earlier emails as "150 MB" so forget what I said before. You have loads of free space :) How many files do you have in your data directory ? If it's 1 then that log message was a small bug, that has been fixed. Cheers -

Re: CQL How to do

2011-06-05 Thread aaron morton
post the query they sent. I'm keen to see how it goes. Cheers --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 6 Jun 2011, at 03:27, Eric Evans wrote: > On Sun, 2011-06-05 at 00:51 -0400, Jeffrey Kesselman wrote: >> Is

Re: how to know there are some columns in a row

2011-06-05 Thread aaron morton
You can create columns without values. Are you talking about reading them back through the API ? I would suggest looking at your data model to see if there is a better way to support your read patterns. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http

Re: Replication-aware compaction

2011-06-06 Thread aaron morton
Delaying compaction will only make it run for longer and take more resources. Cheers ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 6 Jun 2011, at 20:14, David Boxenhorn wrote: > Is there some deep architectural reason why compac

Re: Migration question

2011-06-06 Thread aaron morton
schema, you will want to copy this directory. You may also want to copy the cassandra.yaml or create new ones with the correct initial tokens. The nodes will sort themselves out when they start up and get new IP's, the important thing to them is the token. Cheers -

Re: Replication-aware compaction

2011-06-06 Thread aaron morton
give you the stats for the local operations. You could also take a look at the iostats on the box http://spyced.blogspot.com/2010/01/linux-performance-basics.html Hope that helps. - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 7 Jun

Re: problems with many columns on a row

2011-06-06 Thread aaron morton
Can you upgrade to the official 0.8 release and try again with logging set to DEBUG ? Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 6 Jun 2011, at 23:41, Mario Micklisch wrote: > :-) > > There are several d

Re: Troubleshooting IO performance ?

2011-06-06 Thread aaron morton
what sort of slice - has their been a lot of deletes or TTL columns used ? Hope that helps. Aaron - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 7 Jun 2011, at 10:09, Philippe wrote: > Ok, here it goes again... No swapping at

Re: Backups, Snapshots, SSTable Data Files, Compaction

2011-06-07 Thread aaron morton
I'd also say consider what happens during maintenance and failure scenarios. Moving 10's TB around takes a lot longer than 100's GB. Cheers --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 8 Jun 2011, at 06:40, AJ wrot

Re: About Brisk, Hadoop powered by Cassandra

2011-06-07 Thread aaron morton
it's here https://github.com/riptano/brisk under the apache v2 licence try the #datastax-brisk irc room on freenode cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 8 Jun 2011, at 07:03, Marcos Ortiz wrote: > Regards to

Re: Troubleshooting IO performance ?

2011-06-07 Thread aaron morton
s to read the data from disk and apply the filter. I'd check you are reading the data you expect then wind back the number of requests and rows / columns requested. Get to a stable baseline and then add pressure to see when / how things go wrong. Hope that helps. - Aaron Mor

Re: how to know there are some columns in a row

2011-06-07 Thread aaron morton
ou have all the information about the column. There may also be some modelling arguments to be made. it's not been a show stopper for people in the past, but that does not mean it's a bad idea. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www

Re: CLI set command returns null, ver 0.8.0

2011-06-08 Thread aaron morton
Can you provide the cli script to create the schema and info on how many nodes you have. Thanks - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 8 Jun 2011, at 16:12, AJ wrote: > Can anyone help? The CLI seems to be having iss

Re: Retrieving a column from a fat row vs retrieving a single row

2011-06-08 Thread aaron morton
over 5 SSTables then each one must be accessed. https://issues.apache.org/jira/browse/CASSANDRA-2319 is open to try and reduce the number of seeks. For now take a look at nodetool cfhistograms to see how many sstables are read for your queries. Cheers - Aaron Morton

Re: how to know there are some columns in a row

2011-06-08 Thread aaron morton
start the process and ask others to vote if they would also like to see it. If you have time to donate for the feature include that on the ticket. Thanks ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 9 Jun 2011, at 06:55, Jeremiah

Re: Is there a way from a running Cassandra node to determine whether or not itself is "up"?

2011-06-09 Thread aaron morton
tor of the node being queried. * * @return set of IP addresses, as Strings */ public List getLiveNodes(); Hope that helps. ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 9 Jun 2011, at 17:56, Suan Aik Yeo wrote: > I

Re: Best way to import data from Cassandra 0.6 to 0.8

2011-06-09 Thread aaron morton
that helps. - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 10 Jun 2011, at 03:13, JKnight JKnight wrote: > Dear all, > > Could you tell me the best way to import data from Cassandra 0.6 to 0.8? > Thank you very much. >

Re: need some help with counters

2011-06-09 Thread aaron morton
nsider a separate CF with more aggressive GC and compaction settings. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 10 Jun 2011, at 09:28, Ian Holsman wrote: > So would doing something like storing it in reverse (so I know what

Re: Retrieving a column from a fat row vs retrieving a single row

2011-06-09 Thread aaron morton
in a tight loop reading at ONE makes is easier for the client to overload the server as it can send more work before the server has really finished the previous request. You can adjust the probability the RR will run in the yaml config. Hope that helps. - Aaron M

Re: Secondary indices with multiple conditions?

2011-06-11 Thread aaron morton
o better support the read requests including de-normalising to reduce the number of conditions required to find the right data. Hope that helps. --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 10 Jun 2011, at 17:53, Mark Kerzner wrote:

Re: Are data migration tools for Cassandra exist?

2011-06-11 Thread aaron morton
do? Hope that helps. - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 10 Jun 2011, at 21:21, Artem Orobets wrote: > If my application works in production and I change structure of my data (e.g. > type of column name) > I wil

Re: need some help with counters

2011-06-12 Thread aaron morton
ending on scale, I'd consider a sorted set in redis for that. Hope that helps. ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 11 Jun 2011, at 00:36, Ian Holsman wrote: > > On Jun 9, 2011, at 10:04 PM, aaron morton wrot

Re: disk full

2011-06-12 Thread aaron morton
Please provide some more information. In general, avoid using more than 50% of the available disk space. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 11 Jun 2011, at 16:19, Donna Li wrote: > Hi, all: > When d

Re: get_indexed_slices ~ simple map-reduce

2011-06-12 Thread aaron morton
more info on the use case ? Personally if you have a read query you know you need to support, I would consider supporting it in the data model without secondary indexes. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 11 Jun 2011

Re: insert slowdown with secondary indexes

2011-06-12 Thread aaron morton
ad all the data without secondary indexes, then add them. * consider using 64bit machines with more memory and disk. * work out what is add the read load. Hope that helps. --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 11 Jun

Re: Troubleshooting IO performance ?

2011-06-13 Thread aaron morton
or the unexplained IO ? ----- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 12 Jun 2011, at 08:55, Philippe wrote: > More info below > > I just loaded 4.8GB of similar data in another keyspace and ran the same > process as in my pre

Re: odd logs after repair

2011-06-13 Thread aaron morton
? Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 13 Jun 2011, at 06:19, Sasha Dolgy wrote: > Hi Everyone, > > Last week, upgraded all 4 nodes to apache-cassandra-0.8.0 .. no > issues. Trolling the logs today, I find m

Re: get_indexed_slices ~ simple map-reduce

2011-06-13 Thread aaron morton
helps. - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 13 Jun 2011, at 08:34, Michal Augustýn wrote: > Hi, > > as I wrote, I don't want to install Hadoop etc. - I want just to use > the Thrift API. The core of my que

Re: SSL & Streaming

2011-06-13 Thread aaron morton
Sasha does https://github.com/apache/cassandra/blob/cassandra-0.8.0/conf/cassandra.yaml#L362 help ? A - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 13 Jun 2011, at 23:26, AJ wrote: > Performance-wise, I think it would be better

Re: odd logs after repair

2011-06-13 Thread aaron morton
? Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 14 Jun 2011, at 03:27, Sijie YANG wrote: > Hi, All > > I am newbie to cassandra. I have a simple question but don't find any clear > answer by searching goog

Re: get_indexed_slices ~ simple map-reduce

2011-06-14 Thread aaron morton
the compaction process has been. Generally older rows will have more predictable performance. Something I wrote once about the read and write path http://thelastpickle.com/2011/04/28/Forces-of-Write-and-Read/ Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http

Re: New web client & future API

2011-06-14 Thread aaron morton
thrift as the wire protocol. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 15 Jun 2011, at 02:01, Markus Wiesenbacher | Codefreun.de wrote: > Yes, I wanted to start from the base ... > > > Am 14.06.2011 um 15:48 s

Re: Docs: "Why do deleted keys show up during range scans?"

2011-06-14 Thread aaron morton
umns I requested. 2) It has none of the columns I requested. 3) it has no columns, but cassandra decided it was too much work to conclusively prove that. Because after all I asked if it had some specific columns not if it had any columns. Hope that helps. ----- Aaron Morton

Re: Migration question

2011-06-16 Thread aaron morton
otherwise. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 15 Jun 2011, at 15:50, Marcos Ortiz wrote: > > > El 6/14/2011 1:43 PM, Eric Czech escribió: >> >> Thanks Aaron. I'll make sure to copy the sys

Re: Slowdowns during repair

2011-06-16 Thread aaron morton
s crashing and whats happening with the GC. Cheers --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 16 Jun 2011, at 10:20, Aurynn Shaw wrote: > Hey all; > > So, we have Cassandra running on a 5-server ring, with a RF of 3,

Re: Where is my data?

2011-06-16 Thread aaron morton
I wrote a blog post about this sort of thing the other day http://thelastpickle.com/2011/06/13/Down-For-Me/ Let me know if you spot any problems. Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 16 Jun 2011, at 02:20, AJ wrote

Re: Force a node to form part of quorum

2011-06-16 Thread aaron morton
andra.yaml#L308 Cheers --------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 16 Jun 2011, at 05:58, A J wrote: > Is there a way to favor a node to always participate (or never > participate) towards fulfillment of read consist

Re: Atomicity of batch updates

2011-06-16 Thread aaron morton
See http://wiki.apache.org/cassandra/FAQ#batch_mutate_atomic Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 16 Jun 2011, at 06:26, chovatia jaydeep wrote: > Cassandra write operation is atomic for all the columns/super colu

Re: Easy way to overload a single node on purpose?

2011-06-16 Thread aaron morton
is greater than the RF, it tells you a subset of the nodes works. If you google around you'll find discussions about monitoring with munin, ganglia, cloud kick and Ops Centre. If you install mx4j you can access the JMX metrics via HTTP, Cheers ----- Aaron Morton Freelance C

<    4   5   6   7   8   9   10   11   12   13   >