You can use keyspaces with multiple data centers to get what you want. That said, if you're going to use only 1 node, I don't think Cassandra is the right fit for you.
http://rustyrazorblade.com/2013/09/cassandra-faq-can-i-start-with-a-single-node/ On Fri, Mar 25, 2016 at 11:09 AM Vero Kato <vero.ka...@gmail.com> wrote: > hi, we are building trading system and we want to use cassandra as our > database. > we want this set-up: > one node which stored one day set of data which will be running on the > same host as trading application > two nodes which store all data (for the current date and historical) which > will be running on other boxes. > > can you please suggest how easily it will be to have this set-up? i.e. we > have three nodes, but one of them (on the same box where our app located) > will be discarding all historical data which are older than one day? > > > thanks >
