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
