Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [cassandra]

22 questions
7
votes
3 answers

My Cassandra consultant left me and now I'm thinking about reverting to mysql

I run a middle size community and some time ago I started to develop social capabilities such as follow, status update, wall etc. For some reason i thought that Cassandra was the right tool for the job so I looked online for a Cassandra developer…
sathia
  • 173
  • 4
6
votes
5 answers

Should I use a relational datamodel or Cassandra with ColumnFamily based indexes?

Currently we are working on some storage problems for log data from various servers and communication message logs (HTTP(S), XMPP). There will be many write operations and for read operations we will use search queries with filters. Should we stick…
fgakk
  • 193
  • 5
5
votes
1 answer

Achieving scalability and ACID with a RDBMS to NoSQL streaming solution

My understanding is that the main feature Cassandra has to offer is linear performance at any scale; meaning that if I know 1 C* node can handle 500 queries or commands per second from my app, then I also can rest assured that 100 C* nodes added to…
hotmeatballsoup
  • 51
  • 12
5
votes
1 answer

Using key-value NoSQL DBs relationally

I am new to NoSQL and have always heard of "key-value" DBs like Cassandra or Riak and expected their tables to literally have two columns: a key-col and a value-col. I just started working at a new shop where the senior engineers chose Cassandra as…
smeeb
  • 4,820
  • 10
  • 30
  • 49
5
votes
1 answer

Economics of scaling, denormalizing NoSQL for personalized content

I am using Cassandra for a data intensive app. With relatively little operations and deployment experience, the expertise I am looking for is someone that can read the example below and decide whether I am overlooking simpler solutions, or if the…
Ar415
  • 213
  • 1
  • 5
4
votes
0 answers

Expiring counters in Cassandra

So I know that TTL is not available for counters because of design reasons and I've read https://issues.apache.org/jira/browse/CASSANDRA-2103 as well as some other SO questions regarding this but there seems to be no clear answer(unless I am missing…
Mikael
  • 141
  • 2
4
votes
1 answer

How should I store usernames and passwords for user login using php/cassandra?

I am new to NOSQL and Cassandra. I am not sure if I should store usernames and password in Cassandra. If I should, what is the best way to do that? I am getting lots of conflicting ideas from research. I want to set it up to accommodate a large…
Nick
  • 49
  • 3
4
votes
2 answers

Using HBase or Cassandra for a token server

I've been trying to figure out how to use HBase/Cassandra for a token system we're re-implementing. I can probably squeeze quite a lot more from MySQL, but it just seems it has come to clinging on to the wrong tool for the task just because we know…
crippy
3
votes
3 answers

When dealing with tens of billions of rows in a web app table, would a NoSQL database be noticeably faster than a relational one?

I'm currently designing a conceptual web app, where users can submit posts, comments, and "like"/"dislike" both of those. However, I am not sure of how to store the (dis)likes, because of how many there could be and how many queries would be run on…
tomatocan
  • 39
  • 2
3
votes
0 answers

Realtime layered time data storage and calculations

I am having a hard time trying to figure out the best way to report on and calculate layered time data. The problem: A person can sign in multiple times, during this sign in there are multiple statuses a person can be a part of. These statuses can…
Jared Mackey
  • 163
  • 5
3
votes
4 answers

Are NoSQL databases the best choice for more efficiently querying large amounts of data?

We are planning to build a travel website in which we will be integrating multiple APIs (eg. DOTW, GTA, Expedia) for Hotels. I have initially tried to use MySQL but since there are huge amounts of data in hotels and it may contain numerous "one to…
Ankur Jain
  • 139
  • 4
2
votes
3 answers

Where should I include comments in my "self-documenting code"?

I'm currently developing a web-app by myself and have made it a point to use descriptive variable and method names (sometimes at the expense of brevity) in order to minimize commenting. The plan was to code each method using this strategy, then…
Kevin
  • 857
  • 1
  • 7
  • 10
2
votes
0 answers

Initializing Cassandra schema

Recently I have started working on a project in which we are using Cassandra. It's a quite a new project, so we haven't decided how to initialize the schema. We are using Docker and Kubernetes. I've read many articles stating a good solution is to…
Forin
  • 129
  • 5
2
votes
1 answer

Exploiting Apache Spark Data

and sorry if the question seems a bit naive. I'm currently reading tutorials about Kafka & Spark and there's something I can't figure out : how to exploit / expose the data Spark received. Here's what I'm trying to understand : A lot of events <=>…
Javier92
  • 123
  • 3
2
votes
1 answer

Near real-time analytics from Cassandra with frequent updates

We have an activity metrics page where users can select a date period and see other user's aggregated activity (by action) and optionally filter everything by 4 or 5 fields. Actions happen sequentially, but one of the fields is "Tags" and the user…
Federico Pugnali
  • 129
  • 2
1
2