Apache Cassandra is an open source distributed database management system. It is designed to handle very large amounts of data spread out across many commodity servers while providing a highly available service with no single point of failure. It is a NoSQL solution.

learn more… | top users | synonyms

1
vote
2answers
387 views

How does Apache Cassandra handle dynamic column set conflicts?

I know that each column in Apache Cassandra has a timestamp attached and that read conflicts for a single column is resolved deterministically by looking at timestamp or by comparing the value. Let's ...
7
votes
2answers
9k views

What is a good way to copy data from one Cassandra ColumnFamily to another on the same Keyspace (like SQL's INSERT INTO)?

Trying to find a way to easily transfer all the rows from a Cassandra ColumnFamily/Table to another. The COPY command, as I understand, is a good option. However, as it dumps all the data to .csv on ...
1
vote
1answer
3k views

Cassandra: Request did not complete within rpc_timeout

i was working with Cassandra 1.2.4 probably, after restoring some key-space when i tried to query in a key-space it gave me Request did not complete within rpc_timeout so i checked system.log & ...
3
votes
1answer
13k views

Cassandra - Query a column with collection type

I am pretty new to cassandra, so pardon me if this turns out to be a silly question. I have a table structure as below CREATE TABLE data_points ( id text PRIMARY KEY, created_at timestamp, ...
12
votes
1answer
301 views

Cassandra multidatacenter configuration with 1 external ip

I'm trying to setup a multi-datacenter Cassandra cluster. The problem is that my datacenters have only 1 external IP (wan IP), I can setup port forwarding on the data centers switchs to access each ...
0
votes
2answers
3k views

Cassandra in multiple data center - EC2MultiRegionSnitch

I was reading article from : http://www.datastax.com/docs/1.0/cluster_architecture/replication#networktopologystrategy and I have a question about - EC2MultiRegionSnitch. I did not understand it well. ...
50
votes
5answers
16k views

Which database could handle storage of billions/trillions of records?

We are looking at developing a tool to capture and analyze netflow data, of which we gather tremendous amounts of. Each day we capture about ~1.4 billion flow records which would look like this in ...
7
votes
1answer
4k views

What are the practical limitations on a column family in Cassandra?

In Cassandra, it's not recommended to have more than a few thousand column families, let's say 2,000 for the sake of argument. In cases where more than 2,000 types of data need to be persisted, one ...
2
votes
1answer
201 views

Which database to use? [closed]

Hey there. I am looking for a free to use for commercial website database that should have these design features, in the given order: Auto-Sharding (getting more free space by adding more server ...
2
votes
0answers
282 views

Strugling with updating a cassandra row in FluentCassandra

I have this problem with using Fluent Cassandra in a test application. All I want to do is set the IsOnline field to true inside the SignIn method, but I keep getting the exception supercolumn ...
2
votes
1answer
193 views

Cassandra upgrade/repair issues in migration

I wanted to migrate part of the column families in a cluster to a new cluster. I made a snapshot of the source cluster and copied the data, made a new cluster with the same name, same number of nodes ...
4
votes
2answers
263 views

Which database system can break me free?

I am currently running a MySQL Database for logging and analyzing those logs. My current table schema looks like this: CREATE TABLE `mylogs` ( `transfer_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ...
-4
votes
2answers
616 views

How can I generate Cassandra data model from a MySQL schema?

Is there a tool for generating a Cassandra model from a MySQL database?
0
votes
1answer
341 views

Cassandra cqlsh browser queries possible only in bytes

I am using Cassandra database through cqlsh client on Linux. I can make only queries with values given as bytes, but I would like to search with the client like in SQL where everything is Strings. ...
1
vote
2answers
1k views

Commercial database systems versus open source database systems [closed]

Can anyone tell me what are the reasons for buying a commercial database system and not using an open-source free version? The reason for my question is that: Commercial systems cost upwards of ...
2
votes
1answer
3k views

What is different bettween Cassandra NoSQL data model and SQL data model

can any one tell. cassandra data model and sql data model how we can define row and column with cassandra data model?
10
votes
2answers
2k views

What are the penalties of using many (thousands) of column families or keyspaces in Cassandra?

I am in the process of evaluating the best design for our Cassandra installation. There is not so much information out there on the Internet about using the first two levels of access that Cassandra ...
13
votes
5answers
2k views

Infrastructure for Highly Concurrent, High Write DB

My requirements are: 3000 Connections 70-85% Write vs Read Currently, we are maxing out a High-CPU, Extra Large Instance at 700 connections. All 8 cores are maxed. We think it's the number of ...
4
votes
2answers
2k views

Cassandra encryption at rest

I need to store some sensitive data in Cassandra and require it to be encrypted at rest. Is it likely Cassandra would function normally on top of a Linux encrypted file system (something like the open ...
5
votes
2answers
3k views

“phpMyAdmin” for Cassandra

Is there a tool like phpMyAdmin for RDBMS-MySQL for a Cassandra DB? I know that there is less "runtime" config possible (column families can not be edited at runtime etc.). Nevertheless, it would be ...