Hi all,
We recently went through an upgrade from 0.7.0 to 1.2.13
Everything went well, except for one issue.
We have multiple column families for one keyspace.
Across these CFs there is one column that has the same index key.
The issue is that the index areaManagerId_idx is unique per CF, but
Hi there,
I have this table where I'm inserting timeseries values with a TTL of
86400*7 (1week):
CREATE TABLE metrics_5min (
object_id varchar,
metric varchar,
ts timestamp,
val double,
PRIMARY KEY ((object_id, metric), ts)
)
WITH gc_grace_seconds = 86400
AND compaction = {'class':
Hi Vincent,
Is that a good pattern for Cassandra? Is there some compaction tunings
I should take into account?
Actually it depends on how you use Cassandra :). If you use it as
key-value storage TTL works fine. But if you would use rather complex
CQL queries to this table I not sure that it
Hi,
Most of the queries to that table are just getting a range of values for a
metric:
SELECT val FROM metrics_5min WHERE uid = ? AND metric = ? AND ts = ? AND
ts = ?
I'm not sure from the logs what kind of compactions they are. This is what
I see in system.log (grepping for that specific
Since you are using LeveledCompactionStrategy there is no major/minor
compaction - just compaction.
Leveled compaction does more work - your logs don't look unreasonable to me
- the real question is whether your nodes can keep up w the IO. SSDs work
best.
BTW if you never delete and only ttl
Hello
I am having raw in which approximately 100 values is written per minute.
Those columns are then deleted ( it contains active records list ).
When i am trying to execute get_count on that raw i get transaction timeout
, even while the raw is empty.
I dont see anything in cassandra log on
Heya!
I’ve been observing some strange and worrying behaviour all this week with row
cache hits taking hundreds of milliseconds.
Cassandra 1.2.15, Datastax CQL driver 1.0.4.
EC2 m1.xlarge instances
RF=3, N=4
vnodes in use
key cache: 200M
row cache: 200M
row_cache_provider:
Take a look at the DataStax Enterprise Security Management.
http://www.datastax.com/documentation/datastax_enterprise/4.0/datastax_enterprise/sec/secDSE.html
-- Jack Krupansky
From: Check Peck
Sent: Friday, April 4, 2014 11:54 PM
To: user
Subject: Securing Cassandra database
Hi All,
We
Hi all.
To move to a multi-dc setup, I am in the process of preparing our
independent production DC's.
Part of this means moving from SimpleStragtegy (RF=5) to
NetworkTopologyStrategy, but I'm still a bit confused as to some core
aspects of replication.
The setup will be basic,
- DC_NSW will
