Pruning commit logs manually

2011-06-17 Thread Marcus Bointon
My commit logs sometimes eat too much disk space. I see that the oldest is about a day old, so it's clearly pruning already, but is there some way I can clear them out manually without breaking stuff, assuming that all the transactions they describe have been completed? Marcus smime.p7s

Removing zombie node

2011-06-09 Thread Marcus Bointon
A while ago I removed a node (on EC2) with decommission and removed its token. It all seemed happy at the time, but on creating a column family, I get this: Waiting for schema agreement... Warning: unreachable nodes ip... schemas agree across the cluster The IP it lists is not in the ring. How

Re: starting with PHPcassa

2011-06-01 Thread Marcus Bointon
On 1 Jun 2011, at 08:12, Amrita Jayakumar wrote: I have deployed this code into a php file phcass.php in the ubuntu machine in the location /var/www/vishnu/. But nothing happens when i execute the file through the browser. Neither can i find the data inserted in the column family 'Users'.

Re: problem in starting the cassandra single node setup

2011-05-31 Thread Marcus Bointon
On 31 May 2011, at 08:28, Amrita Jayakumar wrote: Can you please tell me what is thrift and what is it used for??? I mean is it necessary to use cassandra? do i have to install it separately??? or does it come along with the cassandra package? It's the underlying protocol stack that

Appending to fields

2011-05-31 Thread Marcus Bointon
I'm wondering how cassandra implements appending values to fields. Since (so the docs tell me) there's not really any such thing such thing as an update in Cassandra, I wonder if it falls into the same trap as MySQL does. With a query like update x set y = concat(y, 'a') where id = 1, mysql

Re: Appending to fields

2011-05-31 Thread Marcus Bointon
On 31 May 2011, at 23:03, Dan Kuebrich wrote: I think perhaps OP meant O(N * M), where N is number of rows and M is total bytes. That's probably more accurate. This is what it was doing: Say I repeatedly append 100 bytes to the same 1000 records. First time around that's 100,000 bytes to

Re: starting with PHPcassa

2011-05-31 Thread Marcus Bointon
On 1 Jun 2011, at 07:03, Amrita Jayakumar wrote: into the php.ini file. But wen i fired locate php.ini i got many of them in the following locations. /etc/php5/apache2/php.ini /etc/php5/cgi/php.ini /etc/php5/cli/php.ini /usr/share/doc/php5-common/examples/php.ini-development

Re: starting with PHPcassa

2011-05-31 Thread Marcus Bointon
On 1 Jun 2011, at 07:21, Amrita Jayakumar wrote: so i just should create a directory phpcassa in the location /etc/php5/conf.d/ and in phpcassa just create a file php.ini and include the line extension=thrift_protocol.so in it Nearly. Just run this: echo

Re: problem in starting the cassandra single node setup

2011-05-30 Thread Marcus Bointon
On 30 May 2011, at 10:59, Amrita Jayakumar wrote: I am new to cassandra. I am trying to start the Cassandra single node setup using the command bin/cassandra -f. But there is no response from the prompt.. this is what it shows I'm new to this too, but I think you're looking at the wrong

Stable/unstable packages?

2011-05-27 Thread Marcus Bointon
Are there separate repos/packages for stable/unstable releases of Cassandra? I was a bit surprised to find the official debian repo pushing out 0.8b2 as a normal update to the cassandra package. Would it not be better to have a cassandra-unstable package for bleeding edge and plain cassandra

Re: Stable/unstable packages?

2011-05-27 Thread Marcus Bointon
On 27 May 2011, at 10:10, Marcus Bointon wrote: Are there separate repos/packages for stable/unstable releases of Cassandra? I was a bit surprised to find the official debian repo pushing out 0.8b2 as a normal update to the cassandra package. Would it not be better to have a cassandra

Re: EC2 node adding trouble

2011-05-26 Thread Marcus Bointon
Thanks for all your helpful suggestions - I've now got it working. It was down to a combination of things. 1. A missing rule in a security group 2. A missing DNS name for the new node, so its default name was defaulting to localhost 3. Google DNS caching the failed DNS lookup for the full

Re: EC2 node adding trouble

2011-05-26 Thread Marcus Bointon
On 24 May 2011, at 23:58, Sameer Farooqui wrote: So, once you know what token each of the 3 nodes should have, shut down the first two nodes, change their tokens and add the correct token to the 3rd node (in the YAML file). I'd like to make sure I've got the right sequence of operations for

Re: EC2 node adding trouble

2011-05-26 Thread Marcus Bointon
On 26 May 2011, at 15:21, Sasha Dolgy wrote: Turn the node off, remove the node from the ring using nodetool and removetoken i've found this to be the best problem-free way. Maybe it's better now ... http://blog.sasha.dolgy.com/2011/03/apache-cassandra-nodetool.html So I'd need to have

Re: EC2 node adding trouble

2011-05-25 Thread Marcus Bointon
On 24 May 2011, at 23:58, Sameer Farooqui wrote: Even with AutoBootstrap it is recommended that you always specify the InitialToken on the new node because the picking of an initial token will almost certainly result in an unbalanced ring. Right now, I'm afraid that if you simply copied

EC2 node adding trouble

2011-05-24 Thread Marcus Bointon
Hi, First time here. I'm having trouble adding a third node to an existing 2-node ring (successfully upgraded from 0.72) running cassandra 0.8rc1 (successfully upgraded from 0.72) on ubuntu on EC2. Evidently the seed node is working as the second node is already talking to it, nodetool lists

Re: EC2 node adding trouble

2011-05-24 Thread Marcus Bointon
On 24 May 2011, at 19:33, Sameer Farooqui wrote: What region and availability zones are the different nodes in? Are you using EC2 Snitch? Did you set up the cluster using the Datastax AMI? The two existing ones are in us-east-1c and us-east-1d, the new one is in us-east-1c, so all same