One option could be to set up two data centers and have two separate keyspaces, one for today data and the other for historical data.
You can write to the today_data keyspace with a TTL of 24 hours then write the same data to the historical_data keyspace. You then set up your replication to have the today_data keyspace only replicate to the host with the trading application then have the historical_data only replicate to the two node cluster. From: Vero Kato <vero.ka...@gmail.com> Reply-To: <user@cassandra.apache.org> Date: Friday, March 25, 2016 at 2:09 PM To: <user@cassandra.apache.org> Subject: apache cassandra for trading system 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
