News for hackers. Stuff that matters.
Re:Ask HN: What DB to use for huge time series? by sdab on Thursday September 25, 2014 @04:03PM (#8369419)
In this case, I would still recommend Cassandra. It can easily handler the data sizes you mention as well as the write rates you imply further down the thread.

Cassandra has a nice and simple architecture (every node is identical, no zookeeper roles etc), high write performance and scalability [1], and is fairly robust. My main piece of advice is to get the tables correctly set up. You need to know exactly what queries you want to make and design a table around that query (Cassandra only allows performant queries to be made, unless you go out of your way to set a flag). Whether a query is possible or performant depends on the key of the rows for the table, which may be a composite key. Take a look at the cassandra documentation for more details.

1. http://techblog.netflix.com/2011/11/benchmarking-cassandra-s...

Re:Ask HN: What DB to use for huge time series? by BWStearns on Thursday September 25, 2014 @04:14PM (#8369486)
Thanks a ton. I am leaning towards a solution that involves Cassandra. What would you say about using something on top of it like Blueflood?
Re:Ask HN: What DB to use for huge time series? by sdab on Thursday September 25, 2014 @04:48PM (#8369660)
I havent used Blueflood, so I couldnt say but it looks like an interesting project.