Hello,
I've noticed very nice stats exposed with JMX. I was quite shocked when I saw
that MaxRowSize was about 400MB (it was expected to be several MB).
What is the best way to find keys of such big rows?
I couldn't find anything so I've written simple program to dump sizes from
Index files (se
Anyone have any thoughts on this thread - about configuring cassandra with a
different ip for listen address and rpc address?
moving this to the cassandra user list as it more involves cassandra
configuration at this point.
On May 10, 2011, at 12:58 AM, Badrinarayanan S wrote:
> Hi, after fur
Hi,
We have a cluster of ~20 nodes all located in 1 datacenter running Cassandra
0.7.2. We are planning to move from this datacenter to another with as minimal
downtime as possible.
The first strategy that came into my mind is to use the topology placement
strategy, create nodes in the new da
http://wiki.apache.org/cassandra/Operations#Replication
2011/5/10 André-Philippe Paquet :
> Hi,
>
> We have a cluster of ~20 nodes all located in 1 datacenter running Cassandra
> 0.7.2. We are planning to move from this datacenter to another with as
> minimal downtime as possible.
>
> The first
All:
A newbie question to the aficianados. I understand that I can stipulate an
ordering mechanism when I create a column family to reflect what I am
querying in the long run. Generally I need to query a particular column
space that I am contructing based on two different columns. The frequency
Hi,
If you make a supercolumn today, what you end up with is:
- short + "Super Column name"
- int (local deletion time)
- long (delete time)
Byte array of columns each with:
- short + "column name"
- int (TTL)
- int (local deletion time)
- long (timestamp)
- int + "value of column"
Th
Hi all,
I found out a small typo in cassandra.yaml, which can confuse
inattentive copy-paster. Here is the patch.
Index: conf/cassandra.yaml
===
--- conf/cassandra.yaml (revision 1101465)
+++ conf/cassandra.yaml (working copy)
@@ -8
On Tue, May 10, 2011 at 3:44 PM, Terje Marthinussen
wrote:
> Hi,
> If you make a supercolumn today, what you end up with is:
> - short + "Super Column name"
> - int (local deletion time)
> - long (delete time)
> Byte array of columns each with:
> - short + "column name"
> - int (TTL)
> - i
> Anyway, to sum that up, expiring columns are 1 byte more and
> non-expiring ones are 7 bytes
> less. Not arguing, it's still fairly verbose, especially with tons of
> very small columns.
>
Yes, you are right, sorry.
Trying to do one thing to many at the same time.
My brain filtered out part of t
You can have only one ordering defined in a CF. Super CF will allow you to
have nested ordering i.e. SC can have one ordering whereas columns within SC
can have other ordering. Note this is defined at CF level and cannot be
defined at SC level.
To model what you are trying to do, you can check if
> Everyone may be well aware of that, but I'll still remark that a minor
> compaction
> will try to merge "as many 20MB sstables as it can" up to the max
> compaction
> threshold (which is configurable). So if you do accumulate some newly
> created
> sstable at some point in time, the next minor co
If I understand correctly, CompositeType comparator
(https://issues.apache.org/jira/browse/CASSANDRA-2231) may be of
interest to you once it becomes available.
Hi All,
I am trying to install cassandra on ec2 boxes . I am using domain
names to specify the listen_address and seeds.
I am getting following error from cassandra when I try to create keyspace.
Warning: unreachable nodes IP(address of the cassandra instance).. schemas
agree across the
. inside quotations is correct in English.
On Tue, May 10, 2011 at 9:06 AM, Benoit Perroud wrote:
> Hi all,
>
> I found out a small typo in cassandra.yaml, which can confuse
> inattentive copy-paster. Here is the patch.
>
>
> Index: conf/cassandra.yaml
> ==
> . inside quotations is correct in English.
Caused by: org.yaml.snakeyaml.error.YAMLException: Cannot create
property=commitlog_sync for
JavaBean=org.apache.cassandra.config.Config@1fd5e2; Unable to find enum
value 'batch.' for enum class:
org.apache.cassandra.config.Config$CommitLogSync
That's
On Tue, May 10, 2011 at 11:40 AM, Jonathan Ellis wrote:
> . inside quotations is correct in English.
>
It's a subtle and non-obvious rule of English. Besides, in a programming
context, the English rule always feels wrong to me :)
Hi,
Here is the actual error I get when I remove all LocationInfo files:
ERROR 18:05:04,918 Fatal exception during initialization
org.apache.cassandra.config.ConfigurationException: Found system table
files, but they couldn't be loaded. Did you change the partitioner?
at
org.apache.cassan
> That reminds me, my false positive ration is stuck at 1.0, so I guess
> bloom filters aren't doing a lot for me.
That sounds unlikely unless you're hitting some edge case like reading
a particular row that happened to be a collision, and only that row.
This is from JMX stats on the column family
On Tue, May 10, 2011 at 6:20 PM, Terje Marthinussen
wrote:
>
>> Everyone may be well aware of that, but I'll still remark that a minor
>> compaction
>> will try to merge "as many 20MB sstables as it can" up to the max
>> compaction
>> threshold (which is configurable). So if you do accumulate some
Hi Anurag,
We're using an elastic IP for the seed address (public DNS name should also
work) and using the private IP (10.255.x.x) for the listen address.
As you're getting started, you may also find this blog that my team put
together helpful:
https://sites.google.com/a/techlabs.accenture.com/c
Comments are text, not code.
On Tue, May 10, 2011 at 12:01 PM, Tyler Hobbs wrote:
> On Tue, May 10, 2011 at 11:40 AM, Jonathan Ellis wrote:
>>
>> . inside quotations is correct in English.
>
> It's a subtle and non-obvious rule of English. Besides, in a programming
> context, the English rule a
Are you using different regions in ec2
Thanks
Anurag
On Tue, May 10, 2011 at 11:19 AM, Sameer Farooqui
wrote:
> Hi Anurag,
>
> We're using an elastic IP for the seed address (public DNS name should also
> work) and using the private IP (10.255.x.x) for the listen address.
>
> As you're getting st
Hi,
I am just learning Cassandra at the moment. The O'Reilly book on
Cassandra says that I should be able to add the keyspace schema
definition to cassandra.yaml and then invoke loadSchemaFromYAML() to
load it. I tried that but it didn't work (and I do realize this book
is a bit obsolete now).
Not yet, but I'm working on deploying 0.8.0 beta 2 on multi-regions using a
VPN on Ubuntu. I can share my technique on this mailing list in a little bit
for how I did it.
On Tue, May 10, 2011 at 12:56 PM, Anurag Gujral wrote:
> Are you using different regions in ec2
> Thanks
> Anurag
>
>
> On T
Hi,
If you are looking for some utility for loading the schema they you can use
schematool command line utlity as:
$> schematool import|export
Thank you,
Jaydeep
From: Jim the Standing Bear
To: user@cassandra.apache.org
Sent: Tuesday, 10 May 2011 1:16 PM
Su
Use jconsole give your hostname:port (hostname,port on which cassandra is
running)
then from the MBean select storage service . On the storage service MBean
execute operation loadSchemaFromXML();
You may have to change the hostname in the your cassandra jmx settings
thanks
A
On Tue, May 10, 2011
Hi Anurag,
That was what I used, but it didn't seem to work.
On Tue, May 10, 2011 at 4:54 PM, Anurag Gujral wrote:
> Use jconsole give your hostname:port (hostname,port on which cassandra is
> running)
> then from the MBean select storage service . On the storage service MBean
> execute operatio
The export dumps to the console. The import only works on fresh system
and imports from cassandra.yaml file.
Praveen
On 5/10/11 1:59 PM, "Jim the Standing Bear" wrote:
>Hi Anurag,
>
>That was what I used, but it didn't seem to work.
>
>On Tue, May 10, 2011 at 4:54 PM, Anurag Gujral
>wrote:
>>
Clearly it doesn't work if go this route. Just wonder if anyone has such
experience which can give me some pointers.
Thanks.
Start w/ the 0.8 one and add your modifications to it.
On Tue, May 10, 2011 at 4:24 PM, Larry Liu wrote:
> Clearly it doesn't work if go this route. Just wonder if anyone has such
> experience which can give me some pointers.
>
> Thanks.
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-
Thanks, Jonathan.
How about data? Restoring the snapshot taken on a 0.7.x box to a 0.8.x
should work, shouldn't it?
On Tue, May 10, 2011 at 2:25 PM, Jonathan Ellis wrote:
> Start w/ the 0.8 one and add your modifications to it.
>
> On Tue, May 10, 2011 at 4:24 PM, Larry Liu wrote:
> > Clearly
I'm not aware of anything to find the row sizes, and your code looks like a
good approach. Converting the key bytes to a string only makes sense if your
app is doing the same thing.
In the cli try using one of the data type functions to format the key the same
way as your app is, e.g. get Fo
On 05/10/2011 02:12 PM, Peter Schuller wrote:
>> That reminds me, my false positive ration is stuck at 1.0, so I guess
>> bloom filters aren't doing a lot for me.
>
> That sounds unlikely unless you're hitting some edge case like reading
> a particular row that happened to be a collision, and only
Late reply, but I just got the same error restarting after upgrading from
0.7.2 to 0.7.5.
I did a drain using nodetool on each node before I killed them and did the
upgrade. Should all commitlogs have been cleaned up after a drain? I would
think so, but they were not. Maybe there is a bug around n
> For a reasonable large amount of use cases (for me, 2 out of 3 at the moment)
> supercolumns will be units of data where the columns (attributes) will never
> change by themselves or where the data does not change anyway (archived data).
Can you use a standard CF and pack the multiple columns
Depending on the data size and workload consider storing the data under both
keys, in the same CF. e.g. keys "id/1234" and "name/MrFoo" are different rows
with the same data in them.
Or us secondary indexes or a custom index using another CF as Narenda
suggests. Secondary indexes are doing p
Data you could just upgrade in place, but the snapshots are also compatible.
On Tue, May 10, 2011 at 4:37 PM, Larry Liu wrote:
> Thanks, Jonathan.
> How about data? Restoring the snapshot taken on a 0.7.x box to a 0.8.x
> should work, shouldn't it?
>
> On Tue, May 10, 2011 at 2:25 PM, Jonathan E
It looks like this will happen if it tries to replay a mutation for a
dropped keyspace (dropped CFs are handled correctly).
Created https://issues.apache.org/jira/browse/CASSANDRA-2631 to fix.
On Wed, Apr 27, 2011 at 6:22 AM, Subscriber wrote:
> Hi,
> I'm using Cassandra 0.7.4 on a three node cl
I just edited the MessagingServices.java and OutboundTcpConnection.java
files in 0.8.0beta 2 and build it successfully using Ant (I just ran the ant
command in the apache-cassandra-0.8.0-beta2-src directory). I need some help
with how to deploy the newly build binaries to a new Cassandra cluster to
Has anybody successfully used EC2 Snitch for cross-region deployments on
EC2? Brandon Williams has not recommended using this just yet, but I was
curious if anybody is using it with 0.8.0.
Also, the snitch just let's the cluster automatically discover what the
different regions (aka data centers)
I was looking in the wrong place, the code expects the data directory for the
system keyspace to be empty if it could not read from the LocationInfo CF.
Created a patch here https://issues.apache.org/jira/browse/CASSANDRA-2632 to
see if it can be changed.
In the mean time try removing all the
Hi Praveen,
> The import only works on fresh system
> and imports from cassandra.yaml file.
Thanks for this information. What do you mean by a fresh system? A
system that was just installed, configured, and launched, with no any
other user-defined keyspaces? So in other words, I can only add o
What version and what were the values for RecentBloomFilterFalsePositives and
BloomFilterFalsePositives ?
The bloom filter metrics are updated in SSTableReader.getPosition() the only
slightly odd thing I can see is that we do not count a key cache hit a a true
positive for the bloom filter. If
try "ant artifacts" that will package up the same bin and src releases into the
build dir you see on the website.
Cheers
-
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle.com
On 11 May 2011, at 12:42, Sameer Farooqui wrote:
> I just edited the
see conf/schema-sample.txt it's a script that can be passed to the cli (has an
example there) and you can also paste the text into the cli if you want to.
The cli has a bunch of online help as well.
Hope that helps.
-
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
ht
45 matches
Mail list logo