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.
0
votes
0answers
31 views
If local data center nodes are down then it will get the data from other data center replica nodes?
I have recently started using Cassandra in our Production environment. We have a 24 node cross colo cluster with replication factor of 4. We have 12 nodes in PHX colo and 12 nodes in SLC colo. And ...
0
votes
0answers
59 views
Unable to fetch recently inserted entries via Astyanax in cassandra
I'm using Cassandra server with random partitioner. Table(Column family) has a col1 and timestamp column as one of the secondary indexes. Column family has 400000 rows aprox.
Number of rows returned ...
26
votes
5answers
2k 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 ...
3
votes
1answer
230 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
139 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 ...
0
votes
0answers
127 views
Migrating from MySQL to Cassandra without DataStax
Currently have a MySQL DB used by a Java app. As we are seeing growth, looking at feasibility of moving to Cassandra and how expensive the move would be.
I understand that we will have to heavily ...
2
votes
0answers
118 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
93 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 ...
3
votes
2answers
161 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 ...
-3
votes
2answers
219 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
202 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.
...
0
votes
2answers
284 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 ...
1
vote
1answer
470 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?
9
votes
2answers
474 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 ...
9
votes
5answers
657 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
421 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 ...
4
votes
2answers
1k 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 ...
